Implementation of multidimensional databases in column-oriented NoSQL systems

Max Chevalier (1, 2) , Mohammed El Malki (1) , Arlind Kopliku (1) , Olivier Teste (1, 3) , Ronan Tournier (1, 4)

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

NoSQL (Not Only SQL) systems are becoming popular due to known advantages such as horizontal scalability and elasticity. In this paper, we study the implementation of multidimensional data warehouses with columnoriented NoSQL systems. We define mapping rules that transform the conceptual multidimensional data model to logical column-oriented models. We consider three different logical models and we use them to instantiate data warehouses. We focus on data loading, model-to-model conversion and OLAP cuboid computation.

Mots clés: Column-oriented NoSQL model; NoSQL databases; Model transformation rules; Multidimensional modelling; Big Data; Data warehouse design

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

Max Chevalier, Mohammed El Malki, Arlind Kopliku, Olivier Teste, Ronan Tournier. Implementation of multidimensional databases in column-oriented NoSQL systems. 19th East-European Conference on Advances in Databases and Information Systems (ADBIS), Sep 2015, Poitiers, France. pp. 79-91. ⟨hal-01363342⟩