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

Celý popis

Uložené v:
Podrobná bibliografia
Vydané v:Conference proceedings - IEEE International Conference on Systems, Man, and Cybernetics s. 3828 - 3833
Hlavní autori: Dehdouh, Khaled, Bentayeb, Fadila, Boussaid, Omar, Kabachi, Nadia
Médium: Konferenčný príspevok..
Jazyk:English
Vydavateľské údaje: IEEE 01.10.2014
Predmet:
Accidents
Big data
Data models
Data warehouses
Distributed databases
Roads
ISSN:1062-922X
On-line prístup:Získať plný text
Tagy: Pridať tag
Žiadne tagy, Buďte prvý, kto otaguje tento záznam!
Popis
Shrnutí: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