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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Conference proceedings - IEEE International Conference on Systems, Man, and Cybernetics S. 3828 - 3833
Hauptverfasser: Dehdouh, Khaled, Bentayeb, Fadila, Boussaid, Omar, Kabachi, Nadia
Format: Tagungsbericht
Sprache:Englisch
Veröffentlicht: IEEE 01.10.2014
Schlagworte:
Accidents
Big data
Data models
Data warehouses
Distributed databases
Roads
ISSN:1062-922X
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
Zusammenfassung: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
DOI:10.1109/SMC.2014.6974527