Skip to main content

Integration Methodology for Heterogeneous Databases

  • Chapter

Abstract

During these last years, databases have been produced with respect to various user requirements and implemented by different technologies. The stored information is still valuable, but two important problems must be solved to create new target systems: these are database integration and legacy systems modernization. This paper presents a methodology that explicitly defines how the different integration steps must be inserted in the context of the evolution of legacy systems. The final section revisits the correspondence search problem in order to illustrate a particular important step of the integration methodology.

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

Buying options

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
Hardcover Book
USD   109.99
Price excludes VAT (USA)
  • Durable hardcover 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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Alhaji R., Documenting Legacy Relational Databases, in Advances in Conceptual Modeling, LNCS 1727, Springer, Nov. 1999.

    Google Scholar 

  2. Castano S., De Antonellis V., Fugini M.G., Pernici B., Conceptual Schema Analysis: Techniques and Applications, ACM Transactions on Database Systems, Vol. 23, no 3, Sept. 1998.

    Google Scholar 

  3. Conrad S., Saake G., Integrating Heterogeneous Databases, EDBT’98, Valencia, March 23, 1998.

    Google Scholar 

  4. Conrad S., Schmitt I., Tiirker C., Considering Integrity Constraints During Federated Database Design, in “Advances in Databases, BNCOD 16, LNCS 1405, Springer-Verlag, 1998.

    Google Scholar 

  5. Cornella-Dorda S., Wallnau K., Seacord R.C., Robert J., A Survey of Legacy Modernization Approaches, CMU/SEI-2000-TN-003.

    Google Scholar 

  6. Dieng R., Corby O., Giboin A., Golebiowska J., Matta N., Ribière M., Méthodes et Outils pour la Gestion des Connaissances, Dunod, Paris 2000.

    Google Scholar 

  7. Elmagarmid A., Rusinkiewicz M., and Shet A. (Eds), Management of Heterogeneous and Autonomous Database Systemes, Morgan Kaufmann Publishers, Inc., San Francisco, California, 1999.

    Google Scholar 

  8. Gabay J., Berhanou Gébré, La Conduite des Projets d’Evolution des Systèmes d’Information, InterEditions, 1999, Dunod Paris 1999.

    Google Scholar 

  9. Gruber T.R., http://www-ksl.stanford.edu/kst/what-is-an-ontology.html, 1997.

  10. Haines G., Carney D., Foreman J., Component Based Software development/COTS Integration, SEI, Software Technology Review, 1998.

    Google Scholar 

  11. Hull R., Managing Semantic Heterogeneity in Databases: A Theoretical Perspective, 16th ACM Symposium on Principles of Database Systems, Tuscon, Arizona, USA, 1997.

    Google Scholar 

  12. Jarke M., Lenzerini M., Vassiliou Y., Vassiliadis P., Fundamentals of Data Warehouses, Springer, ISBN 3–540–65365–1, 2000.

    Google Scholar 

  13. Kingston J., The DARPA High Performance Knowledge Bases Programme, In Knowledge Acquisition, Modelling and Management, 10th European Workshop, EKA Workshop ‘97, Sant Felin de Crixols, Catalonia, Spain, Plaza E.,. Benjamins R., (Eds), LNAI 1319, Springer-Verlag, 1997.

    Google Scholar 

  14. Lee Chiang, Chen Chia-Jung, Query Optimization in Multidatabase Systems Considering Schema Conflicts, in IEEE Transactions on Knowledge and Data Engineering, vol. 9, n°6, November/December 1997.

    Google Scholar 

  15. Lenzerini M., Description Logics and Their Relationships with Databases, Beeri C., Buneman P., (Eds), ICDT’99, LNCS 1540, Springer-Verlag Berlin Heidelberg, 1998.

    Google Scholar 

  16. Parent C., Spaccapietra S., Intégration de Bases de Données — Panorama des Problèmes et des Approches, in Ingénierie des Systèmes d’Information, Vol. 4, n. 3, p. 333–358, 1996.

    Google Scholar 

  17. http://www.comp.lancs.ac.uk/projects/renaissance/project/Documents4.html

    Google Scholar 

  18. Salzano G., Bestougeff H., Finding Related Information in Distributed Heterogeneous Systems, in Proceedings of 16th International CODATA Conference — Data Management in the Evolving Information Society, New Delhi, November 1998.

    Google Scholar 

  19. Salzano G., Bestougeff H., Construction et Génération d’Ontologies pour Fédérer des Bases de Données Relationnelles, Université de Marne-la-Vallée, Rapport de Recherche ISIS, RR-99–19, 1999.

    Google Scholar 

  20. Ullman J.D., Principles of Databases and Knowledge-Base Systems, Computer Science Press, 1989.

    Google Scholar 

  21. Velasco M., Martinez V., Lloréns J., de Amescua A., Automatic Domain Analysis: Generation of Domain Representation, Proceedings IFIP Conference, Vienne, 1998.

    Google Scholar 

  22. Visser P.R.S., Jones D.M., Bench-Capon T.J.M., Shave M.J.R., An analysis of Ontology Mismatches; Heterogeneity versus Interoperability, in “AAAI 1997 Spring Symposium on Ontological Engineering, Stanford University, California, USA”, Farquhar A., Grunninger M., ( Eds ), 1997.

    Google Scholar 

  23. Wiederhold G., Jannink J., Composing Diverse Ontologies, prepared for IFIP Working Group on Database 8th Working Conference on Database Semantics (DS-8), in Rotorua, New Zeland, Jan. 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer Science+Business Media Dordrecht

About this chapter

Cite this chapter

Salzano, G. (2002). Integration Methodology for Heterogeneous Databases. In: Bestougeff, H., Dubois, JE., Thuraisingham, B. (eds) Heterogeneous Information Exchange and Organizational Hubs. Springer, Dordrecht. https://doi.org/10.1007/978-94-017-1769-4_1

Download citation

  • DOI: https://doi.org/10.1007/978-94-017-1769-4_1

  • Publisher Name: Springer, Dordrecht

  • Print ISBN: 978-90-481-6030-3

  • Online ISBN: 978-94-017-1769-4

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics