Skip to Main content Skip to Navigation
Conference papers

Implementing Multidimensional Data Warehouses into NoSQL

Abstract : Not only SQL (NoSQL) databases are becoming increasingly popular and have some interesting strengths such as scalability and flexibility. In this paper, we investigate on the use of NoSQL systems for implementing OLAP (On-Line Analytical Processing) systems. More precisely, we are interested in instantiating OLAP systems (from the conceptual level to the logical level) and instantiating an aggregation lattice (optimization). We define a set of rules to map star schemas into two NoSQL models: column-oriented and document-oriented. The experimental part is carried out using the reference benchmark TPC. Our experiments show that our rules can effectively instantiate such systems (star schema and lattice). We also analyze differences between the two NoSQL systems considered. In our experiments, HBase (column-oriented) happens to be faster than MongoDB (document-oriented) in terms of loading time.
Complete list of metadatas

Cited literature [20 references]  Display  Hide  Download

https://hal.archives-ouvertes.fr/hal-01387759
Contributor : Open Archive Toulouse Archive Ouverte (oatao) <>
Submitted on : Wednesday, October 26, 2016 - 9:56:40 AM
Last modification on : Monday, July 20, 2020 - 11:24:21 AM

File

chevalier_15250.pdf
Files produced by the author(s)

Identifiers

Citation

Max Chevalier, Mohammed El Malki, Arlind Kopliku, Olivier Teste, Ronan Tournier. Implementing Multidimensional Data Warehouses into NoSQL. 17th International Conference on Enterprise Information Systems (ICEIS 2015) held in conjunction with ENASE 2015 and GISTAM 2015, Apr 2015, Barcelone, Spain. pp.108-130, ⟨10.1007/978-3-319-29133-8_6⟩. ⟨hal-01387759⟩

Share

Metrics

Record views

516

Files downloads

2403