AN APPROACH FOR SCHEMA EVOLUTION IN ODMG DATABASES

Cecilia Delgado, José Samos, Manuel Torres

Abstract

Schema evolution is the process of applying changes to a schema in a consistent way and propagating these changes to the instances while the database is in operation. However, when a database is shared by many users, updates to the database schema are always difficult. To overcome this problem, in this paper we propose a version mechanism for schema evolution in ODMG databases that preserves old schemas for continued support of existing programs running on the shared database when schema changes are produced. Our approach uses external schema definition techniques and is based on the fact that if a schema change is requested on an external schema, rather than modifying the schema, a new schema, which reflects the semantics of the schema change, is defined.

References

  1. ANSI/X3/SPARC, 1986. Database System Study Group, “Reference Model for DBMS Standardisation”. SIGMOD RECORD, 5, pp.19-58.
  2. Bertino E., 1992. A View Mechanism for Object-Oriented Databases. In EDBT'92, LNCS 580, pp136-151.
  3. Cattell R.G.G, 2000. The Object Data Standard: ODMG 3.0. Morgan Kaufmann.
  4. Delgado C. et al., 2003. Primitive Operations for Schema Evolution in ODMG Database. OOIS'03, LNCS 2817, pp. 326-337.
  5. Kim W. and Chou H., 1988. Versions of Schema for OODBs. In VLDB'88, pp. 148-159.
  6. Lautemann S.-E, 1997. A Propagation Mechanism for Populated Schema Versions. In IEEE Int. Conf. on Data Engineering, pp. 67-78.
  7. Miller, R. et al., 1993. The Use of Information Capacity in Schema Integration and Translation. In VLDB'93, pp. 120-133.
  8. Monk S. and Sommerville I., 1993. Schema Evolution in OODBs Using Class Versioning. In SIGMOD RECORD (22), pp. 16-22.
  9. Ra Y.G. and Rundensteiner E.A., 1997. A Transparent Schema Evolution System Based on Object-Oriented View Technology. In IEEE TKDE, pp. 600-624.
  10. Rundensteiner E. et al., 1998. Capacity-Augmenting Schema Changes on Object-Oriented Databases. In OOIS'98, pp. 349-366.
  11. Samos J. and Saltor F., 1997. External Schemas in a Schema-Evolution Enviroment for OODBs. In DEXA'97, pp. 516-522.
  12. Torres M., 2002. Definición de Esquemas Externos en Bases de Datos ODMG. PhD Thesis, Univ. of Almería, Spain.
  13. Tresch M. and Scholl M.H., 1993. Schema Transformation without Database Reorganization. In SIGMOD RECORD, pp. 21-27.
Download


Paper Citation


in Harvard Style

Delgado C., Samos J. and Torres M. (2004). AN APPROACH FOR SCHEMA EVOLUTION IN ODMG DATABASES . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 136-141. DOI: 10.5220/0002617901360141


in Bibtex Style

@conference{iceis04,
author={Cecilia Delgado and José Samos and Manuel Torres},
title={AN APPROACH FOR SCHEMA EVOLUTION IN ODMG DATABASES},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={136-141},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002617901360141},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - AN APPROACH FOR SCHEMA EVOLUTION IN ODMG DATABASES
SN - 972-8865-00-7
AU - Delgado C.
AU - Samos J.
AU - Torres M.
PY - 2004
SP - 136
EP - 141
DO - 10.5220/0002617901360141