Database schema evolution using EVER diagrams

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

Research output: Chapter in Book/Report/Conference proceedingConference 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 languageEnglish
Title of host publicationProceedings of the Workshop on Advanced Visual Interfaces AVI
Pages123-132
Number of pages10
DOIs
Publication statusPublished - 1994
Externally publishedYes
EventWorkshop on Advanced Visual Interfaces, AVI 1994 - Bari, Italy
Duration: Jun 1 1994Jun 4 1994

Other

OtherWorkshop on Advanced Visual Interfaces, AVI 1994
CountryItaly
CityBari
Period6/1/946/4/94

Fingerprint

Application programs
Object-oriented databases

ASJC Scopus subject areas

  • Software
  • Human-Computer Interaction

Cite this

Liu, C. T., Chang, S. K., & Chrysanthis, P. K. (1994). Database schema evolution using EVER diagrams. In Proceedings of the Workshop on Advanced Visual Interfaces AVI (pp. 123-132) https://doi.org/10.1145/192309.192338

Database schema evolution using EVER diagrams. / Liu, Chien Tsai; Chang, Shi Kuo; Chrysanthis, Panos K.

Proceedings of the Workshop on Advanced Visual Interfaces AVI. 1994. p. 123-132.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Liu, CT, Chang, SK & Chrysanthis, PK 1994, Database schema evolution using EVER diagrams. in Proceedings of the Workshop on Advanced Visual Interfaces AVI. pp. 123-132, Workshop on Advanced Visual Interfaces, AVI 1994, Bari, Italy, 6/1/94. https://doi.org/10.1145/192309.192338
Liu CT, Chang SK, Chrysanthis PK. Database schema evolution using EVER diagrams. In Proceedings of the Workshop on Advanced Visual Interfaces AVI. 1994. p. 123-132 https://doi.org/10.1145/192309.192338
Liu, Chien Tsai ; Chang, Shi Kuo ; Chrysanthis, Panos K. / Database schema evolution using EVER diagrams. Proceedings of the Workshop on Advanced Visual Interfaces AVI. 1994. pp. 123-132
@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",

}

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

SN - 0897917332

SN - 9780897917339

SP - 123

EP - 132

BT - Proceedings of the Workshop on Advanced Visual Interfaces AVI

ER -