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

ASJC Scopus subject areas

  • Software
  • Human-Computer Interaction

Fingerprint Dive into the research topics of 'Database schema evolution using EVER diagrams'. Together they form a unique fingerprint.

  • 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