Ludwig-Maximilians-Universität München, Institut für Informatik

Technical Report 93-07

Integration of Relational Databases in a Multidatabase System based on Schema Enrichment
April 1993
Daniel A. Keim
Hans-Peter Kriegel
Andreas Miethsam
Institut für Informatik
Universität München
Leopoldstr. 11B
D-80802 München (Germany)
interoperability of database systems, federated databases, multidatabase systems, schema enrichment, schema transformation, translation of operations, object-oriented database systems, object-oriented database query language
In this paper, we describe a framework for an object-oriented modeling of meta information and its use for the integration of heterogeneous databases with the goal of their interoperation. The meta information consists of all types of information necessary to access and interoperate the participating databases. As part of the meta information, we model the common properties and differences of the various data models and concrete systems. Additionally, we also include information to semantically enhance the schemas of the participating databases providing the basis for a (semi-)automatic schema transformation. We describe the semantic enrichment of a relational schema using additional information deduced from its underlying entity-relationship design schema. The enhanced relational schemas may be automatically transformed into corresponding schemas in the common data model which in our case is the object-oriented model. Queries using the created object-oriented schema may be automatically translated into equivalent SQL queries for the original relational schema.

Bei Problemen, Vorschlägen schicken Sie bitte eine eMail an
For problems and suggestions send an email message to
Robert Stabl (28.11.1994)