Schema evolution in multiversion data warehouses

Ahmed, Waqas; Vaisman, Alejandro Ariel; Zimányi, Esteban; Wrembel, Robert

artículo de publicación periódica.page.titleprefix
Schema evolution in multiversion data warehouses

dc.contributor.author	Ahmed, Waqas
dc.contributor.author	Vaisman, Alejandro Ariel
dc.contributor.author	Zimányi, Esteban
dc.contributor.author	Wrembel, Robert
dc.date.accessioned	2022-05-23T17:40:46Z
dc.date.available	2022-05-23T17:40:46Z
dc.date.issued	2021
dc.description.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."	en
dc.identifier.issn	1548-3924
dc.identifier.uri	http://ri.itba.edu.ar/handle/123456789/3889
dc.language.iso	en	en
dc.relation	info:eu-repo/semantics/altIdentifier/doi/10.4018/IJDWM.2021100101
dc.subject	ALMACENES DE DATOS	es
dc.subject	OLAP	es
dc.title	Schema evolution in multiversion data warehouses	en
dc.type	Artículos de Publicaciones Periódicas	es
dc.type	info:eu-repo/semantics/publishedVersion
dspace.entity.type	Artículo de Publicación Periódica
itba.description.filiation	Fil: Ahmed, Waqas. Université Libre de Bruxelles; Bélgica.
itba.description.filiation	Fil: Zimányi, Esteban. Université Libre de Bruxelles; Bélgica.
itba.description.filiation	Fil: Vaisman, Alejandro Ariel. Instituto Tecnológico de Buenos Aires, Argentina.
itba.description.filiation	Fil: Wrembel, Robert. Poznan University of Technology; Polonia.