A parallel sort-balance mutual range-join algorithm on hypercube computers

Richard Wong, Rodney Topor, Hong Shen

Research output: Contribution to journalArticlepeer-review

2 Citations (Scopus)


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 previous result for this problem when the join selectivity factor is small and the restriction of SIMD operation is lifted. The method can also be applied to similar problems such as band-join and equi-join.

Original languageEnglish
Pages (from-to)209-215
Number of pages7
JournalMicroprocessors and Microsystems
Issue number3-4
Publication statusPublished - 28 Aug 1998
Externally publishedYes


  • Hypercube
  • Parallel algorithm
  • Query evaluation
  • Range-join
  • Relational database


Dive into the research topics of 'A parallel sort-balance mutual range-join algorithm on hypercube computers'. Together they form a unique fingerprint.

Cite this