loading
Papers

Research.Publish.Connect.

Paper

Paper Unlock

Authors: Lucas C. Scabora 1 ; Jaqueline J. Brito 1 ; Ricardo Rodrigues Ciferri 2 and Cristina Dutra de Aguiar Ciferri 1

Affiliations: 1 University of Sao Paulo at Sao Carlos, Brazil ; 2 Federal University of Sao Carlos, Brazil

ISBN: 978-989-758-187-8

Keyword(s): Data Warehousing, Physical Design, NoSQL, OLAP Query Processing, HBase, Star Schema Benchmark.

Related Ontology Subjects/Areas/Topics: Data Warehouses and OLAP ; Databases and Information Systems Integration ; Enterprise Information Systems ; Non-Relational Databases ; Performance Evaluation and Benchmarking

Abstract: Nowadays, data warehousing and online analytical processing (OLAP) are core technologies in business intelligence and therefore have drawn much interest by researchers in the last decade. However, these technologies have been mainly developed for relational database systems in centralized environments. In other words, these technologies have not been designed to be applied in scalable systems such as NoSQL databases. Adapting a data warehousing environment to NoSQL databases introduces several advantages, such as scalability and flexibility. This paper investigates three physical data warehouse designs to adapt the Star Schema Benchmark for its use in NoSQL databases. In particular, our main investigation refers to the OLAP query processing over column-oriented databases using the MapReduce framework. We analyze the impact of distributing attributes among column-families in HBase on the OLAP query performance. Our experiments showed how processing time of OLAP queries was impacted by a physical data warehouse design regarding the number of dimensions accessed and the data volume. We conclude that using distinct distributions of attributes among column-families can improve OLAP query performance in HBase and consequently make the benchmark more suitable for OLAP over NoSQL databases. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 18.210.22.132

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
Scabora, L.; Brito, J.; Ciferri, R. and Ciferri, C. (2016). Physical Data Warehouse Design on NoSQL Databases - OLAP Query Processing over HBase.In Proceedings of the 18th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-758-187-8, pages 111-118. DOI: 10.5220/0005815901110118

@conference{iceis16,
author={Lucas C. Scabora. and Jaqueline J. Brito. and Ricardo Rodrigues Ciferri. and Cristina Dutra de Aguiar Ciferri.},
title={Physical Data Warehouse Design on NoSQL Databases - OLAP Query Processing over HBase},
booktitle={Proceedings of the 18th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2016},
pages={111-118},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005815901110118},
isbn={978-989-758-187-8},
}

TY - CONF

JO - Proceedings of the 18th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Physical Data Warehouse Design on NoSQL Databases - OLAP Query Processing over HBase
SN - 978-989-758-187-8
AU - Scabora, L.
AU - Brito, J.
AU - Ciferri, R.
AU - Ciferri, C.
PY - 2016
SP - 111
EP - 118
DO - 10.5220/0005815901110118

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.