Implementation of Multidimensional Databases with Document-Oriented NoSQL

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 data warehouses with document-oriented NoSQL systems. We propose mapping rules that transform the multidimensional data model to logical document-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: OLAP; NoSQL; Big Data; Multidimensional Database

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 with Document-Oriented NoSQL. 17th International Conference on Big Data Analytics and Knowledge Discovery (DaWaK 2015) in 26th DEXA Conferences and Workshops, Sep 2015, Valencia, Spain. pp. 379-390. ⟨hal-01371802⟩