Multi-version data warehouse: A survey

Saroha, Kriti; Gosain, Anjana

doi:10.1109/confluence.2014.6949236

Cited by 2 publications

(1 citation statement)

References 26 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…These new dimensions contain several versions of a hierarchy, each version is related to a particular context instance in particular that corresponds to the relevance domain of the version concerned. Several other articles provide some solution to the versioning issue (see [42] for a survey on versioning in data warehouse). But, a querying process adapted to our methodology needs to be developed.…”

Section: Discussionmentioning

confidence: 99%

A Semi-Automatic Design Methodology for (Big) Data Warehouse Transforming Facts into Dimensions

Sautot¹,

Bimonte²,

Journaux³

2021

IEEE Trans. Knowl. Data Eng.

View full text Add to dashboard Cite

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 needs, 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.

show abstract

Section: Discussionmentioning

confidence: 99%