LANGUAGE EXTENSIONS FOR THE AUTOMATION OF DATABASE SCHEMA EVOLUTION

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

2008

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.

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