A DATABASE INTEGRATION SYSTEM BASED ON GLOBAL VIEW GENERATION

Uchang Park, Ramon Lawrence

2007

Abstract

Database integration is a common and growing challenge with the proliferation of database systems, data warehouses, data marts, and other OLAP systems in organizations. Although there are many methods of sharing data between databases, true interoperability of database systems requires capturing, comparing, and merging the semantics of each system. In this work, we present a database integration system that improves on the database federation architecture by allowing domain administrators to simply and efficiently capture database semantics. The semantic information is combined using a tool for producing a global view. Building the global view is the bottleneck in integration because there are few tools that support its construction, and these tools often require sophisticated knowledge and experience to operate properly. The technique and tool presented is simple and powerful enough to be used by all database administrators, yet expressive enough to support the majority of integration queries.

References

  1. Aumueller, D., Do, H.H.D., Massmann, S. and Rahm, E.R., 2005, Schema and Ontology Matching with COMA++. In SIGMOD.
  2. Batini, C., Lenzerini, M., Navathe, S., 1986, A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys 18, 323.364
  3. Chawathe, S., et al., 1994, The TSIMMIS Project: Integration of Heterogeneous Information Sources, Proceedings of the 10th Meeting of the Information Processing of Japan, pp. 7-18.
  4. Collet, C., Huhns, M., Shen, 1991, W.M.: Resource Integration Using a Large Knowledge Base in Carnot. IEEE Computer 24, 55-62.
  5. Data Integration Projects World-Wide, 2005, http://www.ifi.unizh.ch/staff/pziegler/IntegrationProje cts.html.
  6. Dragut, E. and Lawrence, R., 2004, Composing Mappings between Schemas using a Reference Ontology. In ODBASE, 783-800.
  7. Haas, L. M., Hernández, M.A., Ho, H., Popa, L. and Roth, M., 2005, Clio Grows Up: From Research Prototype to Industrial Tool. In SIGMOD, 805-810.
  8. Halevy, A., 2001, Answering Queries Using Views: A survey. VLDB Journal, 10 (4). 270-294.
  9. IBM, 2005, http://www.ibm.com, A Simple Introduction to Using DB2 Information Integrator with Oracle 9i.
  10. Josifovski, V., Schwarz, P.M., Haas, L.M.H. and Lin, E.T., 2002, Garlic: A New Flavor of Federated Query Processing for DB2. In SIGMOD, 524-532.
  11. Litwin, W., Mark, L. and Roussopoulos, M., 1990, Interoperability of Multiple Autonomous Databases. ACM Computing Surveys, 22 (3). 267-293.
  12. Mason, T. and Lawrence, R., 2005, Dynamic Database Integration in a JDBC Driver. In 7th International Conference on Enterprise Information Systems, 326- 333.
  13. MICROSOFT, 2005, http://www.microsoft.com/korea/ TechNet/biztalk/biztalka.asp
  14. Rahm, R. and Bernstein, P., 2004, A Survey of Approaches to Automatic Schema Matching, VLDB Journal, 10 (4). 334-350.
  15. Sheth, A., Larson, J., 1990, Federated Database Systems for Managing Distributed, Heterogenous and Autonomous Databases. ACM Computing Surveys 22, 183-236.
  16. UNITYJDBC, 2006, http://www.unityjdbc.com/, UnityJDBC - Integrate SQL Data Sources using a Single Query.
Download


Paper Citation


in Harvard Style

Park U. and Lawrence R. (2007). A DATABASE INTEGRATION SYSTEM BASED ON GLOBAL VIEW GENERATION . In Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-972-8865-88-7, pages 453-456. DOI: 10.5220/0002351404530456


in Bibtex Style

@conference{iceis07,
author={Uchang Park and Ramon Lawrence},
title={A DATABASE INTEGRATION SYSTEM BASED ON GLOBAL VIEW GENERATION},
booktitle={Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2007},
pages={453-456},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002351404530456},
isbn={978-972-8865-88-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Ninth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A DATABASE INTEGRATION SYSTEM BASED ON GLOBAL VIEW GENERATION
SN - 978-972-8865-88-7
AU - Park U.
AU - Lawrence R.
PY - 2007
SP - 453
EP - 456
DO - 10.5220/0002351404530456