Parallel processing of group by-before-join queries in cluster architecture

D. Taniar; J. W. Rahayu

doi:10.1109/CCGRID.2001.923191

Parallel processing of group by-before-join queries in cluster architecture

D. Taniar, J. W. Rahayu

Research output: Chapter in Book/Report/Conference proceeding › Conference Paper › Research › peer-review

4 Citations (Scopus)

Abstract

SQL queries in the real world are replete with group-by and join operations. This type of queries is often known as GroupBy-Join queries. In some GroupBy-Join queries, it is desirable to perform group-by before join in order to achieve better performance. This subset of GroupBy-Join queries is called GroupBy-Before-Join queries. In this paper, we present a study on the parallelization of GroupBy-Before-Join queries, particularly by exploiting cluster architectures. From our study, we have learned that, in parallel query optimization, processing group-by operations as early as possible is not always desirable. On many occasions, performing data distribution first, before group-by, offers performance advantages. In this study, we also describe our cluster-based scheme.

Original language	English
Title of host publication	Proceedings - 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001
Publisher	IEEE, Institute of Electrical and Electronics Engineers
Pages	178-185
Number of pages	8
ISBN (Print)	0769510108, 9780769510101
DOIs	https://doi.org/10.1109/CCGRID.2001.923191
Publication status	Published - 2001
Event	1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001 - Brisbane, QLD, Australia Duration: 15 May 2001 → 18 May 2001

Conference

Conference	1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001
Country/Territory	Australia
City	Brisbane, QLD
Period	15/05/01 → 18/05/01

Access to Document

10.1109/CCGRID.2001.923191

Cite this

@inproceedings{aca0ff09e1124da0bb3a9d2759a12f51,

title = "Parallel processing of group by-before-join queries in cluster architecture",

abstract = "SQL queries in the real world are replete with group-by and join operations. This type of queries is often known as GroupBy-Join queries. In some GroupBy-Join queries, it is desirable to perform group-by before join in order to achieve better performance. This subset of GroupBy-Join queries is called GroupBy-Before-Join queries. In this paper, we present a study on the parallelization of GroupBy-Before-Join queries, particularly by exploiting cluster architectures. From our study, we have learned that, in parallel query optimization, processing group-by operations as early as possible is not always desirable. On many occasions, performing data distribution first, before group-by, offers performance advantages. In this study, we also describe our cluster-based scheme.",

author = "D. Taniar and Rahayu, {J. W.}",

year = "2001",

doi = "10.1109/CCGRID.2001.923191",

language = "English",

isbn = "0769510108",

pages = "178--185",

booktitle = "Proceedings - 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001",

publisher = "IEEE, Institute of Electrical and Electronics Engineers",

address = "United States of America",

note = "1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001 ; Conference date: 15-05-2001 Through 18-05-2001",

}

Taniar, D & Rahayu, JW 2001, Parallel processing of group by-before-join queries in cluster architecture. in Proceedings - 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001., 923191, IEEE, Institute of Electrical and Electronics Engineers, pp. 178-185, 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001, Brisbane, QLD, Australia, 15/05/01. https://doi.org/10.1109/CCGRID.2001.923191

Parallel processing of group by-before-join queries in cluster architecture. / Taniar, D.; Rahayu, J. W.
Proceedings - 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001. IEEE, Institute of Electrical and Electronics Engineers, 2001. p. 178-185 923191.

Research output: Chapter in Book/Report/Conference proceeding › Conference Paper › Research › peer-review

TY - GEN

T1 - Parallel processing of group by-before-join queries in cluster architecture

AU - Taniar, D.

AU - Rahayu, J. W.

PY - 2001

Y1 - 2001

N2 - SQL queries in the real world are replete with group-by and join operations. This type of queries is often known as GroupBy-Join queries. In some GroupBy-Join queries, it is desirable to perform group-by before join in order to achieve better performance. This subset of GroupBy-Join queries is called GroupBy-Before-Join queries. In this paper, we present a study on the parallelization of GroupBy-Before-Join queries, particularly by exploiting cluster architectures. From our study, we have learned that, in parallel query optimization, processing group-by operations as early as possible is not always desirable. On many occasions, performing data distribution first, before group-by, offers performance advantages. In this study, we also describe our cluster-based scheme.

AB - SQL queries in the real world are replete with group-by and join operations. This type of queries is often known as GroupBy-Join queries. In some GroupBy-Join queries, it is desirable to perform group-by before join in order to achieve better performance. This subset of GroupBy-Join queries is called GroupBy-Before-Join queries. In this paper, we present a study on the parallelization of GroupBy-Before-Join queries, particularly by exploiting cluster architectures. From our study, we have learned that, in parallel query optimization, processing group-by operations as early as possible is not always desirable. On many occasions, performing data distribution first, before group-by, offers performance advantages. In this study, we also describe our cluster-based scheme.

UR - http://www.scopus.com/inward/record.url?scp=9544231556&partnerID=8YFLogxK

U2 - 10.1109/CCGRID.2001.923191

DO - 10.1109/CCGRID.2001.923191

M3 - Conference Paper

AN - SCOPUS:9544231556

SN - 0769510108

SN - 9780769510101

SP - 178

EP - 185

BT - Proceedings - 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001

PB - IEEE, Institute of Electrical and Electronics Engineers

T2 - 1st IEEE/ACM International Symposium on Cluster Computing and the Grid, CCGrid 2001

Y2 - 15 May 2001 through 18 May 2001

ER -

Parallel processing of group by-before-join queries in cluster architecture

Abstract

Conference

Access to Document

Other files and links

Cite this