Performance analysis of a parallel distributive join algorithm on the Intel paragon

In this paper, we analyze the performance of the parallel distributive join algorithm that we proposed previously (1996). We implemented the algorithm on an Intel Paragon machine and analyzed the effect of the number of processors and the join selectivity on the performance of the algorithm. We also compared the performance of the distributed join (DJ) algorithm with that of the hybrid-hash (HH) join algorithm. Our results show that the DJ performs comparably with the HH over the entire range of number of processors used and different join selectivities. A big advantage of the parallel DJ algorithm over the RH join algorithm is that it can easily support non-equijoin operations. The results can also be used to estimate the performance of file I/O intensive applications to be implemented on the Intel Paragon machine.