Multidimensional database modelling with differentiated multiple aggregations - Archive ouverte HAL Access content directly
Journal Articles Journal of Decision Systems Year : 2014

Multidimensional database modelling with differentiated multiple aggregations

Abstract

Many solutions have been defined for multidimensional database modelling. These propositions consider the same aggregation function to determine the values of an indicator according to different levels of granularity into the multidimensional space. We provide a more flexible conceptual model that supports multiple differentiated aggregations. Multiple aggregations allow associating different aggregation functions to the same measure for each dimension and for each hierarchy. Differentiated aggregation allows specific aggregations at each level (parameter). Our model is based on a double graphical formalism, expressive enough to control the validity of aggregation functions. We also study the consequences of this conceptual modelling for building lattices of pre-computed aggregates in a relational online analytical processing (R-OLAP) environment.
Fichier principal
Vignette du fichier
hassan_13257.pdf (2.23 Mo) Télécharger le fichier
Origin : Files produced by the author(s)
Loading...

Dates and versions

hal-01153718 , version 1 (20-05-2015)

Identifiers

Cite

Ali Hassan, Franck Ravat, Olivier Teste, Ronan Tournier, Gilles Zurfluh. Multidimensional database modelling with differentiated multiple aggregations. Journal of Decision Systems, 2014, vol. 23 (n° 4), pp. 437-459. ⟨10.1080/12460125.2014.934125⟩. ⟨hal-01153718⟩
81 View
184 Download

Altmetric

Share

Gmail Facebook Twitter LinkedIn More