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

  • Ladjel Bellatreche
  • Guy Pierra
  • Dung Nguyen Xuan
  • Dehainsala Hondjack
  • Yamine Ait Ameur
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3180)


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.


Global Schema Domain Ontology Ontology Model Automatic Integration Local Ontology 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 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. 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. 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)CrossRefGoogle Scholar
  4. 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. 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)CrossRefGoogle Scholar
  6. 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)CrossRefGoogle Scholar
  7. 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)CrossRefGoogle Scholar
  8. 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. 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. 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. 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. 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. 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. 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)zbMATHCrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Ladjel Bellatreche
    • 1
  • Guy Pierra
    • 1
  • Dung Nguyen Xuan
    • 1
  • Dehainsala Hondjack
    • 1
  • Yamine Ait Ameur
    • 1
  1. 1.LISI/ENSMA FuturoscopeFrance

Personalised recommendations