Publicado

2005-01-01

Inconsistency management in schema evolution and data base migration

Palabras clave:

Software Maintenance, Schema Evolution, Object Oriented Development, Inconsistencies management (en)

Descargas

Autores/as

  • Fernando Arango Izasa Universidad Nacional de Colombia-Sede Medellín-Facultad de Minas-Systems and Informatics School

Automation of conceptual schema evolution process should allow database management systems to smoothly perform schema transformation and data migration. However, current approaches lack the ability to perform well in all circumstances. They can’t manage, for example, schema restrictions strengthening without lost of information or the aid of an external migration tool, which, besides of being costly, have to assume database correctness responsibility. In this paper we present a novelty approach to schema evolution automation that performs well in all circumstances. It allows the schema transformation and data migration to be performed in the realm of day by day system use without lost of information or the use of an external migration tool. The approach key idea is to make database management system, not only capable of performing schema changes and data migration, but capable of managing schema evolution/data migration inconsistencies. Instead of pretending an abrupt elimination of evolution related inconsistencies, our approach opts for predict, permit, detect and gradually eliminate them. The approach elements are stated in the framework of the formal approach to the object oriented software development, OASIS. OASIS allows us to rigorously specify and to automatically obtain a software ambient prototype oriented to the creation, animation, evolution, versioning and versions interoperation, of OASIS conceptual schemas, that has, in addition, inconsistencies management capabilities.

Referencias

Arango, F. (2000), Analysis and management of inconsistencies in the interoperability of oo conceptual schemas versions, in ‘Workshop, IDEAS 2000, Cancún - Mexico’.

Arango, F. (2002), Gestión de las Inconsistencias en la Evolución e Interoperación de los Esquema Conceptuales OO, en el marco formal de OASIS, PhD thesis, Department of Informatic Systems and Computation, Polytechnic University of Valencia, Valencia - Spain.

Banerjee, J., Kim, W., Kim, H. y Korth, H. F. (1987), ‘Semantics and implementation of schema evolution in object-oriented databases’, SIGMOD pp. 311-322.

Barbedette, G. (1991). Schema modifications in the lispo2 persistent object-oriented language, in ‘European Conf. of Object-Oriented Programming, Geneva - Switzerland’.

Booch, G. (1994), Object Oriented Analysis and Design With Applications, 2th edition edn, Bejamin/Cummings, Menlo Park (Calif.).

Brèche, P., Ferrandina, F. y Kuklok, M. (1995), Simulation of schema change using views, in ‘Proceedings of the 6th Int’l Conf. On Data Base and Expert Systems Applications, London’.

Carsí, J. (1999), OASIS como marco conceptual para la evolución del software, PhD thesis, Universidad Politécnica de Valencia - Spain.

Clamen, S. (1992), Type evolution and instance adaptation, Technical report, School of Computer Science, Carnegie Mellon University, Pittsburgh, PA. Tech. Report, CMU- CS-92-133R.

Clavel, M.. Durán, F., Eker, S., Lincoln, P., Marti-Oliet, N., Mesenger, J. y Quesada, J. (2000), A maude tutorial, in ‘CICA, Sevilla - Spain’.

Dynamic Logic (1984), Reidel, chapter Handbook of Philosophical Logic II, D.M.Gabbay & F.Guenthner, pp. 497- 694.

Kajal, T., Claypool, J. y Rundensteiner, E. (1998), Serf: Schema evolution through an extensible, reusable and flexible framework. Technical report, Computer Science Department, Worcester Polytechnic institute. Computer Science Technical Report Series, WPI-CS-TR-88-9.

Lautemann, S.-E. (1997a), A propagation mechanism for populated schema versions, in ‘Proc. of the 13th Int’l Conf. On Data Engineering (ICDE), Birmingha- U.K.’.

Lautemann, S.-E. (1997b), Schema versions in object- oriented database systems, in ‘Proc. of the 5th Int’l Conf. On Database Systems for Advanced Applications (DASFAA), Melbourne - Australia’.

Lerner, B. (1996), A model of compound type changes encountered in schema evolution, Technical report, Computer Science Department, University of Massachusetts at Amherst. 96-044.

Lerner, B. y Habermann, A. (1990), Beyond schema evolution to database reorganization, in 'Proceedings of the ACM Conference on Object-Oriented Programming: Systems, Languages and Applications (OOPSLA), ACM SIGPLAN Notices’, Vol. 25, Otawa - Canada.

Meyer, B. (1988), Object Oriented Software Construction, Prentice Hall, Hemel Hempstead.

Odberg, E. (1995), Multi Perspectives: Object. Evolution and Schema Modification Management for Object-Oriented Databases, PhD thesis, Norwegian Institute of Technology.

Penney J. y Stein J. (1987), Class modification in the gemstone object oriented dbms, in e. Norman Meyorwitz, ed., ‘Proc. of the 2nd Conf. On Object Oriented Programming Systems, Languages and Applications (OOPSLA)', Orlando, Florida, pp. 111-117. ACM, ACM Press, Special Issue of SIGPLAN Notices. V. 22, No. 12, Dec. 1987.

Ramos, I., Pelechano, V., Penadés. M., Bonet, B., Canos, J. y Pastor, O. (1993), Análisis y diseño orientado a objetos de un entorno de prototipación automática basado en oasis, Technical report, Departamento de Sistemas Informáticos y Computación, Universidad Politécnica de Valencia.

Rundenstciner, E. (1994), A clasification algorithm for supporting object-oriented views, in ‘Proc. Int'l Conf. Information and Knowledge Management’, pp. 18-25.

Scherrer, S., Geppert, A. y Dittrich, K. (1993), Schema evolution in No. 2, Technical report, Institut für Informatik Universität Zürich. Technical Report Nr. 93.12.

Scholl, M., Laasch, C. y Tresch, M. (1991), Updatable views in object-oriented databases, in ‘Proc. Second DOOD Conf.’, pp. 189-207.

Scholl, M., Laasch, C. y Tresch, M. (1994), Evolution towards, in, and beyond object databases, in ‘Proc. 3rd G1 Workshop Information Systems and Artificial Intelligence, Hamburg’.

Torres, P., Ramos, I., Sánchez, P. y Pastor, O. (1998), Oasis version 3.0: Un enfoque formal para el modelado conceptual orientado a objeto, Technical report. Departamento de Sistemas Informáticos y Computación, Facultad de Informática, Universidad Politécnica de Valencia. Servicio de Publicaciones, SPUPV-98.4011.

Toval, J. (1994), Formalización Algebraica de un Entorno de Producción Automática de Prototipos Orientados por Objetos, PhD thesis, Universidad Politécnica de Valencia.

Tresch, M. y Scholl, M. (1992), Meta object management and its application to database evolution, in ‘11th Int’l Conf. On the Entity Relationship Approach, Karlsruhe - Germany’.

Waller, E. (1991), Schema updates and consistency, in 'Second Intn’l Conference DOOD'91’, pp. 167-188.

Young-Gook, R. y Rundensteiner, E. (1997), ‘A transparent schema-evolution system based on object-oriented view technology’, IEEE Transaction on Knowledge and Data Engineering 9(4).

Yourdon, E. (1989), ‘Re-3: re-engineering, reestructuring and reverse engineering’, American Programmer 2(4). 3-10.

Cómo citar

APA

Arango Izasa, F. . (2005). Inconsistency management in schema evolution and data base migration. Avances en Sistemas e Informática, 2(1), 9–18. https://revistas.unal.edu.co/index.php/avances/article/view/93550

ACM

[1]
Arango Izasa, F. 2005. Inconsistency management in schema evolution and data base migration. Avances en Sistemas e Informática. 2, 1 (ene. 2005), 9–18.

ACS

(1)
Arango Izasa, F. . Inconsistency management in schema evolution and data base migration. ava. sis. inf 2005, 2, 9-18.

ABNT

ARANGO IZASA, F. . Inconsistency management in schema evolution and data base migration. Avances en Sistemas e Informática, [S. l.], v. 2, n. 1, p. 9–18, 2005. Disponível em: https://revistas.unal.edu.co/index.php/avances/article/view/93550. Acesso em: 25 abr. 2025.

Chicago

Arango Izasa, Fernando. 2005. «Inconsistency management in schema evolution and data base migration». Avances En Sistemas E Informática 2 (1):9-18. https://revistas.unal.edu.co/index.php/avances/article/view/93550.

Harvard

Arango Izasa, F. . (2005) «Inconsistency management in schema evolution and data base migration», Avances en Sistemas e Informática, 2(1), pp. 9–18. Disponible en: https://revistas.unal.edu.co/index.php/avances/article/view/93550 (Accedido: 25 abril 2025).

IEEE

[1]
F. . Arango Izasa, «Inconsistency management in schema evolution and data base migration», ava. sis. inf, vol. 2, n.º 1, pp. 9–18, ene. 2005.

MLA

Arango Izasa, F. . «Inconsistency management in schema evolution and data base migration». Avances en Sistemas e Informática, vol. 2, n.º 1, enero de 2005, pp. 9-18, https://revistas.unal.edu.co/index.php/avances/article/view/93550.

Turabian

Arango Izasa, Fernando. «Inconsistency management in schema evolution and data base migration». Avances en Sistemas e Informática 2, no. 1 (enero 1, 2005): 9–18. Accedido abril 25, 2025. https://revistas.unal.edu.co/index.php/avances/article/view/93550.

Vancouver

1.
Arango Izasa F. Inconsistency management in schema evolution and data base migration. ava. sis. inf [Internet]. 1 de enero de 2005 [citado 25 de abril de 2025];2(1):9-18. Disponible en: https://revistas.unal.edu.co/index.php/avances/article/view/93550

Descargar cita

Visitas a la página del resumen del artículo

59

Descargas

Los datos de descargas todavía no están disponibles.