Journal
IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING
Volume 33, Issue 1, Pages 28-42Publisher
IEEE COMPUTER SOC
DOI: 10.1109/TKDE.2019.2925621
Keywords
Data warehouse; OLAP; modeling; hierarchy; version; refinement
Categories
Funding
- French National Agency of Research [ANR-17-CE04-0012]
- AgroParisTech
- Agence Nationale de la Recherche (ANR) [ANR-17-CE04-0012] Funding Source: Agence Nationale de la Recherche (ANR)
Ask authors/readers for more resources
This article proposes a methodology to enrich a multidimensional schema by integrating factual data into dimensions to meet changing needs of decision makers, providing new analytical possibilities and impacting the entire schema managed by multidimensional modeling, hierarchy calculation, and versioning.
A decision support system is used by decision makers for a long time. But, in some cases, the originally designed multidimensional schema does not cover the entire needs of decision makers, which can change over time. One such unfulfilled need, is using facts to describe dimension members. In this article, we propose a methodology to transform the constellation schema of a data warehouse by integrating factual data into a dimension. The proposed methodology and algorithms enrich a constellation multidimensional schema with new analytical possibilities for decision makers. This enrichment has repercussions for the entire multidimensional schema that are managed by multidimensional modeling, hierarchy calculation and the hierarchy version. In this article, we present a theoretical view of the proposed methodology supported by a case study, an implemented prototype and a complete evaluation based on a standard benchmark.
Authors
I am an author on this paper
Click your name to claim this paper and add it to your profile.
Reviews
Recommended
No Data Available