A Model and Language for Bitemporal Schema Versioning in Data Warehouses

  title={A Model and Language for Bitemporal Schema Versioning in Data Warehouses},
  author={E.-J. Rechy-Ramirez and Edgard Ben{\'i}tez-Guerrero},
  journal={2006 15th International Conference on Computing},
A data warehouse (DW) is a vast collection of historical data built to support multidimensional data analysis applications. In this context, an important problem is that of evolving the implementation (multidimensional, relational) schema of a DW to incorporate new requirements. This paper introduces a conceptual evolution model based on bitemporal versioning of multidimensional schemas, which allows one to modify the DW schema (a) in an implementation-independent manner, and (b) without… 

Figures from this paper

Modeling and Querying Multidimensional Bitemporal Data Warehouses

This paper introduces a bitemporal data warehouse model that both valid time and transaction time are attached to attributes and performance of available well-known relational database and bitem temporal extension for data warehouse is evaluated and compared.

Bi-temporal schema versioning in bi-temporal data warehouse

This work proposes an approach which allows not only to manage revisions of schema and dimension data but also track retroactive and proactive updates in DW using both valid-time and transaction-time.

An Ontological Approach to Handle Multidimensional Schema Evolution for Data Warehouse

An ontological approach to automate the evolution of a data warehouse schema is proposed and assists the data warehouse designer in handling evolution at the ontological level based on which decision can be made to carry out the changes at the physical level.

Handling Bitemporal Schema Versions in Multi-temporal Environment for Data Warehouse

Meta-schema with bitemporal timestamps is proposed with synchronous and non-synchronous mappings between data and schema versioning to record the changes occurring in the structure of schema for multiple temporal data formats.

DWEVOLVE: a requirement based framework for data warehouse evolution

This paper presents a theoretical framework called DWEVOLVE to support data warehouse evolution, which enhances the functionality of previously designed framework by taking into account the requirements specified by the users.

A Survey on Temporal Data Warehousing

The main concepts and terminology of temporal databases are introduced and the open research issues also in connection with their implementation on commercial tools are discussed.

Temporal and Evolving Data Warehouse Design

This paper analyses the schemes that satisfy such challenging aspects faced by a data warehouse and proposes taxonomy for characterizing the existing models to temporal data management in data warehouse.

Implementing Schema Evolution in Data Warehouse through Complex Hierarchy Semantics

This paper has proposed evolution operators and certain constraints that need to be fulfilled for ensuring data integrity and schema correctness in case of evolution, and considered a formal metamodel to model the constructs in data warehouse.


Two current approaches for dealing with temporal data in data warehouses are compared in this paper, Object-Relational Temporal data Warehouse (ORTDW) model and Starnest Temporal Data Warehouse (S-TDW) model.



On Schema Evolution in Multidimensional Databases

This paper presents a formal framework to describe evolutions of multidimensional schemas and their effects on the schema and on the instances and describes how the algebra enables a tool supported environment for schema evolution.

Exploiting bitemporal schema versions for managing an historical medical data warehouse: a case study

This work presents the proposition for the management, storage and visualization of a data warehouse (current and historical) in a medical environment using bitemporal schema versions, placed above the database management system and is completely orthogonal to the DBMS data model.

Creation and management of versions in multiversion data warehouse

This paper presents 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.

A Model for a Temporal Data Warehouse

An architecture for temporal data warehouse systems which allows the registration of temporal versions of dimension data and the transfer of data between di erent temporal versions is proposed.

A conceptual solution for representing time in data warehouse dimensions

This paper introduces temporal extensions for the MultiDimER model, a conceptual multidimensional model that allows a conceptual representation of time-varying levels, attributes, and hierarchies and discusses different cases depending on whether the changes in levels affect the relationships between them.

Updating OLAP dimensions

A formal model supporting dimension updates is introduced, adding a set of semantically meaningful operators which encapsulate common sequences of primitive dimension updates in a more efficient way and defines two mappings from the multidimensional to the relational model.

A formal model for temporal schema versioning in object-oriented databases

A Bi-Temporal Data Warehouse Model

This paper presents a bitemporal extension of the COMET metamodel that enables us to represent not only the valid time of structural modifications, but also the transaction time.

A Temporal Query Language for OLAP: Implementation and a Case Study

This paper shows how to translate a TOLAP program to SQL, and presents a real-life case study, a medical center in Buenos Aires, to show how the proposed temporal multidimensional model and query language can address problems that occur in real situations and that current nontemporal commercial systems cannot deal with.

Changes of Dimension Data in Temporal Data Warehouses

An extension of the multi-dimensional data model employed in data warehouses allowing to cope correctly with changes in dimension data: a temporal multi- dimensional data model allows the registration of temporal versions of dimension data.