Title :
A parallel sort-balance mutual range-join algorithm on hypercube computers
Author :
Wong, Richard ; Topor, Rodney ; Shen, Hong
Author_Institution :
Sch. of Comput. & Inf. Technol., Griffith Univ., Nathan, Qld., Australia
Abstract :
This paper presents an efficient parallel algorithm for computing the mutual range-join of N sets of numbers on shared-nothing hypercube computers. The algorithm iteratively joins each set to the mutual range-join of the preceding sets. Each join is performed on all processors of the hypercube in parallel. The algorithm uses a global sorting method to distribute the elements of the first set evenly across all processors in increasing order, a new data balancing technique to distribute the elements of subsequent sets to match the intermediate set at each processor and to compensate for join skew, and a new efficient local range-join procedure. We analyse the performance of this algorithm and demonstrate that it improves on the best previously published algorithm for this problem when the join selectivity factor is small. The method can also be applied to similar problems such as band-join and equi-join
Keywords :
database theory; hypercube networks; parallel algorithms; query processing; relational algebra; relational databases; software performance evaluation; sorting; band-join; data balancing; equi-join; global sorting method; hypercube computers; join selectivity factor; join skew; mutual range-join algorithm; parallel sort-balance algorithm; performance; query evaluation; relational database; Application software; Calculus; Computer architecture; Concurrent computing; Costs; Distributed computing; Hypercubes; Iterative algorithms; Relational databases; Spatial databases;
Conference_Titel :
Algorithms and Architectures for Parallel Processing, 1997. ICAPP 97., 1997 3rd International Conference on
Conference_Location :
Melbourne, Vic.
Print_ISBN :
0-7803-4229-1
DOI :
10.1109/ICAPP.1997.651538