Requirements-driven data warehouse design based on enhanced pivot tables

The design of data warehouses (DWs) is based on both their data sources and users’ requirements. The more closely the DW multidimensional schema reflects the stakeholders’ needs, the more effectively they will make use of the DW content for their OLAP analyses. Thus, considerable attention has been...

Descripción completa

Guardado en:
Detalles Bibliográficos
Autores principales: Bimonte, Sandro, Antonelli, Rubén Leandro, Rizzi, Stefano
Formato: Articulo
Lenguaje:Inglés
Publicado: 2020
Materias:
Informática
Data warehouses
Requirements elicitation
Pivot tables
Multidimensional modeling
Acceso en línea:http://sedici.unlp.edu.ar/handle/10915/131987
Aporte de:
SEDICI (UNLP) de Universidad Nacional de La Plata
id I19-R120-10915-131987
record_format dspace
institution Universidad Nacional de La Plata
institution_str I-19
repository_str R-120
collection SEDICI (UNLP)
language Inglés
topic Informática
Data warehouses
Requirements elicitation
Pivot tables
Multidimensional modeling
spellingShingle Informática
Data warehouses
Requirements elicitation
Pivot tables
Multidimensional modeling
Bimonte, Sandro
Antonelli, Rubén Leandro
Rizzi, Stefano
Requirements-driven data warehouse design based on enhanced pivot tables
topic_facet Informática
Data warehouses
Requirements elicitation
Pivot tables
Multidimensional modeling
description The design of data warehouses (DWs) is based on both their data sources and users’ requirements. The more closely the DW multidimensional schema reflects the stakeholders’ needs, the more effectively they will make use of the DW content for their OLAP analyses. Thus, considerable attention has been given in the literature to DW requirements analysis, including requirements elicitation, specification and validation. Unfortunately, traditional approaches are based on complex formalisms that cannot be used with decision makers who have no previous experience with DWs and OLAP. This forces a sharp separation between elicitation and specification. To cope with this problem, we propose a new requirements analysis process where pivot tables, a well-known representation for multidimensional data often used by decision makers, are enhanced to be used both for elicitation and as a specification formalism. A pivot table is a two-dimensional spreadsheet that supports the analyses of multidimensional data by nesting several dimensions on the x- or y-axis and displaying data on multiple pages. The requirements analysis process we propose is iterative and relies on both unstructured and structured interviews; particular attention is given to enable the design of irregular multidimensional schemata, which are often present in real-world DWs but can hardly be understood by unskilled users. Finally, we validate our proposal using a real case study in the biodiversity domain.
format Articulo
Articulo
author Bimonte, Sandro
Antonelli, Rubén Leandro
Rizzi, Stefano
author_facet Bimonte, Sandro
Antonelli, Rubén Leandro
Rizzi, Stefano
author_sort Bimonte, Sandro
title Requirements-driven data warehouse design based on enhanced pivot tables
title_short Requirements-driven data warehouse design based on enhanced pivot tables
title_full Requirements-driven data warehouse design based on enhanced pivot tables
title_fullStr Requirements-driven data warehouse design based on enhanced pivot tables
title_full_unstemmed Requirements-driven data warehouse design based on enhanced pivot tables
title_sort requirements-driven data warehouse design based on enhanced pivot tables
publishDate 2020
url http://sedici.unlp.edu.ar/handle/10915/131987
work_keys_str_mv AT bimontesandro requirementsdrivendatawarehousedesignbasedonenhancedpivottables
AT antonellirubenleandro requirementsdrivendatawarehousedesignbasedonenhancedpivottables
AT rizzistefano requirementsdrivendatawarehousedesignbasedonenhancedpivottables
bdutipo_str Repositorios
_version_ 1764820453758599169

Ejemplares similares