On the Design and Maintenance of Optimized Relational Representations of Entity-Relationship Schemas

A method for obtaining optimized relational representations of database conceptual schemas in an extended entity-relationship model is first proposed. The method incorporates and generalizes a familiar heuristics to obtain good relational representations and also produces, for each relational structure, an explanation indicating which concepts it represents. Then, a redesign method that, given changes to the conceptual schema, generates a plan to modify the original representation and to organize the database state is described.

[1]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[2]  Antonio L. Furtado,et al.  The CHRIS consultant-a tool for database design and rapid prototyping , 1990, Inf. Syst..

[3]  Domenico Saccà,et al.  Equivalence and Mapping of Database Schemes , 1984, VLDB.

[4]  Antonio L. Furtado,et al.  Optimization of Relational Schemas Containing Inclusion Dependencies , 1989, VLDB.

[5]  Colette Rolland,et al.  An Expert System Approach to Information System Design , 1986, IFIP Congress.

[6]  Marco A. Casanova,et al.  An Analysis of Table Constraints in SQL2 Based on the Entity-Relationship Model , 1991, ER.

[7]  T. J. Teorey,et al.  A logical design methodology for relational databases using the extended entity-relationship model , 1986, CSUR.

[8]  Antonio L. Furtado,et al.  Updating Relational Views , 1985, Query Processing in Database Systems.

[9]  G. M. Nijssen,et al.  Conceptual schema and relational database design - a fact oriented approach , 1989 .

[10]  Etienne Pichat,et al.  Translation of an Extended Entity-Relationship Model into the Universal Relation with Inclusions Formalism , 1986, ER.

[11]  Henri Briand,et al.  Expert System for Translating an E-R Diagram into Databases , 1985, International Conference on Conceptual Modeling.

[12]  Elisabeth Métais,et al.  Semantic Modeling of Object Oriented Databases , 1991, VLDB.

[13]  Arie Shoshani,et al.  Representing extended entity-relationship structures in relational databases: a modular approach , 1992, TODS.

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

[15]  Shamkant B. Navathe,et al.  Conceptual Database Design: An Entity-Relationship Approach , 1991 .

[16]  C. J. Date.  A Guide to the SQL Standard , 1987 .

[17]  C. M. R. Leung,et al.  Relational database design using the NIAM conceptual schema , 1988, Inf. Syst..

[18]  Antonio Di Leva,et al.  Logical Design in Codasyl and Relational Environment , 1983, Methodology and Tools for Data Base Design.

[19]  Antonio L. Furtado,et al.  Enforcing Inclusion Dependencies and Referencial Integrity , 1988, VLDB.

[20]  Michael L. Brodie,et al.  A Prototyping Approach to Database Applications Development , 1984, IEEE Database Eng. Bull..

[21]  Gianfranco Ciardo,et al.  The Logical Design in the DATAID Project: The EASYMAP System , 1985, Computer-Aided Database Design: the DATAID approach.

[22]  Marco A. Casanova,et al.  An analysis of SQL integrity constraints from an entity-relationship model perspective , 1994, Inf. Syst..