Big Data Warehouse: Building Columnar NoSQL OLAP Cubes

In the Big Data warehouse context, a column-oriented NoSQL database system is considered as the storage model which is highly adapted to data warehouses and online analysis. Indeed, the use of NoSQL models allows data scalability easily and the columnar store is suitable for storing and managing mas...

Full description

Saved in:
Bibliographic Details
Published in:International journal of decision support system technology Vol. 12; no. 1; pp. 1 - 24
Main Authors: Dehdouh, Khaled, Boussaid, Omar, Bentayeb, Fadila
Format: Journal Article
Language:English
Published: Hershey IGI Global 01.01.2020
Subjects:
Big Data
Computer Science
Cubes
Data base management systems
Data warehouses
Database management systems
Information storage and retrieval
Online analytical processing
Storage
Warehouse stores
France
Algeria
ISSN:1941-6296, 1941-630X
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:In the Big Data warehouse context, a column-oriented NoSQL database system is considered as the storage model which is highly adapted to data warehouses and online analysis. Indeed, the use of NoSQL models allows data scalability easily and the columnar store is suitable for storing and managing massive data, especially for decisional queries. However, the column-oriented NoSQL DBMS do not offer online analysis operators (OLAP). To build OLAP cubes corresponding to the analysis contexts, the most common way is to integrate other software such as HIVE or Kylin which has a CUBE operator to build data cubes. By using that, the cube is built according to the row-oriented approach and does not allow to fully obtain the benefits of a column-oriented approach. In this article, the focus is to define a cube operator called MC-CUBE (MapReduce Columnar CUBE), which allows building columnar NoSQL cubes according to the columnar approach by taking into account the non-relational and distributed aspects when data warehouses are stored.
Bibliography:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:1941-6296
1941-630X
DOI:10.4018/IJDSST.2020010101