TY - JOUR
T1 - A parallel join algorithm for SIMD architectures
AU - Azadegan, Shiva
AU - Tripathi, Anand
PY - 1997/12
Y1 - 1997/12
N2 - This paper presents a parallel join algorithm for the data-parallel execution model used in SIMD architectures. This algorithm is hash-based, i.e., the tuples in a relation are divided into different buckets based on the hash value of the join attribute. In this algorithm the buckets are maintained in a distributed fashion, i.e., the tuples in a bucket are stored in an array of processors. The join operation is performed in parallel over all the buckets. The algorithm presented here has been implemented and evaluated on the Connection Machine (CM-2). We present here the results of the experimental evaluation of this algorithm for different values of design parameters and work-load. Using experimental evaluations of the CM communication primitives we develop analytical models for the performance evaluation of this algorithm and demonstrate the effectiveness of these models.
AB - This paper presents a parallel join algorithm for the data-parallel execution model used in SIMD architectures. This algorithm is hash-based, i.e., the tuples in a relation are divided into different buckets based on the hash value of the join attribute. In this algorithm the buckets are maintained in a distributed fashion, i.e., the tuples in a bucket are stored in an array of processors. The join operation is performed in parallel over all the buckets. The algorithm presented here has been implemented and evaluated on the Connection Machine (CM-2). We present here the results of the experimental evaluation of this algorithm for different values of design parameters and work-load. Using experimental evaluations of the CM communication primitives we develop analytical models for the performance evaluation of this algorithm and demonstrate the effectiveness of these models.
UR - http://www.scopus.com/inward/record.url?scp=0031538674&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=0031538674&partnerID=8YFLogxK
U2 - 10.1016/S0164-1212(97)00056-3
DO - 10.1016/S0164-1212(97)00056-3
M3 - Article
AN - SCOPUS:0031538674
SN - 0164-1212
VL - 39
SP - 265
EP - 280
JO - Journal of Systems and Software
JF - Journal of Systems and Software
IS - 3
ER -