What-If Analysis for Data Warehouse Evolution

Authors: 
Papastefanatos, G.; Vassiliadis, P.; Simitsis, A.; Vassiliou, Y.
Author: 
Papastefanatos, G
Vassiliadis, P
Simitsis, A
Vassiliou, Y
Year: 
2007
Venue: 
DaWaK 2007
DOI: 
http://dx.doi.org/10.1007/978-3-540-74553-2_3
Citations: 
18
Citations range: 
10 - 49

In this paper, we deal with the problem of performing what-if analysis for changes that occur in the schema/structure of the data warehouse sources. We abstract software modules, queries, reports and views as (sequences of) queries in SQL enriched with functions. Queries and relations 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 indicates the way they are tuned to respond to it.