Title
Implementation of multidimensional databases in column-oriented NoSQL systems
Abstract
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 based on column-oriented NoSQL systems. To do this, we define a set of mapping rules that transform a conceptual multidimensional data model into a logical column-oriented model. We consider three ways (three sub-models) to structure conceptual multidimensional data model into a column-oriented model. Then, we show an implementation of the proposed rules. Finally, we focus, through experiment, on data loading, model-to-model conversion and OLAP cuboid computation.
Year
DOI
Venue
2015
10.1007/978-3-319-23135-8_6
ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2015
Keywords
Field
DocType
Data warehouse design,Multidimensional modelling,NoSQL databases,Model transformation rules,Column-Oriented NoSQL model
Data warehouse,SQL,Data mining,Computer science,NoSQL,Online analytical processing,Data model,Big data,Database,Computation,Scalability
Conference
Volume
Issue
ISSN
9282
1
0302-9743
Citations 
PageRank 
References 
4
0.45
14
Authors
5
Name
Order
Citations
PageRank
Max Chevalier182.29
M El Malki2232.78
Arlind Kopliku3649.45
Olivier Teste432660.56
Ronan Tournier515114.66