Welcome to the InfoSci Platform
Schema Evolution in Multiversion Data Warehouses

Schema Evolution in Multiversion Data Warehouses

Waqas Ahmed, Esteban Zimányi, Alejandro A. Vaisman, Robert Wrembel
Copyright: © 2021 |Volume: 17 |Issue: 4 |Pages: 28
ISSN: 1548-3924|EISSN: 1548-3932|EISBN13: 9781799859512|DOI: 10.4018/IJDWM.2021100101
Cite Article Cite Article

MLA

Ahmed, Waqas, et al. "Schema Evolution in Multiversion Data Warehouses." IJDWM vol.17, no.4 2021: pp.1-28. http://doi.org/10.4018/IJDWM.2021100101

APA

Ahmed, W., Zimányi, E., Vaisman, A. A., & Wrembel, R. (2021). Schema Evolution in Multiversion Data Warehouses. International Journal of Data Warehousing and Mining (IJDWM), 17(4), 1-28. http://doi.org/10.4018/IJDWM.2021100101

Chicago

Ahmed, Waqas, et al. "Schema Evolution in Multiversion Data Warehouses," International Journal of Data Warehousing and Mining (IJDWM) 17, no.4: 1-28. http://doi.org/10.4018/IJDWM.2021100101

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

Data warehouses (DWs) evolve in both their content and schema due to changes of user requirements, business processes, or external sources to name a few. Although multiple approaches using temporal and/or multiversion DWs have been proposed to handle these changes, an efficient solution for this problem is still lacking. The authors' approach is to separate concerns and use temporal DWs to deal with content changes, and multiversion DWs to deal with schema changes. To address the former, previously, they have proposed a temporal multidimensional (MD) model. In this paper, they propose a multiversion MD model for schema evolution to tackle the latter problem. The two models complement each other and allow managing both content and schema evolution. In this paper, the semantics of schema modification operators (SMOs) to derive various schema versions are given. It is also shown how online analytical processing (OLAP) operations like roll-up work on the model. Finally, the mapping from the multiversion MD model to a relational schema is given along with OLAP operations in standard SQL.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.