A Data Model for Heterogeneous Data Sources

The information has been and still is a significant factor supporting decision making. In E-Business, distributed information needs to be integrated or inter operated to provide the unique view of information from disparate sources. The integration of data sources when the relevant databases have been designed dependently does not create heterogeneity problems. However, when databases have been designed independently, there are heterogeneity problems such as different terminology, data types, units of measurement, domains, scopes, and so on. Heterogeneous data integration requires a data model which is capable of describing data, schemas and contexts. This complexity suggests the need for a new data model having characteristics appropriate for supporting a mediated approach for the integration of databases and legacy systems. This paper presents the Mediated Data Model (MDM), a data model which is designed for describing data, schemas and contexts in the mediated approach for the integration of database and legacy systems. Its main feature is its ability to describe or represent heterogeneous data both schematically and semantically.

[1]  C. J. Date.  An introduction to database systems (7. ed.) , 1999 .

[2]  Uma Srinivasan.  A Framework for Conceptual Integration of Heterogeneous Databases , 1997 .

[3]  Renée J. Miller.  Using schematically heterogeneous structures , 1998, SIGMOD '98.

[4]  W. S. Luk,et al.  An object-oriented approach to query interoperability , 1996 .

[5]  Paolo Missier,et al.  Multidatabase languages , 1998 .

[6]  Stéphane Bressan,et al.  Introduction to Database Systems , 2005 .

[7]  Tsae-Feng Yu.  Information modeling and mediation languages and techniques for information sharing among heterogeneous information systems , 1998 .

[8]  Stuart E. Madnick,et al.  Working Paper Alfred P. Sloan School of Management Database Systems in a Dynamic Environment Database Systems in a Dynamic Environment Received Context Interchange: Overcoming the Challenges of Large-scale Interoperable Database Systems in a Dynamic Environment* , 2022 .

[9]  Won Kim,et al.  On resolving schematic heterogeneity in multidatabase systems , 1995, Distributed and Parallel Databases.

[10]  R. G. G. Cattell,et al.  Recent books , 2000, IEEE Spectrum.

[11]  Suvimol Mukviboonchai,et al.  An XML based approach for the integration of database and legacy systems , 2001 .

[12]  L. Henschen,et al.  The virtual data integrator: an object-oriented mediator for heterogeneous database integration , 1999 .

[13]  Wilhelm Hasselbring,et al.  Engineering federated information systems: report of EEFIS '99 workshop , 1999, SGMD.

[14]  Wilhelm Hasselbring,et al.  Engineering in federated information systems , 1999, SIGMOD 1999.

[15]  S. Adiga,et al.  Object-oriented databases , 1993 .

[16]  Mansur R. Kabuka,et al.  A new approach for the integration of heterogeneous databases and information systems , 1998 .

[17]  Larry Kerschberg,et al.  Dynamic meta-data support for information integration and sharing across heterogeneous databases , 1997 .