IDEAS home Printed from https://ideas.repec.org/a/igg/jdsst0/v12y2020i1p1-24.html
   My bibliography  Save this article

Big Data Warehouse: Building Columnar NoSQL OLAP Cubes

Author

Listed:
  • Khaled Dehdouh

    (Computer Engineering Department of Cherchell Military Academy, TIPAZA Algeria)

  • Omar Boussaid

    (ERIC Laboratory/ University of Lyon 2, Bron, France)

  • Fadila Bentayeb

    (ERIC Laboratory/ University of Lyon, Lyon 2, Bron, France)

Abstract

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.

Suggested Citation

  • Khaled Dehdouh & Omar Boussaid & Fadila Bentayeb, 2020. "Big Data Warehouse: Building Columnar NoSQL OLAP Cubes," International Journal of Decision Support System Technology (IJDSST), IGI Global, vol. 12(1), pages 1-24, January.
    • Handle: RePEc:igg:jdsst0:v:12:y:2020:i:1:p:1-24
    as

    Download full text from publisher

    File URL: http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJDSST.2020010101
    Download Restriction: no
    ---><---

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:igg:jdsst0:v:12:y:2020:i:1:p:1-24. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Journal Editor (email available below). General contact details of provider: https://www.igi-global.com .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.