9684

Accelerating SELECT WHERE and SELECT JOIN Queries on a GPU

Marcin Pietron, Pawel Russek, Kazimierz Wiatr
AGH University of Science and Technology, Academic Supercomputer Center Cyfronet, Krakow, Poland
Computer Science, Volume 14 (2), 2013

@article{pietron2013accelerating,

   title={ACCELERATING SELECT WHERE AND SELECT JOIN QUERIES ON A GPU},

   author={Pietron, Marcin and l Russek, Pawe and Wiatr, Kazimierz},

   journal={Computer Science},

   volume={14},

   pages={2},

   year={2013}

}

Download Download (PDF)   View View   Source Source   

646

views

This paper presents implementations of a few selected SQL operations using the CUDA programming framework on the GPU platform. Nowadays, the GPU’s parallel architectures give a high speed-up on certain problems. Therefore, the number of non-graphical problems that can be run and sped-up on the GPU still increases. Especially, there has been a lot of research in data mining on GPUs. In many cases it proves the advantage of offloading processing from the CPU to the GPU. At the beginning of our project we chose the set of SELECT WHERE and SELECT JOIN instructions as the most common operations used in databases. We parallelized these SQL operations using three main mechanisms in CUDA: thread group hierarchy, shared memories, and barrier synchronization. Our results show that the implemented highly parallel SELECT WHERE and SELECT JOIN operations on the GPU platform can be significantly faster than the sequential one in a database system run on the CPU.
No votes yet.
Please wait...

* * *

* * *

HGPU group © 2010-2017 hgpu.org

All rights belong to the respective authors

Contact us: