OATAO - Open Archive Toulouse Archive Ouverte Open Access Week

Multidimensional database modelling with differentiated multiple aggregations

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

(Document in English)

PDF (Author's version) - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader

Official URL: http://dx.doi.org/10.1080/12460125.2014.934125


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
Additional Information:Thanks to Hermès Science editor. The definitive version is available at http://www.sciencedirect.com The original PDF of the article can be found at Chemical Physics Letters website : http://www.sciencedirect.com/science/article/pii/S0009261400005583# »
HAL Id:hal-01153718
Audience (journal):International peer-reviewed journal
Uncontrolled Keywords:
Institution:Université de Toulouse > Institut National Polytechnique de Toulouse - Toulouse INP (FRANCE)
French research institutions > Centre National de la Recherche Scientifique - CNRS (FRANCE)
Université de Toulouse > Université Toulouse III - Paul Sabatier - UT3 (FRANCE)
Université de Toulouse > Université Toulouse - Jean Jaurès - UT2J (FRANCE)
Université de Toulouse > Université Toulouse 1 Capitole - UT1 (FRANCE)
Laboratory name:
Deposited On:04 Feb 2015 16:17

Repository Staff Only: item control page