Skip to main content

An a Priori Approach for Automatic Integration of Heterogeneous and Autonomous Databases

  • Conference paper
Database and Expert Systems Applications (DEXA 2004)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 3180))

Included in the following conference series:

Abstract

Data integration is the process that gives users access to multiple data sources through queries against a global schema. The semantic heterogeneity has been identified as the most important and toughest problem when integrating various sources. The mapping between the global schema and local schemas was done manually in the first generation of integrated systems, when ontologies are not used to make explicit data meaning. It is semi automatic when ontologies and ontology mappings are defined at integration level. In this paper, we propose a fully automatic integration approach based on ontologies. It supposes that each data source contains a formal ontology that references a shared ontology. The relationships between each local ontology and the shared ontology are defined at the database design time and also embedded in each source. We assume that a domain ontology exists, but each source may extend it by adding new concepts and properties. Our approach is currently prototyped in various environments: OODB, ORDB, and RDB.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bellatreche, L., Karlapalem, K., Mohania, M.: Some issues in design of data warehousing systems. In: Developing Quality Complex Data Bases Systems: Practices, Techniques, and Technologies, pp. 125–172. Idea Group Publishing, USA (2001)

    Google Scholar 

  2. Castano, S., Antonellis, V.: Semantic dictionary design for database interoperability. In: Proceedings of the International Conference on Data Engineering (ICDE), April 1997, pp. 43–54 (1997)

    Google Scholar 

  3. Castano, S., Antonellis, V., Vimercati, S.D.C.: Global viewing of heterogeneous data sources. IEEE Transactions on Knowledge and Data Engineering 13(2), 277–297 (2001)

    Article  Google Scholar 

  4. Chawathe, S.S., Garcia-Molina, H., Hammer, J., Ireland, K., Papakonstantinou, Y., Ullman, J.D., Widom, J.: The tsimmis project: Integration of heterogeneous information sources. In: Proceedings of the 10th Meeting of the Information Processing Society of Japan, March 1994, pp. 7–18 (1994)

    Google Scholar 

  5. Goh, C.H., Bressan, S., Madnick, E., Siegel, M.D.: Context interchange: New features and formalisms for the intelligent integration of information. ACM Transactions on Information Systems 17(3), 270–293 (1999)

    Article  Google Scholar 

  6. Guarino, N., Welty, C.A.: Ontological analysis of taxonomic relationships. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds.) ER 2000. LNCS, vol. 1920, pp. 210–224. Springer, Heidelberg (2000)

    Chapter  Google Scholar 

  7. Hakimpour, F., Geppert, A.: Global schema generation using formal ontologies. In: Spaccapietra, S., March, S.T., Kambayashi, Y. (eds.) ER 2002. LNCS, vol. 2503, pp. 307–321. Springer, Heidelberg (2002)

    Chapter  Google Scholar 

  8. Lawrence, R., Barker, K.: Integrating relational database schemas using a standardized dictionary. In: Proceedings of the ACM Symposium on Applied Computing (SAC), March 2001, pp. 225–230 (2001)

    Google Scholar 

  9. Levy, A.Y., Rajaraman, A., Ordille, J.J.: The world wide web as a collection of views: Query processing in the information manifold. In: Proceedings of the International Workshop on Materialized Views: Techniques and Applications (VIEW 1996), June 1996, pp. 43–55 (1996)

    Google Scholar 

  10. Omelayenko, B., Fensel, D.: A two-layered integration approach for product information in b2b e-commerce. In: Proceedings of the Second International Conference on Electronic Commerce and Web Technologies, September 2001, pp. 226–239 (2001)

    Google Scholar 

  11. Pierra, G.: Context-explication in conceptual ontologies: The plib approach. In: Proceedings of 10th ISPE International Conference on Concurrent Engineering: Research and Applications (ce 2003): Special Track on Data Integration in Engineering, July 2003, pp. 243–254 (2003)

    Google Scholar 

  12. Pierra, G., Potier, J.C., Sardet, E.: From digital libraries to electronic catalogues for engineering and manufacturing. International Journal of Computer Applications in Technology (IJCAT) 18, 27–42 (2003)

    Google Scholar 

  13. Reynaud, C., Giraldo, G.: An application of the mediator approach to services over the web. In: Special track ”Data Integration in Engineering, Concurrent Engineering (CE 2003) - the vision for the Future Generation in Research and Applications, July 2003, pp. 209–216 (2003)

    Google Scholar 

  14. Terracina, G., Ursino, D.: A uniform methodology for extracting type conicts and & subscheme similarities from heterogeneous databases. Information Systems 25(8), 527–552 (2000)

    Article  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Bellatreche, L., Pierra, G., Xuan, D.N., Hondjack, D., Ameur, Y.A. (2004). An a Priori Approach for Automatic Integration of Heterogeneous and Autonomous Databases. In: Galindo, F., Takizawa, M., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2004. Lecture Notes in Computer Science, vol 3180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30075-5_46

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-30075-5_46

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-22936-0

  • Online ISBN: 978-3-540-30075-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics