LANGUAGE EXTENSIONS FOR THE AUTOMATION OF DATABASE SCHEMA EVOLUTION

George Papastefanatos, Panos Vassiliadis, Alkis Simitsis, Konstantinos Aggistalis, Fotini Pechlivani, Yannis Vassiliou

Abstract

The administrators and designers of modern Information Systems face the problem of maintaining their systems in the presence of frequently occurring changes in any counterpart of it. In other words, when a change occurs in any point of the system –e.g., source, schema, view, software construct– they should propagate the change in all the involved parts of the system. Hence, it is imperative that the whole process should be done correctly, i.e., the change should be propagated to all the appropriate points of the system, with a limited overhead imposed on both the system and the humans, who design and maintain it. In this paper, we are dealing with the problem of evolution in the context of databases. First, we present a coherent, graph-based framework for capturing the effect of potential changes in the database software of an Information System. Next, we describe a generic annotation policy for database evolution and we propose a feasible and powerful extension to the SQL language specifically tailored for the management of evolution. Finally, we demonstrate the efficiency and feasibility of our approach through a case study based on a real-world situation occurred in the Greek public sector.

References

  1. Bellahsene, Z., 2002. Schema evolution in data warehouses. In Knowledge and Information Systems 4(2).
  2. Fan, H., Poulovassilis, A., 2004. Schema Evolution in Data Warehousing Environments - A Schema TransformationBased Approach. In ER'04.
  3. Gupta, A., et al., 2001. Adapting materialized views after redefinitions: Techniques and a performance study. In Information Systems (26).
  4. Lakshmanan, L.V.S., Sadri, F., Subramanian, I.N., 2001. SchemaSQL - An Extension to SQL for multi database interoperability. In TODS, 26(4): 476-519.
  5. Nica, A., Lee, A.J., Rundensteiner, E.A., 1998. The CSV algorithm for view synchronization in evolvable largescale information systems. In EDBT.
  6. Roddick, J.F., 1992. SQL/SE: A query language extension for databases supporting schema evolution. In ACM SIGMOD Record, 21(3): 10-16.
  7. Roddick, J.F., 1995. A survey of schema versioning issues for db systems. In Information Software Techn. 37(7).
  8. Roddick, J.F., et al, 2000. Evolution and change in data management. In SIGMOD Record 29(1).
  9. Sjoberg, D., 1993. Quantifying Schema Evolution. In Information and Software Technology, 35(1), 35-44.
  10. Velegrakis, Y., et al., 2004. Preserving mapping consistency under schema changes. In VLDB Journal, 13(3).
Download


Paper Citation


in Harvard Style

Papastefanatos G., Vassiliadis P., Simitsis A., Aggistalis K., Pechlivani F. and Vassiliou Y. (2008). LANGUAGE EXTENSIONS FOR THE AUTOMATION OF DATABASE SCHEMA EVOLUTION . In Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8111-36-4, pages 74-81. DOI: 10.5220/0001716400740081


in Bibtex Style

@conference{iceis08,
author={George Papastefanatos and Panos Vassiliadis and Alkis Simitsis and Konstantinos Aggistalis and Fotini Pechlivani and Yannis Vassiliou},
title={LANGUAGE EXTENSIONS FOR THE AUTOMATION OF DATABASE SCHEMA EVOLUTION},
booktitle={Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2008},
pages={74-81},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001716400740081},
isbn={978-989-8111-36-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - LANGUAGE EXTENSIONS FOR THE AUTOMATION OF DATABASE SCHEMA EVOLUTION
SN - 978-989-8111-36-4
AU - Papastefanatos G.
AU - Vassiliadis P.
AU - Simitsis A.
AU - Aggistalis K.
AU - Pechlivani F.
AU - Vassiliou Y.
PY - 2008
SP - 74
EP - 81
DO - 10.5220/0001716400740081