Schema versioning in data warehouses: enabling cross-version querying via schema augmentation

Authors:
Matteo Golfarelli;Jens Lechtenbörger;Stefano Rizzi;Gottfried Vossen
Affiliations:
DEIS, University of Bologna, Italy;Department of Information Systems, University of Muenster, Muenster, Germany;DEIS, University of Bologna, Italy;Department of Information Systems, University of Muenster, Muenster, Germany
Venue:
Data & Knowledge Engineering - Special issue: WIDM 2004
Year:
2006

Citing 22
Cited 13

Schema evolution and the relational algebra

Information Systems
A consensus glossary of temporal database concepts

ACM SIGMOD Record
A methodological framework for data warehouse design

Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
Graph Algorithms for Functional Dependency Manipulation

Journal of the ACM (JACM)
A general framework for the view selection problem for data warehouse design and evolution

Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP
The TSQL2 Temporal Query Language

The TSQL2 Temporal Query Language
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom

The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Building the Data Warehouse,3rd Edition

Building the Data Warehouse,3rd Edition
Introduction to Algorithms

Introduction to Algorithms
Functional and inclusion dependencies a graph theoretic approach

PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals

Data Mining and Knowledge Discovery
Index Selection for OLAP

ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
The COMET Metamodel for Temporal Data Warehouses

CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Supporting Dimension Updates in an OLAP Server

CAiSE '02 Proceedings of the 14th International Conference on Advanced Information Systems Engineering
Consistency in Data Warehouse Dimensions

IDEAS '02 Proceedings of the 2002 International Symposium on Database Engineering & Applications
Summarizability in OLAP and Statistical Data Bases

SSDBM '97 Proceedings of the Ninth International Conference on Scientific and Statistical Database Management
On Schema Versioning in Temporal Databases

Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
Multidimensional normal forms for data warehouse design

Information Systems
Temporal data warehousing

Temporal data warehousing
Creation and management of versions in multiversion data warehouse

Proceedings of the 2004 ACM symposium on Applied computing
Computing unique canonical covers for simple FDs via transitive reduction

Information Processing Letters
Theory of Relational Databases

Theory of Relational Databases

Research in data warehouse modeling and design: dead or alive?

DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models

Data & Knowledge Engineering
Integrated data management in complex product collaborative design

Computers in Industry
Modeling Transformations between Versions of a Temporal Data Warehouse

ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
Design Metrics for Data Warehouse Evolution

ER '08 Proceedings of the 27th International Conference on Conceptual Modeling
Modeling data federations in ORM

OTM'07 Proceedings of the 2007 OTM confederated international conference on On the move to meaningful internet systems - Volume Part I
Editorial: Anchor modeling - Agile information modeling in evolving data environments

Data & Knowledge Engineering
What time is it in the data warehouse?

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Season queries on a temporal multidimensional model for OLAP

Mathematical and Computer Modelling: An International Journal
ORE: an iterative approach to the design and evolution of multi-dimensional schemas

Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Toward propagating the evolution of data warehouse on data marts

MEDI'12 Proceedings of the 2nd international conference on Model and Data Engineering
A BPMN-Based Design and Maintenance Framework for ETL Processes

International Journal of Data Warehousing and Mining
Slowly changing measures

Proceedings of the sixteenth international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

Abstract

As several mature implementations of data warehousing systems are fully operational, a crucial role in preserving their up-to-dateness is played by the ability to manage the changes that the data warehouse (DW) schema undergoes over time in response to evolving business requirements. In this paper we propose an approach to schema versioning in DWs, where the designer may decide to undertake some actions on old data aimed at increasing the flexibility in formulating cross-version queries, i.e., queries spanning multiple schema versions. First, we introduce a representation of DW schemata as graphs of simple functional dependencies, and discuss its properties. Then, after defining an algebra of schema graph modification operations aimed at creating new schema versions, we discuss how augmented schemata can be introduced to increase flexibility in cross-version querying. Next, we show how a history of versions for DW schemata is managed and discuss the relationship between the temporal horizon spanned by a query and the schema on which it can consistently be formulated.