What-if analysis for data warehouse evolution

  • Authors:
  • George Papastefanatos;Panos Vassiliadis;Alkis Simitsis;Yannis Vassiliou

  • Affiliations:
  • National Technical University of Athens, Dept. of Electr. and Comp. Eng., Athens, Hellas;University of Ioannina, Dept. of Computer Science, Ioannina, Hellas;IBM Almaden Research Center, San Jose, California;National Technical University of Athens, Dept. of Electr. and Comp. Eng., Athens, Hellas

  • Venue:
  • DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

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.