OLAP in Multifunction Multidimensional Database

Ali Hassan (1) , Franck Ravat (1, 2) , Olivier Teste (1, 3) , Ronan Tournier (1, 2) , Gilles Zurfluh (1, 2)

1 IRIT-SIG - Systèmes d’Informations Généralisées
2 UT Capitole - Université Toulouse Capitole
3 UT2J - Université Toulouse - Jean Jaurès

Most models proposed for modeling multidimensional data warehouses consider a same function to determine how measure values are aggregated. We provide a more flexible conceptual model allowing associating each measure with several aggregation functions according to dimensions, hierarchies, and levels of granularity. This article studies the impacts of this model on the multidimensional table (MT) and the OLAP algebra [11]. It shows how the MT can handle several aggregation functions. It also introduces the changes of the internal mechanism of OLAP operators to take into account several aggregation functions especially if these functions are non-commutative.

Mots clés: Multidimensional database; Multidimensional table; OLAP analysis; OLAP operators -Aggregation function

Domaines: Théorie de l'information [cs.IT]; Recherche d'information [cs.IR]

Ali Hassan, Franck Ravat, Olivier Teste, Ronan Tournier, Gilles Zurfluh. OLAP in Multifunction Multidimensional Database. 17th East-European Conference on Advances in Databases and Information Systems (ADBIS 2013), Sep 2013, Genoa, Italy. pp. 190-203. ⟨hal-01228753⟩