Database schema evolution using EVER diagrams

Chien Tsai Liu; Shi Kuo Chang; Panos K. Chrysanthis

doi:10.1145/192309.192338

Database schema evolution using EVER diagrams

Chien Tsai Liu, Shi Kuo Chang, Panos K. Chrysanthis

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

8 Citations (Scopus)

Abstract

We present an approach to schema evolution through changes to the ER diagram representing the schema of a database. In order to facilitate changes to the ER schema 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. In this paper, we demonstrate the mapping of the EVER diagram into an underlying database and the construction of 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. The EVER system can serve as a front-end for object-oriented databases.

Original language	English
Title of host publication	Proceedings of the Workshop on Advanced Visual Interfaces AVI
Pages	123-132
Number of pages	10
DOIs	https://doi.org/10.1145/192309.192338
Publication status	Published - 1994
Externally published	Yes
Event	Workshop on Advanced Visual Interfaces, AVI 1994 - Bari, Italy Duration: Jun 1 1994 → Jun 4 1994

Other

Other	Workshop on Advanced Visual Interfaces, AVI 1994
Country/Territory	Italy
City	Bari
Period	6/1/94 → 6/4/94

ASJC Scopus subject areas

Software
Human-Computer Interaction

Access to Document

10.1145/192309.192338

Cite this

@inproceedings{422e7758b2564a71ba84a883e899d690,

title = "Database schema evolution using EVER diagrams",

abstract = "We present an approach to schema evolution through changes to the ER diagram representing the schema of a database. In order to facilitate changes to the ER schema 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. In this paper, we demonstrate the mapping of the EVER diagram into an underlying database and the construction of 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. The EVER system can serve as a front-end for object-oriented databases.",

author = "Liu, {Chien Tsai} and Chang, {Shi Kuo} and Chrysanthis, {Panos K.}",

year = "1994",

doi = "10.1145/192309.192338",

language = "English",

isbn = "0897917332",

pages = "123--132",

booktitle = "Proceedings of the Workshop on Advanced Visual Interfaces AVI",

note = "Workshop on Advanced Visual Interfaces, AVI 1994 ; Conference date: 01-06-1994 Through 04-06-1994",

}

TY - GEN

T1 - Database schema evolution using EVER diagrams

AU - Liu, Chien Tsai

AU - Chang, Shi Kuo

AU - Chrysanthis, Panos K.

PY - 1994

Y1 - 1994

N2 - We present an approach to schema evolution through changes to the ER diagram representing the schema of a database. In order to facilitate changes to the ER schema 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. In this paper, we demonstrate the mapping of the EVER diagram into an underlying database and the construction of 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. The EVER system can serve as a front-end for object-oriented databases.

AB - We present an approach to schema evolution through changes to the ER diagram representing the schema of a database. In order to facilitate changes to the ER schema 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. In this paper, we demonstrate the mapping of the EVER diagram into an underlying database and the construction of 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. The EVER system can serve as a front-end for object-oriented databases.

UR - http://www.scopus.com/inward/record.url?scp=33646201881&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=33646201881&partnerID=8YFLogxK

U2 - 10.1145/192309.192338

DO - 10.1145/192309.192338

M3 - Conference contribution

AN - SCOPUS:33646201881

SN - 0897917332

SN - 9780897917339

SP - 123

EP - 132

BT - Proceedings of the Workshop on Advanced Visual Interfaces AVI

T2 - Workshop on Advanced Visual Interfaces, AVI 1994

Y2 - 1 June 1994 through 4 June 1994

ER -

Database schema evolution using EVER diagrams

Abstract

Other

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this