A method for transforming relational schemas into conceptual schemas

A major problem with currently existing database systems is that there often does not exist a conceptual understanding of the data. Such an understanding can be obtained by describing the data using a semantic data model, such as the ER model. Consequently, there is a need for methods that translate a schema in a traditional data model into a conceptual schema. We present a method for translating a schema in the relational model into a schema in a conceptual model. We also show that the schema produced has the same information capacity as the original schema. The conceptual model used is a formalization of an extended ER model, which also includes the subtype concept.<<ETX>>

[1]  Sudhir K. Arora,et al.  Schema Translation Using the Entity-Relationship Approach , 1981, ER.

[2]  Jack Minker,et al.  Logic and Databases: A Deductive Approach , 1984, CSUR.

[3]  Richard Hull.  Relative Information Capacity of Simple Relational Database Schemata , 1986, SIAM J. Comput..

[4]  Kathi Hogshead Davis,et al.  Converting A Relational Database Model into an Entity-Relationship Model , 1987, ER.

[5]  Henri Briand,et al.  From Minimal Cover to Entity-Relationship Diagram , 1987, ER.

[6]  Shamkant B. Navathe,et al.  Abstracting Relational and Hierarchical Data with a Semantic Data Model , 1987, International Conference on Conceptual Modeling.

[7]  Liz Sonenberg,et al.  On Domain Independent Databases , 1988, Foundations of Deductive Databases and Logic Programming..

[8]  Jeffrey D. Ullman,et al.  Principles of database and knowledge-base systems, Vol. I , 1988 .

[9]  Charles W. Bachman.  A Personal Chronicle: Creating Better Information Systems, with Some Guiding Principles , 1989, IEEE Trans. Knowl. Data Eng..

[10]  Catriel Beeri,et al.  Formal Models for Object Oriented Databases , 1989, DOOD.

[11]  Johann A. Makowsky,et al.  Identifying Extended Entity-Relationship Object Structures in Relational Schemas , 1990, IEEE Trans. Software Eng..

[12]  Katalin Kalman,et al.  Implementation and Critique of an Algorithm which Maps a Relational Database to a Conceptual Model , 1991, CAiSE.

[13]  Departament de Llenguatges,et al.  Semantic Enrichment of Database Schemas: An Object Oriented Approach Mal6 Castellanos and Fklix Saltor , 1991 .

[14]  Paul Johannesson.  Schema integration, schema translation, and interoperability in federated information systems , 1993 .