Title
How Can We Implement a Multidimensional Data Warehouse Using NoSQL?
Abstract
The traditional OLAP (On-Line Analytical Processing) systems store data in relational databases. Unfortunately, it is difficult to manage big data volumes with such systems. As an alternative, NoSQL systems (Not-only SQL) provide scalability and flexibility for an OLAP system. We define a set of rules to map star schemas and its optimization structure, a precomputed aggregate lattice, into two logical NoSQL models: column-oriented and document-oriented. Using these rules we analyse and implement two decision support systems, one for each model (using MongoDB and HBase). We compare both systems during the phases of data (generated using the TPC-DS benchmark) loading, lattice generation and querying.
Year
DOI
Venue
2015
10.1007/978-3-319-29133-8_6
Lecture Notes in Business Information Processing
Keywords
Field
DocType
NoSQL,OLAP,Aggregate lattice,Column-oriented,Document-oriented
Data warehouse,SQL,Data mining,Star schema,Computer science,NoSQL,Online analytical processing,Database,Scalability
Conference
Volume
ISSN
Citations 
241
1865-1348
10
PageRank 
References 
Authors
0.65
13
5
Name
Order
Citations
PageRank
Max Chevalier19421.63
M El Malki2232.78
Arlind Kopliku3649.45
Olivier Teste432660.56
Ronan Tournier515114.66