Creation and management of versions in multiversion data warehouse

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.

[1]  Carsten Sapia,et al.  On Schema Evolution in Multidimensional Databases , 1999, DaWaK.

[2]  Narain H. Gehani,et al.  Object versioning in Ode , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[3]  Johann Eder,et al.  Changes of Dimension Data in Temporal Data Warehouses , 2001, DaWaK.

[4]  Chin-Wan Chung,et al.  Exploiting Versions for On-line Data Warehouse Maintenance in MOLAP Servers , 2002, VLDB.

[5]  John F. Roddick,et al.  A survey of schema versioning issues for database systems , 1995, Inf. Softw. Technol..

[6]  Jennifer Widom,et al.  On-line warehouse view maintenance , 1997, SIGMOD '97.

[7]  Peter Chamoni,et al.  Temporal Structures in Data Warehousing , 1999, DaWaK.

[8]  Robert Wrembel,et al.  Modeling a Multiversion Data Warehouse: A Formal Approach , 2003, ICEIS.

[9]  Johann Eder,et al.  The COMET Metamodel for Temporal Data Warehouses , 2002, CAiSE.

[10]  Yannis Papakonstantinou,et al.  Hypothetical Queries in an OLAP Environment , 2000, VLDB.

[11]  Wojciech Cellary,et al.  Consistency of versions in objects-oriented databases , 1990, VLDB 1990.

[12]  Elke A. Rundensteiner,et al.  Integrating the rewriting and ranking phases of view synchronization , 1998, DOLAP '98.

[13]  Won Kim,et al.  Versions of Schema for Object-Oriented Databases , 1988, VLDB.

[14]  M. Jarke,et al.  Fundamentals of Data Warehouses , 2003, Springer Berlin Heidelberg.

[15]  Alberto O. Mendelzon,et al.  Maintaining data cubes under dimension updates , 1999, Proceedings 15th International Conference on Data Engineering (Cat. No.99CB36337).

[16]  Yvan Bédard,et al.  A multidimensional and multiversion structure for OLAP applications , 2002, DOLAP '02.

[17]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[18]  D. Sjøberg,et al.  Quantifying schema evolution , 1993, Inf. Softw. Technol..

[19]  Jacky Estublier,et al.  Schema Evolution in Software Engineering Databases - a New Approach in Adele Environment , 2000, Comput. Artif. Intell..

[20]  Mukesh K. Mohania,et al.  Concurrent maintenance of views using multiple versions , 1999, Proceedings. IDEAS'99. International Database Engineering and Applications Symposium (Cat. No.PR00265).

[21]  Alberto O. Mendelzon,et al.  Temporal Queries in OLAP , 2000, VLDB.

[22]  Wojciech Cellary,et al.  Consistency of Versions in Object-Oriented Databases , 1990, Building an Object-Oriented Database System, The Story of O2.

[23]  Elke A. Rundensteiner,et al.  Maintaining data warehouses over changing information sources , 2000, CACM.

[24]  Alberto O. Mendelzon,et al.  Updating OLAP dimensions , 1999, DOLAP '99.

[25]  Zohra Bellahsene.  View Adaptation in Data Warehousing Systems , 1998, DEXA.

[26]  Mária Bieliková,et al.  Modelling Versioned Hypertext Documents , 1998, SCM.