Title :
A new method for handling data skews in relational joins on graphics processing units
Author :
Zheng, Chao ; Deng, Qianni
Author_Institution :
Dept. of Comput. Sci., Shanghai Jiaotong Univ., Shanghai, China
Abstract :
We present a new method for handling data skews in the database operation, relation joins. Recently, Graphics Processing Units (GPU) has become popular among high performance computing research and is used to accelerate the execution of database operations. Various parallel algorithms are developed in the past years with emerging of multi -core processors. Coordinate Module Distribution (CMD) is originally designed for clusters, we have immigrated it onto GPU to improve the performance of relational joins. We find that using one GPU card, our method runs between hash join and sort-merge join, with hash join having the best performance. But our method runs close to hash joins and faster than sort-merge joins when processing relations with data skew.
Keywords :
computer graphic equipment; coprocessors; database management systems; coordinate module distribution; data skews handling; database operation; graphics processing units; high performance computing research; relational joins; Databases; Graphics processing unit; Coordinate Module Distribution; graphics processors; parallel processing; relational join;
Conference_Titel :
Progress in Informatics and Computing (PIC), 2010 IEEE International Conference on
Conference_Location :
Shanghai
Print_ISBN :
978-1-4244-6788-4
DOI :
10.1109/PIC.2010.5687861