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 Chevalier | 1 | 94 | 21.63 |
M El Malki | 2 | 23 | 2.78 |
Arlind Kopliku | 3 | 64 | 9.45 |
Olivier Teste | 4 | 326 | 60.56 |
Ronan Tournier | 5 | 151 | 14.66 |