Multidimensional database modelling with differentiated multiple aggregations

Hassan, Ali, Ravat, Franck, Teste, Olivier, Tournier, Ronan and Zurfluh, Gilles (2014) Multidimensional database modelling with differentiated multiple aggregations. Journal of Decision Systems, 23 (4). pp. 437-459.

[img]
Preview
Text
Download (2MB) | Preview

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.

Item Type: Article
Language: English
Date: 2014
Refereed: Yes
Uncontrolled Keywords: Multiple aggregations - Multidimensional database - Data warehouse conceptual modelling - Multidimensional lattices
Subjects: H- INFORMATIQUE
Divisions: Institut de Recherche en Informatique de Toulouse
Site: UT1
Date Deposited: 27 Mar 2019 14:27
Last Modified: 27 Mar 2019 14:27
URI: http://publications.ut-capitole.fr/id/eprint/29732

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year