Abstract
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.
This work has been partially supported by DGES, projects TIC2000-1368-C03-01 and PB-96-0098-C04-01, and by University of Zaragoza, project UZ-00-TEC-04.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Al-Jadir, L., Léonard, M.: Multiobjects to Ease Schema Evolution in an OODBMS. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 316–333. Springer, Heidelberg (1998)
Claypool, K.T., Rundensteiner, E.A., Heineman, G.T.: ROVER: A Framework for the Evolution of Relationships. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds.) ER 2000. LNCS, vol. 1920, pp. 409–422. Springer, Heidelberg (2000)
Domínguez, E., Zapata, M.A., Rubio, J.J.: Conceptual Approach to Metamodelling. In: Olivé, À., Pastor, J.A. (eds.) CAiSE 1997. LNCS, vol. 1250, pp. 319–332. Springer, Heidelberg (1997)
Elmasri, R.A., Navathe, S.B.: Fundamentals of Database Systems, 3rd edn. Addison- Wesley, London (2000)
van Griethuysen, J.J. (ed.): Concepts and Terminology for the Conceptual Schema and the Information Base, Mars 1982. Publ. ISO/TC97/SV5-N695 (1982)
Hainaut, J.L., Englebert, V., Henrard, J., Hick, J.M., Roland, D.: Database Evolution: The DB-MAIN approach. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol. 881, pp. 112–131. Springer, Heidelberg (1994)
Halpin, T.A., Proper, H.A.: Database Schema Transformation and Optimization. In: Papazoglou, M.P. (ed.) ER 1995 and OOER 1995. LNCS, vol. 1021, pp. 191–203. Springer, Heidelberg (1995)
Hick, J.M., Hainaut, J.L., Englebert, V., Roland, D., et al.: Strategies pour l’evolution des applications de bases de donnes relationelles: L’approche DB-MAIN. In: Proceedings XVIII Congres Inforsid, La Garde, France (1999)
Laender, A.H.F., Casanova, M.A., de Carvalho, A.P., Ridolfi, L.F.G.G.M.: An Analysis of SQL Integrity Constraints from an Entity-Relationship Perspective. Information Systems 10(4), 331–358 (1994)
López, J.R., Olivé, A.: A Framework for the Evolution of Temporal Conceptual Schemas of Information Systems. In: Wangler, B., Bergman, L.D. (eds.) CAiSE 2000. LNCS, vol. 1789, pp. 369–386. Springer, Heidelberg (2000)
Nicolle, C., Benslimane, D., Yetongnon, K.: Multi–Data Models Translations in Interoperable Information Systems. In: Constantopoulos, P., Vassiliou, Y., Mylopoulos, J. (eds.) CAiSE 1996. LNCS, vol. 1080, pp. 1–21. Springer, Heidelberg (1996)
Oei, J.L.H., Proper, H.A., Falkenberg, E.D.: Evolving Information Systems: Meeting the ever–changing environment. Information Systems Journal 4(3), 213–233 (1994)
OMG, UML specification version 1.4, formal/01–09–67 (2001), http://www.omg.org
Proper, H.A., van der Weide, T.P.: Information Disclosure in Evolving Information Systems: Taking a Shot at a Moving Target. Data & Knowledge Engineering 15, 135–168 (1995)
Roddick, J.F., Craske, N.G., Richards, T.J.: A Taxonomy for Schema Versioning Based on the Relational and Entity Relationship Models. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds.) ER 1993. LNCS, vol. 823, pp. 137–148. Springer, Heidelberg (1994)
da Silva, A.S., Laender, A.H.F., Casanova, M.A.: An Approach to Maintaining Optimized Relational Representations of Entity-Relationship Schemas. In: Thalheim, B. (ed.) ER 1996. LNCS, vol. 1157, pp. 292–308. Springer, Heidelberg (1996)
Urman, S.: Oracle 9i PL/SQL Programming, Osborne (2002)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2003 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Domínguez, E., Lloret, J., Zapata, M.A. (2003). An Architecture for Managing Database Evolution. In: Olivé, A., Yoshikawa, M., Yu, E.S.K. (eds) Advanced Conceptual Modeling Techniques. ER 2002. Lecture Notes in Computer Science, vol 2784. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-45275-1_6
Download citation
DOI: https://doi.org/10.1007/978-3-540-45275-1_6
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-20255-4
Online ISBN: 978-3-540-45275-1
eBook Packages: Springer Book Archive