loading
Papers Papers/2022 Papers Papers/2022

Research.Publish.Connect.

Paper

Paper Unlock

Authors: George Papastefanatos 1 ; Panos Vassiliadis 2 ; Alkis Simitsis 3 ; Konstantinos Aggistalis 2 ; Fotini Pechlivani 2 and Yannis Vassiliou 1

Affiliations: 1 National Technical University of Athens, Greece ; 2 University of Ioannina, Greece ; 3 IBM Almaden Research Center, United States

Keyword(s): Database schema evolution, SQL extension.

Related Ontology Subjects/Areas/Topics: Coupling and Integrating Heterogeneous Data Sources ; Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems

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 s pecifically 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. (More)

CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 54.165.248.212

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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 4: ICEIS; ISBN 978-989-8111-36-4; ISSN 2184-4992, SciTePress, pages 74-81. DOI: 10.5220/0001716400740081

@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 4: ICEIS},
year={2008},
pages={74-81},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001716400740081},
isbn={978-989-8111-36-4},
issn={2184-4992},
}

TY - CONF

JO - Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 4: ICEIS
TI - LANGUAGE EXTENSIONS FOR THE AUTOMATION OF DATABASE SCHEMA EVOLUTION
SN - 978-989-8111-36-4
IS - 2184-4992
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
PB - SciTePress