The implementation techniques for hash-based parallel join algorithm against a novel generic parallel architecture is studied and a performance evaluation model is established
which models the overlap of operations of the three major system resources(CPU
disk and interconnection network).In light of this model
the performance of the parallel hybrid hash join algorithm(called PHHJR)and its variation which replicates the smaller relation(called PHHJR) are intensively analysed.Based on symmmetry bit vector filter concept
a new technique for accelerating join operations is proposed and compared with the traditional bit vector filter.The analysis shows that the symmetry bit vector filter can outperform traditional bit vector filter.