Download:
|
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
|