[ACM Press the 3rd Workshop - Pittsburgh, Pennsylvania (2010.03.14-2010.03.14)] Proceedings of the 3rd Workshop on General-Purpose Computation on Graphics Processing Units - GPGPU '10 - Accelerating SQL database operations on a GPU with CUDA
โ Scribed by Bakkum, Peter; Skadron, Kevin
- Book ID
- 120896624
- Publisher
- ACM Press
- Year
- 2010
- Weight
- 246 KB
- Category
- Article
- ISBN
- 1605589357
No coin nor oath required. For personal study only.
โฆ Synopsis
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.
๐ SIMILAR VOLUMES
With the development of Internet and cloud computing, multimedia data, such as images and videos, has become one of the most common data types being processed. As the scale of multimedia data being still increasing, it is vitally important to efficiently extract useful information from such a huge a