arrow
Return

Scatter-Gather-Merge: An efficient star-join query processing algorithm for data-parallel frameworks

delete2010-11-06
delete15
PRE
AI
H
Hyuck Han
H
Hyungsoo Jung *
H
Hyeonsang Eom
H
Heon Y. Yeom
DOI:10.1007/s10586-010-0144-5delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
A data-parallel framework is very attractive for large-scale data processing since it enables such an application to easily process a huge amount of data on commodity machines. MapReduce, a popular data-parallel framework, is used in various fields such as web search, data mining and data warehouses; it is proven to be very practical for such a data-parallel application. A star-join query is a popular query in data warehouses that are a current target domain of data-parallel frameworks. This article proposes a new algorithm that efficiently processes star-join queries in data-parallel frameworks such as MapReduce and Dryad. Our star-join algorithm for general data-parallel frameworks is called Scatter-Gather-Merge, and it processes star-join queries in a constant number of computation steps, although the number of participating dimension tables increases. By adopting bloom filters, Scatter-Gather-Merge reduces a non-trivial amount of IO. We also show that Scatter-Gather-Merge can be easily applied to MapReduce. Our experimental results in both cluster and cloud environments show that Scatter-Gather-Merge outperforms existing approaches.
Keywords:
Data parallel framework
MapReduce
Hadoop
Star-join query

Journal

C
Cluster Computing-The Journal of Networks Software Tools and Applications
IF:
4.1
Papers:
5.0K
Citations:
7.5K

Organization

U
University of Sydney
Scholars:
6.5W
Papers: 6.2W
Citations: 90
S
seoul national university (snu)
Scholars:
7.2W
Papers: 6.6W
Citations: 86