Policy-regulated management of ETL evolution

Papastefanatos, G; Vassiliadis, P; Simitsis, A; Vassiliou, Y

dc.contributor.author	Papastefanatos, G	en
dc.contributor.author	Vassiliadis, P	en
dc.contributor.author	Simitsis, A	en
dc.contributor.author	Vassiliou, Y	en
dc.date.accessioned	2014-03-01T02:46:23Z
dc.date.available	2014-03-01T02:46:23Z
dc.date.issued	2009	en
dc.identifier.issn	03029743	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/32656
dc.subject	Data warehouses	en
dc.subject	ETL	en
dc.subject	Evolution	en
dc.subject	Impact of changes	en
dc.subject.other	Extract transform loads	en
dc.subject.other	Public sector	en
dc.subject.other	Real-world	en
dc.subject.other	Work-flows	en
dc.subject.other	Semantics	en
dc.subject.other	Data warehouses	en
dc.title	Policy-regulated management of ETL evolution	en
heal.type	conferenceItem	en
heal.identifier.primary	10.1007/978-3-642-03098-7_6	en
heal.identifier.secondary	http://dx.doi.org/10.1007/978-3-642-03098-7_6	en
heal.publicationDate	2009	en
heal.abstract	In this paper, we discuss the problem of performing impact prediction for changes that occur in the schema/structure of the data warehouse sources. We abstract Extract-Transform-Load (ETL) activities as queries and sequences of views. ETL activities and its sources are uniformly modeled as a graph that is annotated with policies for the management of evolution events. Given a change at an element of the graph, our method detects the parts of the graph that are affected by this change and highlights the way they are tuned to respond to it. For many cases of ETL source evolution, we present rules so that both syntactical and semantic correctness of activities are retained. Finally, we experiment with the evaluation of our approach over real-world ETL workflows used in the Greek public sector. © 2009 Springer-Verlag.	en
heal.journalName	Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)	en
dc.identifier.doi	10.1007/978-3-642-03098-7_6	en
dc.identifier.volume	5530 LNCS	en
dc.identifier.spage	147	en
dc.identifier.epage	177	en