Multidimensional database modelling with differentiated multiple aggregations - Archive ouverte HAL
Article Dans Une Revue Journal of Decision Systems Année : 2014

Multidimensional database modelling with differentiated multiple aggregations

Résumé

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
Origine Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

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

Identifiants

Citer

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⟩
127 Consultations
237 Téléchargements

Altmetric

Partager

More