DYNAMIC DATABASE INTEGRATION IN A JDBC DRIVER

Terrence Mason, Ramon Lawrence

Abstract

Current integration techniques are unsuitable for large-scale integrations involving numerous heterogeneous data sources. Existing methods either require the user to know the semantics of all data sources or they impose a static global view that is not tolerant of schema evolution. These assumptions are not valid in many environments. We present a different approach to integration based on annotation. The contribution is the elimination of the bottleneck of global view construction by moving the complicated task of identifying semantics to local annotators instead of global integrators. This allows the integration to be more automated, scaleable, and rapidly deployable. The algorithms are packaged in an embedded database engine contained in a JDBC driver capable of dynamically integrating data sources. Experimental results demonstrate that the Unity JDBC driver efficiently integrates data located in separate data sources with minimal overhead.

References

  1. Collet, C., Huhns, M., and Shen, W.-M. (1991). Resource Integration Using a Large Knowledge Base in Carnot. IEEE Computer, 24(12):55-62.
  2. Covitz, P., Hartel, F., Schaefer, C., Coronado, S., Fragoso, G., Sahni, H., Gustafson, S., and Buetow, K. (2003). caCORE: A common infrastructure for cancer informatics. Bioinformatics, 19(18):2404-2412.
  3. Decker, S., Erdmann, M., and Studer, R. (1998). ONTOBROKER: Ontology based access to distributed and semi-structured information. In Database Semantics - Semantic Issues in Multimedia Systems, volume 138 of IFIP Conference Proceedings. Kluwer.
  4. Dragut, E. and Lawrence, R. (2004). Composing mappings between schemas using a reference ontology. In ODBASE.
  5. Goh, C., Bresson, S., Madnich, S., and Siegel, M. (1999). Context Interchange: New Features and Formalisms for the Intelligent Integration of Information. ACM Transactions on Information Systems, 17(3):270-293.
  6. Goldman, R., Shivakumar, N., Venkatasubramanian, S., and Garcia-Molina, H. (1998). Proximity Search in Databases. In VLDB, pages 26-37.
  7. Haas, L., Lin, E., and Roth, M. (2002). Database Integration through Database Federation. IBM Systems Journal, 41(4):578-596.
  8. Halevy, A. (2001). Answering queries using views: A survey. VLDB Journal, 10(4):270-294.
  9. Kirk, T., Levy, A., Sagiv, Y., and Srivastava, D. (1995). The Information Manifold. In AAAI Spring Symposium on Information Gathering.
  10. Lenzerini, M. (2002). Data Integration: A Theoretical Perspective. In PODS, pages 233-246.
  11. Li, C., Yerneni, R., Vassalos, V., Garcia-Molina, H., Papakonstantinou, Y., Ullman, J., and Valiveti, M. (1998). Capability Based Mediation in TSIMMIS. In ACM SIGMOD, pages 564-566.
  12. Rahm, E. and Bernstein, P. (2001). A survey of approaches to automatic schema matching. VLDB Journal, 10(4):334-350.
  13. Sheth, A. and Larson, J. (1990). Federated Database Systems for Managing Distributed, Heterogenous and Autonomous Databases. ACM Computing Surveys, 22(3):183-236.
  14. Ullman, J. (1997). Information Integration Using Logical Views. In ICDT'97, volume 1186 of LNCS, pages 19- 40.
  15. Wald, J. and Sorenson, P. (1984). Resolving the Query Inference Problem Using Steiner Trees. TODS, 9(3):348-368.
  16. Zeller, H. and Gray, J. (1990). An adaptive hash join algorithm for multiuser environments. In VLDB 1990, pages 186-197.
Download


Paper Citation


in Harvard Style

Mason T. and Lawrence R. (2005). DYNAMIC DATABASE INTEGRATION IN A JDBC DRIVER . In Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-19-8, pages 326-333. DOI: 10.5220/0002552103260333


in Bibtex Style

@conference{iceis05,
author={Terrence Mason and Ramon Lawrence},
title={DYNAMIC DATABASE INTEGRATION IN A JDBC DRIVER},
booktitle={Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2005},
pages={326-333},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002552103260333},
isbn={972-8865-19-8},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Seventh International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - DYNAMIC DATABASE INTEGRATION IN A JDBC DRIVER
SN - 972-8865-19-8
AU - Mason T.
AU - Lawrence R.
PY - 2005
SP - 326
EP - 333
DO - 10.5220/0002552103260333