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 E. 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… Expand
Modeling and Querying Multidimensional Bitemporal Data Warehouses
Data warehouses have been considered to be the key aspect of success for any Decision Support System (DSS). Temporal database research has produced important results in this field. Data warehousesExpand
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. Expand
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. Expand
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. Expand
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. Expand
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. Expand
Data warehouses are mainly used for business data analysis by querying and reporting huge collections of data. For the management of historical data, temporal data warehouses have been developed. TwoExpand
Season queries on a temporal multidimensional model for OLAP
This paper extends a formal temporal multidimensional model with the notion of season and proposes query language constructs to enable season queries and illustrates the application of the proposed extensions with several season queries. Expand


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. Expand
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. Expand
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. Expand
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. Expand
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. Expand
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. Expand
A formal model for temporal schema versioning in object-oriented databases
The proposed model supports all the schema changes which are usually considered in the OODB literature, for which an operational semantics and a formal analysis of their correct behaviour is provided. Expand
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. Expand
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. Expand
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. Expand