An Approach to Maintaining Optimized Relational Representations of Entity-Relationship Schemas

This paper presents a redesign method for maintaining optimized relational representations of entity-relationship schemas. This method is based on the generation of a transient virtual database state that is used to construct the new database state and that can be obtained without modifying the current relational representation. It also provides means to collect additional data and to integrate them to the the current database state, as well as to check for new integrity constraints.

[1]  Ramez Elmasri,et al.  Entity-Relationship Approach — ER '93 , 1993, Lecture Notes in Computer Science.

[2]  Johann A. Makowsky,et al.  Incremental Reorganization of Relational Databases , 1987, VLDB.

[3]  Marco A. Casanova,et al.  Algorithms for Designing and Maintaining Optimized Relational Representations of Entity-Relationship Schemas , 1990, ER.

[4]  José Mauro Volkmer de Castilho.  A State-Space Approach for Database Redesign , 1998, RITA.

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

[6]  David K. Hsiao.  ACM transactions on database systems: aim and scope , 1976, TODS.

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

[8]  Panos K. Chrysanthis,et al.  Database schema evolution using EVER diagrams , 1994, AVI '94.

[9]  Ramez Elmasri,et al.  Fundamentals of database systems (2nd ed.) , 1994 .

[10]  Marco A. Casanova,et al.  On the Design and Maintenance of Optimized Relational Representations of Entity-Relationship Schemas , 1993, Data Knowl. Eng..

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

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

[13]  Jean-Luc Hainaut,et al.  Schema Transformation Techniques for Database Reverse Engineering , 1993, ER.

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

[15]  Jean-Luc Hainaut,et al.  Transformation-based Database Reverse Engineering , 1993 .