Database Integration: the Key to Data Interoperability

Most of new databases are no more built from scratch, but re-use existing data from several autonomous data stores. To facilitate application development, the data to be re-used should preferably be redefined as a virtual database, providing for the logical unification of the underlying data sets. This unification process is called database integration. This chapter provides a global picture of the issues raised and the approaches that have been proposed to tackle the problem.

[1]  Anthony Kosky,et al.  WOL: a language for database transformations and constraints , 1997, Proceedings 13th International Conference on Data Engineering.

[2]  Stefano Spaccapietra,et al.  On Spatial Database Integration , 1998, Int. J. Geogr. Inf. Sci..

[3]  Dennis McLeod,et al.  On using historical update information for instance identification in federated databases , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[4]  Christine Collet,et al.  Resource integration using a large knowledge base in Carnot , 1991, Computer.

[5]  Laks V. S. Lakshmanan,et al.  On the Logical Foundations of Schema Integration and Evolution in Heterogeneous Database Systems , 1993, DOOD.

[6]  Chris Clifton,et al.  Semantic Integration in Heterogeneous Databases Using Neural Networks , 1994, VLDB.

[7]  Uwe Hohenstein,et al.  A Generative Approach to Database Federation , 1997, ER.

[8]  Ming-Chien Shan,et al.  Object Identification in Multidatabase Systems , 1992, DS-5.

[9]  Laks V. S. Lakshmanan,et al.  SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems , 1996, VLDB.

[10]  Stuart E. Madnick,et al.  Conceptualizing Semantic Interoperability: A Perspective From the Knowledge Level , 1996, Int. J. Cooperative Inf. Syst..

[11]  Hans-Jörg Schek,et al.  Object Algebra and Views for Multi-Objectbases , 1992, IWDOM.

[12]  James A. Larson,et al.  A Theory of Attribute Equivalence in Databases with Application to Schema Integration , 1989, IEEE Trans. Software Eng..

[13]  Ling Liu,et al.  Accessing heterogeneous data through homogenization and integration mediators , 1997, Proceedings of CoopIS 97: 2nd IFCIS Conference on Cooperative Information Systems.

[14]  Peter Scheuermann,et al.  Role-based Query Processing in Multidatabase Systems , 1994, EDBT.

[15]  Erich J. Neuhold,et al.  ViewSystem: integrating heterogeneous information bases by object-oriented views , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[16]  Philippe Thiran,et al.  Interoperation of independent, heterogeneous and distributed databases. Methodology and CASE support: the InterDB approach , 1998, Proceedings. 3rd IFCIS International Conference on Cooperative Information Systems (Cat. No.98EX122).

[17]  Renée J. Miller,et al.  Understanding schemas , 1993, Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems.

[18]  Paolo Atzeni,et al.  MDM: a multiple-data model tool for the management of heterogeneous database schemes , 1997, SIGMOD '97.

[19]  Michael R. Genesereth,et al.  Infomaster: an information integration system , 1997, SIGMOD '97.

[20]  Nick Roussopoulos,et al.  Interoperability of multiple autonomous databases , 1990, CSUR.

[21]  Tiziana Catarci,et al.  Materializing the Web , 1998, Proceedings. 3rd IFCIS International Conference on Cooperative Information Systems (Cat. No.98EX122).

[22]  Yann Dupont.  Resolving Fragmentation Conflicts in Schema Integration , 1994, ER.

[23]  Stéphane Bressan,et al.  The Context Interchange mediator prototype , 1997, SIGMOD '97.

[24]  Gio Wiederhold,et al.  Flexible relation: an approach for integrating data from multiple, possibly inconsistent databases , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[25]  Mike P. Papazoglou,et al.  A Scalable Architecture for Autonomous Heterogeneous Database Interactions , 1995, VLDB.

[26]  Christophe Nicolle,et al.  Multi-Data Models Translations in Interoperable Information Systems , 1996, CAiSE.

[27]  Won Kim,et al.  Modern Database Systems: The Object Model, Interoperability, and Beyond , 1995, Modern Database Systems.

[28]  Vipul Kashyap,et al.  InfoSleuth: agent-based semantic integration of information in open and dynamic environments , 1997, SIGMOD '97.

[29]  Peter M. G. Apers,et al.  On the Applicability of Schema Integration Techniques to Database Interoperation , 1996, ER.

[30]  Hector Garcia-Molina,et al.  Template-based wrappers in the TSIMMIS system , 1997, SIGMOD '97.

[31]  Vipul Kashyap,et al.  So Far (Schematically) yet So Near (Semantically) , 1992, DS-5.

[32]  Zahir Tari,et al.  Object normal forms and dependency constraints for object-oriented schemata , 1997, TODS.

[33]  Fèlix Saltor,et al.  Overcoming Schematic Discrepancies in Interoperable Databases , 1992, DS-5.

[34]  Jeffrey D. Ullman,et al.  Capability based mediation in TSIMMIS , 1998, SIGMOD '98.

[35]  Zoubida Kedad,et al.  Using Linguistic Knowledge in View Integration: Toward a Third Generation of Tools , 1997, Data Knowl. Eng..

[36]  Jennifer Widom,et al.  Object exchange across heterogeneous information sources , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[37]  Silvana Castano,et al.  Semantic dictionary design for database interoperability , 1997, Proceedings 13th International Conference on Data Engineering.

[38]  Alexandra Poulovassilis,et al.  A Formal Framework for ER Schema Transformation , 1997, ER.

[39]  Vincent Englebert,et al.  Contribution to the Reverse Engineering of OO Applications Methodology and Case Study , 1997, DS-7.

[40]  Gunter Saake,et al.  Integration of Inheritance Trees as Part of View Generation For Database Federations , 1996, ER.

[41]  Erich J. Neuhold,et al.  Database integration using the open object-oriented database system VODAK , 1995 .

[42]  Mike P. Papazoglou,et al.  A translation protocol achieving consensus of semantics between cooperating heterogeneous database systems , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[43]  Chris Clifton,et al.  Experience with a Combined Approach to Attribute-Matching Across Heterogeneous Databases , 1997, DS-7.

[44]  Dennis McLeod,et al.  Dynamic classificational ontologies for discovery in cooperative federated databases , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[45]  Stefano Spaccapietra,et al.  Conflicts and correspondence assertions in interoperable databases , 1991, SGMD.

[46]  Aris M. Ouksel,et al.  Coordinating knowledge elicitation to support context construction in cooperative information systems , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[47]  Peter C. Lockemann,et al.  System Guided View Integration for Object-Oriented Databases , 1992, IEEE Trans. Knowl. Data Eng..

[48]  Amihai Motro,et al.  Superviews: Virtual Integration of Multiple Databases , 1987, IEEE Transactions on Software Engineering.

[49]  Yannis Papakonstantinou,et al.  Object Fusion in Mediator Systems , 1996, VLDB.

[50]  Joseph Albert,et al.  Data integration in the RODIN multidatabase system , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[51]  Hongjun Lu,et al.  Discovering and Reconciling Semantic Conflicts: A Data Mining Perspective , 1997, DS-7.

[52]  Zahir Tari,et al.  Advances in Object-Oriented Data Modeling , 2000 .

[53]  Susan D. Urban.  A semantic framework for heterogeneous database environments , 1991, [1991] Proceedings. First International Workshop on Interoperability in Multidatabase Systems.

[54]  Paolo Missier,et al.  Extending a Multidatabase Manipulation Language to Resolve Schema and Data Conflicts , 1995, DS-6.

[55]  Alia I. Abdelmoty,et al.  Towards maintaining consistency of spatial databases , 1997, CIKM '97.

[56]  Fèlix Saltor,et al.  A structure based schema integration methodology , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[57]  Erich J. Neuhold,et al.  Knowledge Based Integration of Heterogeneous Databases , 1992, DS-5.

[58]  Roger King,et al.  Using Object Matching and Materialization to Integrate Heterogeneous Databases , 1999, CoopIS.

[59]  Zahir Tari,et al.  The Reengineering of Relational Databases Based on Key and Data Correlations , 1997, DS-7.

[60]  Vipul Kashyap,et al.  Observer: an approach for query processing in global information systems based on interoperation across pre-existing ontologies , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.

[61]  Martin Andersson,et al.  Searching for Semantics in COBOL Legacy Applications , 1997, DS-7.

[62]  Phan Minh Dung,et al.  Integrating data from possibly inconsistent databases , 1996, Proceedings First IFCIS International Conference on Cooperative Information Systems.