Creation and management of versions in multiversion data warehouse

Authors: 
Bebel, B.; Eder, J.; Koncilia, C.; Morzy, T.; Wrembel, R.
Author: 
Bebel, B
Eder, J
Koncilia, C
Morzy, T
Wrembel, R
Year: 
2004
Venue: 
Proc. of the ACM Symp. on Applied computing
URL: 
http://portal.acm.org/citation.cfm?id=968049&coll=GUIDE&dl=ACM&CFID=5285993&CFTOKEN=26327261
DOI: 
http://doi.acm.org/10.1145/967900.968049
Citations: 
93
Citations range: 
50 - 99
AttachmentSize
Bebel2004Creationandmanagementof.pdf504.87 KB

A data warehouse (DW) provides an information for analytical processing, decision making, and data mining tools. On the one hand, the structure and content of a data warehouse reflects a real world, i.e. data stored in a DW come from real production systems. On the other hand, a DW and its tools may be used for predicting trends and simulating a virtual business scenarios. This activity is often called the what-if analysis. Traditional DW systems have static structure of their schemas and relationships between data, and therefore they are not able to support any dynamics in their structure and content. For these purposes, multiversion data warehouses seem to be very promising. In this paper we present a concept and an ongoing implementation of a multiversion data warehouse that is capable of handling changes in the structure of its schema as well as simulating alternative business scenarios.