MetaCartSign in to MyCiteSeer

Include Citations | Advanced Search | Help

Include Citations | Advanced Search | Help

  Database schema evolution through the specification and maintenance of changes on entities and relationships (1994) [7 citations — 1 self]

Download:
Download as a PDF | Download as a PS
by Chien-tsai Liu, Panos K. Chrysanthis, Shi-kuo Chang
Entity-Relationship Approach - ER’94, Business Modelling and Re-Engineering, 13th International Conference on the Entity-Relationship Approach
ftp://ftp.cs.pitt.edu/panos/assorted/er_94.ps
Add To MetaCart

Abstract:

Abstract. A flexible database system needs to support changes to its schema in order to facilitate the requirements of new applications and to support interoperability within a multidatabase system. In this paper, we present an approach to schema evolution through changes to the EntityRelationship (ER) schema of a database. We enhance the graphical constructs used in ER diagrams, and develop EVER, an EVolutionary ER diagram for specifying the derivation relationships between schema versions, relationships among attributes, and the conditions for maintaining consistent views of programs. Algorithms are presented for mapping the EVER diagram into the underlying database and constructing database views for schema versions. Through the reconstruction of views after database reorganization, changes to an ER diagram can be made transparent to the application programs while all objects in the database remain accessible to the application programs. 1

Citations

845 Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases – Larson - 1990
365 The implementation of POSTGRES – Stonebraker, Rowe, et al. - 1990
189 Interoperability of Multiple Autonomous Databases – Litwin, Mark, et al. - 1990
129 The entity relationship model—Toward a unified view of data – Chen - 1976
127 A view mechanism for object-oriented databases – Bertino - 1992
127 A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model – Teorey, Yang, et al. - 1986
84 A Framework for Schema Updates in an Object-Oriented Database System – Zicari - 1992
37 Heterogeneous distributed database systems for production use – Thomas, Thompson, et al. - 1993
34 On-The-Fly Program Modification: Systems for Dynamic Updating – Segal - 1993
25 Object-Oriented Type Evolution – Zdonik - 1990
22 Unified Class Evolution by Object-Oriented Views – Bratsberg - 1992
19 Quantifying Schema Evolution – Sj��berg - 1993
17 et al. The GemStone data management system – Bretl - 1989
15 Schema Evolution and Integration – Clamen - 1994
14 Design and implementation of an extendible integrity subsystem – Simon, P - 1984
13 Knowledge-based Integrity Constraint Validation – Qian, Wiederhold - 1986
8 Database schema evolution using EVER diagrams – Liu, Chang, et al. - 1994
8 OOER: Toward Making the E-R Approach Object-Oriented – Navathe, Pillalamarri - 1988
5 et al. Semantics and implementation of schema evolution in object-oriented databases – Banerjee - 1987
4 ER vs. OO – Chen - 1992
3 Type evolution in an Object-Oriented Databases, Research directions in object-oriented programming, Eds. Peter Wegner and Bruce – Skarra, Zdonik - 1987
2 Fundamentals of Database Systems, 2nd edition. The Benjamin/Cummings – Elmasri, Navathe - 1992
2 Schema Evolution through Changes to ER Diagrams – Liu, Chrysanthis, et al. - 1994
1 et al. Making Type Changes Transparent – Ahlsen - 1983