Language extensions for the automation of database schema evolution

Papastefanatos, G; Vassiliadis, P; Simitsis, A; Aggistalis, K; Pechlivani, F; Vassiliou, Y

dc.contributor.author	Papastefanatos, G	en
dc.contributor.author	Vassiliadis, P	en
dc.contributor.author	Simitsis, A	en
dc.contributor.author	Aggistalis, K	en
dc.contributor.author	Pechlivani, F	en
dc.contributor.author	Vassiliou, Y	en
dc.date.accessioned	2014-03-01T02:45:32Z
dc.date.available	2014-03-01T02:45:32Z
dc.date.issued	2008	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/32298
dc.relation.uri	http://www.scopus.com/inward/record.url?eid=2-s2.0-55849144413&partnerID=40&md5=4cb37a6671c4e54c98de2e8f25c43e0f	en
dc.relation.uri	http://www.informatik.uni-trier.de/~ley/db/conf/iceis/iceis2008-1.html#PapastefanatosVSAPV08	en
dc.relation.uri	http://www.dblab.ece.ntua.gr/~gpapas/Publications/Papastefanatos_ICEIS08.pdf	en
dc.relation.uri	http://www.cs.uoi.gr/~pvassil/publications/2008_ICEIS/ICEIS_2008.pdf	en
dc.relation.uri	http://www.dbnet.ece.ntua.gr/pubs/uploads/TR-2008-5.pdf	en
dc.relation.uri	http://www.dblab.ntua.gr/~gpapas/Publications/Papastefanatos_ICEIS08.pdf	en
dc.subject	Database schema evolution	en
dc.subject	SQL extension	en
dc.subject.other	Database schemas	en
dc.subject.other	Database software	en
dc.subject.other	Graph-based	en
dc.subject.other	Language extensions	en
dc.subject.other	Potential change	en
dc.subject.other	Public sector	en
dc.subject.other	Real world situations	en
dc.subject.other	Software constructs	en
dc.subject.other	SQL languages	en
dc.subject.other	Whole process	en
dc.subject.other	Computer software	en
dc.subject.other	Database systems	en
dc.subject.other	Linguistics	en
dc.subject.other	Information systems	en
dc.title	Language extensions for the automation of database schema evolution	en
heal.type	conferenceItem	en
heal.publicationDate	2008	en
heal.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.	en
heal.journalName	ICEIS 2008 - Proceedings of the 10th International Conference on Enterprise Information Systems	en
dc.identifier.volume	DISI	en
dc.identifier.spage	74	en
dc.identifier.epage	81	en