A Temporal Multidimensional Model and OLAP Operators

Waqas Ahmed, Esteban Zimányi, Alejandro Ariel Vaisman and Robert Wrembel
Additional contact information
Waqas Ahmed: CODE WIT, Université Libre de Bruxelles, Belgium
Esteban Zimányi: CODE WIT, Université Libre de Bruxelles, Brussels, Belgium
Alejandro Ariel Vaisman: Department of Information Engineering, Instituto Tecnológico de Buenos Aires, Argentina
Robert Wrembel: Faculty of Computing and Telecommunications, Poznan University of Technology, Poznan, Poland

International Journal of Data Warehousing and Mining (IJDWM), 2020, vol. 16, issue 4, 112-143

Abstract: Usually, data in data warehouses (DWs) are stored using the notion of the multidimensional (MD) model. Often, DWs change in content and structure due to several reasons, like, for instance, changes in a business scenario or technology. For accurate decision-making, a DW model must allow storing and analyzing time-varying data. This paper addresses the problem of keeping track of the history of the data in a DW. For this, first, a formalization of the traditional MD model is proposed and then extended as a generalized temporal MD model. The model comes equipped with a collection of typical online analytical processing (OLAP) operations with temporal semantics, which is formalized for the four classic operations, namely roll-up, dice, project, and drill-across. Finally, the mapping from the generalized temporal model into a relational schema is presented together with an implementation of the temporal OLAP operations in standard SQL.

Date: 2020
References: Add references at CitEc
Citations:

Downloads: (external link)
http://services.igi-global.com/resolvedoi/resolve. ... 018/IJDWM.2020100107 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:igg:jdwm00:v:16:y:2020:i:4:p:112-143

Access Statistics for this article

International Journal of Data Warehousing and Mining (IJDWM) is currently edited by Eric Pardede

More articles in International Journal of Data Warehousing and Mining (IJDWM) from IGI Global
Bibliographic data for series maintained by Journal Editor ().