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.
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;
Conference_Titel :
Advanced Information Networking and Applications, 2006. AINA 2006. 20th International Conference on
Conference_Location :
Vienna
Print_ISBN :
0-7695-2466-4
DOI :
10.1109/AINA.2006.256
