Accelerating SQL Database Operations on a GPU with CUDA
Department of Computer Science, University of Virginia, Charlottesville, VA 22904
GPGPU ’10 Proceedings of the 3rd Workshop on General-Purpose Computation on Graphics Processing Units
@conference{bakkum2010accelerating,
title={Accelerating SQL database operations on a GPU with CUDA},
author={Bakkum, P. and Skadron, K.},
booktitle={Proceedings of the 3rd Workshop on General-Purpose Computation on Graphics Processing Units},
pages={94–103},
year={2010},
organization={ACM}
}
Prior work has shown dramatic acceleration for various database operations on GPUs, but only using primitives that are not part of conventional database languages such as SQL. This paper implements a subset of the SQLite command processor directly on the GPU. This dramatically reduces the effort required to achieve GPU acceleration by avoiding the need for database programmers to use new programming languages such as CUDA or modify their programs to use non-SQL libraries. This paper focuses on accelerating SELECT queries and describes the considerations in an efficient GPU implementation of the SQLite command processor. Results on an NVIDIA Tesla C1060 achieve speedups of 20-70X depending on the size of the result set.
December 18, 2010 by hgpu
