DocumentCode
1687322
Title
Parallel "GroupBy-Before-Join" Query Processing for High Performance Parallel/Distributed Database Systems
Author
Taniar, David ; Rahayu, Wenny
Author_Institution
Monash Univ., Clayton, Vic.
Volume
1
fYear
2006
Firstpage
693
Lastpage
700
Abstract
GroupBy-Join queries in SQL are queries involving the group by clause joining several tables. In this paper, we describe three parallelization techniques for GroupBby-Join queries, particularly the queries where the group-by clause can be performed before the join operation. We subsequently call this query "GroupBy-Before-Join" queries. Performance evaluation of the three parallel processing methods is also carried out
Keywords
SQL; parallel databases; performance evaluation; query processing; GroupBy-Before-Join query processing; SQL; distributed database system; parallel database system; parallel processing method; parallelization technique; performance evaluation; structured query language; Aggregates; Database systems; Decision making; Parallel algorithms; Parallel processing; Performance gain; Query processing;
fLanguage
English
Publisher
ieee
Conference_Titel
Advanced Information Networking and Applications, 2006. AINA 2006. 20th International Conference on
Conference_Location
Vienna
ISSN
1550-445X
Print_ISBN
0-7695-2466-4
Type
conf
DOI
10.1109/AINA.2006.256
Filename
1620269
Link To Document