10076

A framework for cost based optimization of hybrid CPU/GPU query plans in database systems

Sebastian Bress, Ingolf Geist, Eike Schallehn, Maik Mory, Gunter Saake
Otto-von-Guericke University Magdeburg, Universitatsplatz 2, D-39106 Magdeburg
Control and Cybernetics, vol. 41, No. 4, 2012
@article{bress2012framework,

   title={A framework for cost based optimization of hybrid CPU/GPU query plans in database systems},

   author={Bre{ss}, Sebastian and Geist, Ingolf and Schallehn, Eike and Mory, Maik and Saake, Gunter},

   journal={Control and Cybernetics},

   volume={41},

   number={4},

   year={2012}

}

Download Download (PDF)   View View   Source Source   

670

views

Current database research identified the use of computational power of GPUs as a way to increase the performance of database systems. As GPU algorithms are not necessarily faster than their CPU counterparts, it is important to use the GPU only if it is beneficial for query processing. In a general database context, only few research projects address hybrid query processing, i.e., using a mix of CPU- and GPU-based processing to achieve optimal performance. In this paper, we extend our CPU/GPU scheduling framework to support hybrid query processing in database systems. We point out fundamental problems and propose an algorithm to create a hybrid query plan for a query using our scheduling framework. Additionally, we provide cost metrics, accounting for the possible overlapping of data transfers and computation on the GPU. Furthermore, we present algorithms to create hybrid query plans for query sequences and query trees.
VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)
A framework for cost based optimization of hybrid CPU/GPU query plans in database systems, 5.0 out of 5 based on 1 rating

* * *

* * *

Like us on Facebook

HGPU group

125 people like HGPU on Facebook

Follow us on Twitter

HGPU group

1181 peoples are following HGPU @twitter

* * *

Free GPU computing nodes at hgpu.org

Registered users can now run their OpenCL application at hgpu.org. We provide 1 minute of computer time per each run on two nodes with two AMD and one nVidia graphics processing units, correspondingly. There are no restrictions on the number of starts.

The platforms are

Node 1
  • GPU device 0: AMD/ATI Radeon HD 5870 2GB, 850MHz
  • GPU device 1: AMD/ATI Radeon HD 6970 2GB, 880MHz
  • CPU: AMD Phenom II X6 @ 2.8GHz 1055T
  • RAM: 12GB
  • OS: OpenSUSE 13.1
  • SDK: AMD APP SDK 2.9
Node 2
  • GPU device 0: AMD/ATI Radeon HD 7970 3GB, 1000MHz
  • GPU device 1: nVidia GeForce GTX 560 Ti 2GB, 822MHz
  • CPU: Intel Core i7-2600 @ 3.4GHz
  • RAM: 16GB
  • OS: OpenSUSE 12.2
  • SDK: nVidia CUDA Toolkit 6.0.1, AMD APP SDK 2.9

Completed OpenCL project should be uploaded via User dashboard (see instructions and example there), compilation and execution terminal output logs will be provided to the user.

The information send to hgpu.org will be treated according to our Privacy Policy

HGPU group © 2010-2014 hgpu.org

All rights belong to the respective authors

Contact us: