Creation and management of versions in multiversion data warehouse

Authors:
Bartosz Bȩbel;Johann Eder;Christian Koncilia;Tadeusz Morzy;Robert Wrembel
Affiliations:
Poznań University of Technology, Poznań, Poland;University of Klagenfurt, Klagenfurt, Austria;University of Klagenfurt, Klagenfurt, Austria;Poznań University of Technology, Poznań, Poland;Poznań University of Tecnology, Poznań, Poland
Venue:
Proceedings of the 2004 ACM symposium on Applied computing
Year:
2004

Citing 18
Cited 25

An overview of data warehousing and OLAP technology

ACM SIGMOD Record
On-line warehouse view maintenance

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Integrating the rewriting and ranking phases of view synchronization

Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Updating OLAP dimensions

Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Maintaining data warehouses over changing information sources

Communications of the ACM
Fundamentals of Data Warehouses

Fundamentals of Data Warehouses
A multidimensional and multiversion structure for OLAP applications

Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Object Versioning in Ode

Proceedings of the Seventh International Conference on Data Engineering
Versions of Schema for Object-Oriented Databases

VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Consistency of Versions in Object-Oriented Databases

VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
Temporal Queries in OLAP

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Hypothetical Queries in an OLAP Environment

VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
The COMET Metamodel for Temporal Data Warehouses

CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Modelling Versioned Hypertext Documents

ECOOP '98 Proceedings of the SCM-8 Symposium on System Configuration Management
View Adaptation in Data Warehousing Systems

DEXA '98 Proceedings of the 9th International Conference on Database and Expert Systems Applications
Maintaining Data Cubes under Dimension Updates

ICDE '99 Proceedings of the 15th International Conference on Data Engineering
Concurrent Maintenance of Views Using Multiple Versions

IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
Exploiting versions for on-line data warehouse maintenance in MOLAP servers

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases

On querying versions of multiversion data warehouse

Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Design and development of a multiversion OLAP application

Proceedings of the 2006 ACM symposium on Applied computing
Research in data warehouse modeling and design: dead or alive?

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Schema versioning in data warehouses: enabling cross-version querying via schema augmentation

Data & Knowledge Engineering - Special issue: WIDM 2004
XML structural delta mining: issues and challenges

Data & Knowledge Engineering - Special issue: ER 2003
An approach towards an event-fed solution for slowly changing dimensions in data warehouses with a detailed case study

Data & Knowledge Engineering
A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models

Data & Knowledge Engineering
A user-driven data warehouse evolution approach for concurrent personalized analysis needs

Integrated Computer-Aided Engineering
A web-based architecture for Temporal OLAP

International Journal of Web Engineering and Technology
Multiversion join index for multiversion data warehouse

Information and Software Technology
Efficient Incremental Computation of CUBE in Multiple Versions What-If Analysis

APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
Incremental Computation for MEDIAN Cubes in What-If Analysis

APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
The Tradeoff of Delta Table Merging and Re-writing Algorithms in What-If Analysis Application

APWeb/WAIM '09 Proceedings of the Joint International Conferences on Advances in Data and Web Management
A Knowledge-driven Data Warehouse Model for Analysis Evolution

Proceedings of the 2006 conference on Leading the Web in Concurrent Engineering: Next Generation Concurrent Engineering
Anchor Modeling

ER '09 Proceedings of the 28th International Conference on Conceptual Modeling
Metadata management in a multiversion data warehouse

Journal on data semantics VIII
Multiversion data warehouse constraints

DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Managing and querying versions of multiversion data warehouse

EDBT'06 Proceedings of the 10th international conference on Advances in Database Technology
A multiversion-based multidimensional model

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
What time is it in the data warehouse?

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
A versioning management model for ontology-based data warehouses

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Metadata management in a multiversion data warehouse

OTM'05 Proceedings of the 2005 OTM Confederated international conference on On the Move to Meaningful Internet Systems: CoopIS, COA, and ODBASE - Volume Part II
Managing evolution of data warehouses by means of nested transactions

ADVIS'06 Proceedings of the 4th international conference on Advances in Information Systems
Multiversion spatio-temporal telemetric data warehouse

ADBIS'09 Proceedings of the 13th East European conference on Advances in Databases and Information Systems
ORE: an iterative approach to the design and evolution of multi-dimensional schemas

Proceedings of the fifteenth international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.