An Ontology-Based Approach for Exchanging Data Between Heterogeneous Database Systems

This paper presents an approach which allows data exchange between heterogonous databases. It targets at simultaneously semantic and structural heterogeneity. From the semantic point of view, this approach proposes an ontology based approach. On the one hand this ontology can be referenced by universal identifiers and acceded by queries; on the other hand, it can be exchanged between heterogonous databases systems. From the structural point of view, this approach is based on the use of a generic meta-schema, formalised in the EXPRESS language, and allowing the exchange of any instance of any database schema. Exchanged instances reference, as much as needed, the global unique identifiers defined by the ontology. However, the conversion of exchange files to the various target systems can be achieved in a generic manner (e.g. independently of the particular exchanged model). The interest of the EXPRESS language to achieve directly such a program is presented as well.

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

[2]  Thomas R. Gruber,et al.  Toward principles for the design of ontologies used for knowledge sharing? , 1995, Int. J. Hum. Comput. Stud..

[3]  Guy Pierra Représentation et échange de données techniques , 2000 .

[4]  Yamine Aït Ameur,et al.  An object oriented approach to represent behavioural knowledge in heterogeneous information systems , 2000, OOIS.

[5]  Hector Garcia-Molina,et al.  Distributed Databases , 1995, Encyclopedia of GIS.

[6]  Patrick Girard,et al.  Formal Specification and Metaprogramming in the EXPRESS Language , 1995, SEKE.

[7]  Klaus R. Dittrich,et al.  Object-Oriented DBMS and Beyond , 1997, SOFSEM.

[8]  Michael Stonebraker,et al.  The Implementation of Postgres , 1990, IEEE Trans. Knowl. Data Eng..

[9]  Laura M. Haas,et al.  Data-driven understanding and refinement of schema mappings , 2001, SIGMOD '01.

[10]  Ivar Jacobson,et al.  The unified modeling language reference manual , 2010 .

[11]  R GruberThomas Toward principles for the design of ontologies used for knowledge sharing , 1995 .

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

[13]  C. V. Ramamoorthy,et al.  Knowledge and Data Engineering , 1989, IEEE Trans. Knowl. Data Eng..

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

[15]  Alain Plantec Utilisation de la norme step pour la specification et la mise en oeuvre de generateurs de code , 1999 .

[16]  Douglas A. Schenck,et al.  Information modeling: the EXPRESS way , 1994 .

[17]  Axel Herbst,et al.  Long-term database support for EXPRESS data , 1994, Seventh International Working Conference on Scientific and Statistical Database Management.

[18]  Guy Pierra,et al.  Modélisation du contenu des catalogues de composants industriels : de la représentation implicite à la représentation explicite. , 2001 .

[19]  Guus Schreiber,et al.  KADS : a principled approach to knowledge-based system development , 1993 .

[20]  Peter P. Chen The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[21]  Terry A. Landers,et al.  An Overview of MULTIBASE , 1986, DDB.

[22]  Shamim A. Naqvi,et al.  Towards a Real Horn Clause Language , 1988, VLDB.

[23]  James E. Rumbaugh,et al.  Object-Oriented Modelling and Design , 1991 .

[24]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.

[25]  Craig A. Knoblock,et al.  Retrieving and Integrating Data from Multiple Information Sources , 1993, Int. J. Cooperative Inf. Syst..

[26]  Jennifer Widom,et al.  The TSIMMIS Project: Integration of Heterogeneous Information Sources , 1994, IPSJ.

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