An Architecture for Managing Database Evolution

This paper presents an architecture for managing database evolution when all the components of the database (conceptual schema, logical schema and extension) are available. The strategy of evolution in which our architecture is based is that of ‘forward database maintenance’, that is, changes are applied to the conceptual schema and propagated automatically down to the logical schema and to the extension. In order to put into practice this strategy, each component of a database is seen under this architecture as the information base of an information system. Furthermore, a translation information system is considered in order to manage the translation of conceptual elements into logical schema elements. A current Oracle implementation of this architecture is also presented.

[1]  G. G. Stokes.  "J." , 1890, The New Yale Book of Quotations.

[2]  Antoni Olivé,et al.  A Framework for the Evolution of Temporal Conceptual Schemas of Information Systems , 2000, CAiSE.

[3]  Christophe Nicolle,et al.  Multi-Data Models Translations in Interoperable Information Systems , 1996, CAiSE.

[4]  Henderik Alex Proper,et al.  Database Schema Transformation and Optimization , 1995, OOER.

[5]  Vincent Englebert,et al.  Database Evolution: the DB-Main Approach , 1994, ER.

[6]  John F. Roddick,et al.  A Taxonomy for Schema Versioning Based on the Relational and Entity Relationship Models , 1993, ER.

[7]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[8]  Vincent Englebert,et al.  Stratégies pour l'évolution des applications de bases de données relationnelles : l'approche DB-main , 1999, INFORSID.

[9]  D. A Jardine,et al.  Concepts and terminology for the conceptual schema and the information base , 1984 .

[10]  Marco A. Casanova,et al.  An analysis of SQL integrity constraints from an entity-relationship model perspective , 1994, Inf. Syst..

[11]  Marco A. Casanova,et al.  An Approach to Maintaining Optimized Relational Representations of Entity-Relationship Schemas , 1996, ER.

[12]  Michel Léonard,et al.  Multiobjects to Ease Schema Evolution in an OODBMS , 1998, ER.

[13]  Elke A. Rundensteiner,et al.  ROVER: A Framework for the Evolution of Relationships , 2000, ER.

[14]  Julio Rubio,et al.  A Conceptual Approach to Meta-Modelling , 1997, CAiSE.

[15]  Henderik Alex Proper,et al.  Information Disclosure in Evolving Information Systems: Taking as Shot at a Moving Target , 1995, Data Knowl. Eng..