Schema evolution in multiversion data warehouses

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

Descripción completa

Guardado en:
Detalles Bibliográficos
Autores principales: Ahmed, Waqas, Vaisman, Alejandro Ariel, Zimányi, Esteban, Wrembel, Robert
Formato: Artículos de Publicaciones Periódicas publishedVersion
Lenguaje:Inglés
Publicado: 2022
Materias:
ALMACENES DE DATOS
OLAP
Acceso en línea:http://ri.itba.edu.ar/handle/123456789/3889
Aporte de:
Repositorio Institucional Instituto Tecnológico de Buenos Aires (ITBA) de Instituto Tecnológico de Buenos Aires (ITBA)
id I32-R138-123456789-3889
record_format dspace
spelling I32-R138-123456789-38892022-12-07T13:07:01Z Schema evolution in multiversion data warehouses Ahmed, Waqas Vaisman, Alejandro Ariel Zimányi, Esteban Wrembel, Robert ALMACENES DE DATOS OLAP "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." 2022-05-23T17:40:46Z 2022-05-23T17:40:46Z 2021 Artículos de Publicaciones Periódicas info:eu-repo/semantics/publishedVersion 1548-3924 http://ri.itba.edu.ar/handle/123456789/3889 en info:eu-repo/semantics/altIdentifier/doi/10.4018/IJDWM.2021100101 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
OLAP
spellingShingle ALMACENES DE DATOS
OLAP
Ahmed, Waqas
Vaisman, Alejandro Ariel
Zimányi, Esteban
Wrembel, Robert
Schema evolution in multiversion data warehouses
topic_facet ALMACENES DE DATOS
OLAP
description "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."
format Artículos de Publicaciones Periódicas
publishedVersion
author Ahmed, Waqas
Vaisman, Alejandro Ariel
Zimányi, Esteban
Wrembel, Robert
author_facet Ahmed, Waqas
Vaisman, Alejandro Ariel
Zimányi, Esteban
Wrembel, Robert
author_sort Ahmed, Waqas
title Schema evolution in multiversion data warehouses
title_short Schema evolution in multiversion data warehouses
title_full Schema evolution in multiversion data warehouses
title_fullStr Schema evolution in multiversion data warehouses
title_full_unstemmed Schema evolution in multiversion data warehouses
title_sort schema evolution in multiversion data warehouses
publishDate 2022
url http://ri.itba.edu.ar/handle/123456789/3889
work_keys_str_mv AT ahmedwaqas schemaevolutioninmultiversiondatawarehouses
AT vaismanalejandroariel schemaevolutioninmultiversiondatawarehouses
AT zimanyiesteban schemaevolutioninmultiversiondatawarehouses
AT wrembelrobert schemaevolutioninmultiversiondatawarehouses
_version_ 1765660836009869312

Ejemplares similares