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
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

C
Cluster Computing-The Journal of Networks Software Tools and Applications
IF:
4.1
Papers:
5.1K
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
Cited Papers

Cited Papers

MapReduce and Parallel DBMSs: Friends or Foes?
err2010-01-01
err226
PREAI
errStonebraker, Michael; Abadi, Daniel; Dewitt, David J.; Madden, Sam; Paulson, Erik; Pavlo, Andrew; Rasin, Alexander
errShare
errSave
Single agent activity of U3-1402, a HER3-targeting antibody-drug conjugate, in HER3-overexpressing metastatic breast cancer: Updated results from a phase I/II trial
err2019-05-01
err0
errOAAI
errK. Yonemori; N. Masuda; S. Takahashi; T. Kogawa; T. Nakayama; Y. Yamamoto; M. Takahashi; T. Toyama; T. Saeki; H. Iwata
errShare
errSave
errShare
errSave
errShare
errSave
errShare
errSave
errShare
errSave
no more