A temporal multidimensional model and OLAP operators

"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 storin...

Descripción completa

Detalles Bibliográficos
Autores principales: Ahmed, Waqas, Zimányi, Esteban, Vaisman, Alejandro Ariel, Wrembel, Robert
Formato: Artículos de Publicaciones Periódicas publishedVersion
Lenguaje:Inglés
Publicado: 2020
Materias:
ALMACENES DE DATOS
BASE DE DATOS
OLAP
Acceso en línea:http://ri.itba.edu.ar/handle/123456789/3255
Aporte de:
Repositorio Institucional Instituto Tecnológico de Buenos Aires (ITBA) de Instituto Tecnológico de Buenos Aires (ITBA)
id I32-R138-123456789-3255
record_format dspace
spelling I32-R138-123456789-32552022-12-07T13:06:05Z A temporal multidimensional model and OLAP operators Ahmed, Waqas Zimányi, Esteban Vaisman, Alejandro Ariel Wrembel, Robert ALMACENES DE DATOS BASE DE DATOS OLAP "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 temporalsemantics, which isformalized 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." 2020-12-17T13:24:06Z 2020-12-17T13:24:06Z 2020 Artículos de Publicaciones Periódicas info:eu-repo/semantics/publishedVersion http://ri.itba.edu.ar/handle/123456789/3255 en info:eu-repo/semantics/reference/doi/10.4018/IJDWM.2020100107 application/pdf
institution Instituto Tecnológico de Buenos Aires (ITBA)
institution_str I-32
repository_str R-138
collection Repositorio Institucional Instituto Tecnológico de Buenos Aires (ITBA)
language Inglés
topic ALMACENES DE DATOS
BASE DE DATOS
OLAP
spellingShingle ALMACENES DE DATOS
BASE DE DATOS
OLAP
Ahmed, Waqas
Zimányi, Esteban
Vaisman, Alejandro Ariel
Wrembel, Robert
A temporal multidimensional model and OLAP operators
topic_facet ALMACENES DE DATOS
BASE DE DATOS
OLAP
description "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 temporalsemantics, which isformalized 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."
format Artículos de Publicaciones Periódicas
publishedVersion
author Ahmed, Waqas
Zimányi, Esteban
Vaisman, Alejandro Ariel
Wrembel, Robert
author_facet Ahmed, Waqas
Zimányi, Esteban
Vaisman, Alejandro Ariel
Wrembel, Robert
author_sort Ahmed, Waqas
title A temporal multidimensional model and OLAP operators
title_short A temporal multidimensional model and OLAP operators
title_full A temporal multidimensional model and OLAP operators
title_fullStr A temporal multidimensional model and OLAP operators
title_full_unstemmed A temporal multidimensional model and OLAP operators
title_sort temporal multidimensional model and olap operators
publishDate 2020
url http://ri.itba.edu.ar/handle/123456789/3255
work_keys_str_mv AT ahmedwaqas atemporalmultidimensionalmodelandolapoperators
AT zimanyiesteban atemporalmultidimensionalmodelandolapoperators
AT vaismanalejandroariel atemporalmultidimensionalmodelandolapoperators
AT wrembelrobert atemporalmultidimensionalmodelandolapoperators
AT ahmedwaqas temporalmultidimensionalmodelandolapoperators
AT zimanyiesteban temporalmultidimensionalmodelandolapoperators
AT vaismanalejandroariel temporalmultidimensionalmodelandolapoperators
AT wrembelrobert temporalmultidimensionalmodelandolapoperators
_version_ 1765660922565623808

Ejemplares similares