Skip to Main content Skip to Navigation
Conference papers

Intentional Data Placement Policy for Improving OLAP Cube Construction on Hadoop Clusters

Billel Arres 1, 2 Nadia Kabachi 1, 2 Omar Boussaid 1, 2
2 SID
ERIC - Equipe de Recherche en Ingénierie des Connaissances
Abstract : In the recent past, we have witnessed dramatic increases in the volume of data literally in every area: business, science, and daily life to name a few. The Hadoop framework-an open source project based on the MapReduce paradigm-is a popular choice for big data analytics. However, the performance gained from Hadoop's features is currently limited by its default block placement policy, which does not take any data characteristics into account. Indeed, the efficiency of many operations can be improved by a careful data placement , including indexing, grouping, aggregation and joins. In our work we propose a data warehouse partitioning strategy to improve query gain performances. We investigate the performance gain for OLAP cube construction with and without data organization on a Hadoop cluster. And this, by varying the number of nodes and data warehouse size. Our experiments suggest that a good data placement on a cluster during the implementation of the data warehouse can significantly increase the OLAP cube construction and querying performances. In the next step, we will extend the experiments to study the effects of other configuration parameters on collocation data in the context of parallel data warehousing, such as partitions size, replication factor and OLAP query complexity. We plan also to study an intelligent system for warehouses data placement on clusters by integrating Multi-Agent System (MAS) and Intelligent Agents to the process.
Document type :
Conference papers
Complete list of metadata

Cited literature [10 references]  Display  Hide  Download

https://hal.inria.fr/hal-01169934
Contributor : David Gross-Amblard <>
Submitted on : Tuesday, June 30, 2015 - 3:04:37 PM
Last modification on : Wednesday, November 20, 2019 - 1:45:25 AM
Long-term archiving on: : Tuesday, April 25, 2017 - 8:25:55 PM

File

bda2014-actes-phd-2-pp21-23.pd...
Publisher files allowed on an open archive

Licence


Distributed under a Creative Commons Attribution - NonCommercial - NoDerivatives 4.0 International License

Identifiers

  • HAL Id : hal-01169934, version 1

Collections

Citation

Billel Arres, Nadia Kabachi, Omar Boussaid. Intentional Data Placement Policy for Improving OLAP Cube Construction on Hadoop Clusters. BDA 2014 : Gestion de données - principes, technologies et applications, Oct 2014, Autrans, France. ⟨hal-01169934⟩

Share

Metrics

Record views

245

Files downloads

438