Columnar NoSQL CUBE: Agregation operator for columnar NoSQL data warehouse

The emergence of large volumes of data imposed by the major players of the web requires new management models and new data storage architectures and treatment able to find information quickly in a large volume of data. The column-oriented NoSQL (Not Only SQL) database provide for big data the most s...

Full description

Saved in:
Bibliographic Details
Published in2014 IEEE International Conference on Systems, Man, and Cybernetics (SMC) pp. 3828 - 3833
Main Authors Dehdouh, Khaled, Bentayeb, Fadila, Boussaid, Omar, Kabachi, Nadia
Format Conference Proceeding
LanguageEnglish
Published IEEE 01.10.2014
Subjects
Accidents
Big data
Data models
Data warehouses
Distributed databases
Roads
Online AccessGet full text

Cover

More Information
Summary:The emergence of large volumes of data imposed by the major players of the web requires new management models and new data storage architectures and treatment able to find information quickly in a large volume of data. The column-oriented NoSQL (Not Only SQL) database provide for big data the most suitable model to the data warehouse and the structure of multidimensional data in OLAP cube form. However, in the absence of OLAP cube computation operators, we propose in this paper, a new aggregation operator called CN-CUBE (Columnar NoSQL CUBE), which allows data cubes to be computed from data warehouses stored in column-oriented NoSQL database management system. We implemented the CNCUBE operator using the SQL Phoenix interface of HBase DBMS and conducted experiments on a public data warehouse in a distributed environment produced using the Hadoop platform. Thus we have shown that our CN-CUBE operator has OLAP cubes computation times very suitable for NoSQL warehouses.
ISSN:1062-922X
2577-1655
DOI:10.1109/SMC.2014.6974527