Schema Versioning in Data Warehouses

0
108

Authors: Gottfried Vossen, Jens Lechtenbörger, Matteo Golfarelli, Stefano Rizzi

Tags: 2004, conceptual modeling

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. After introducing an algebra of DW schema operations, we define a history of versions for data warehouse schemata and discuss the relationship between the temporal horizon spanned by a query and the schema on which it can consistently be formulated.

Read the full paper here: https://link.springer.com/chapter/10.1007/978-3-540-30466-1_38