17536

Generating Custom Code for Efficient Query Execution on Heterogeneous Processors

Sebastian Bress, Bastian Kocher, Henning Funke, Tilmann Rabl, Volker Markl
TU Berlin
arXiv:1709.00700 [cs.DB], (3 Sep 2017)

@article{bress2017generating,

   title={Generating Custom Code for Efficient Query Execution on Heterogeneous Processors},

   author={Bress, Sebastian and Kocher, Bastian and Funke, Henning and Rabl, Tilmann and Markl, Volker},

   year={2017},

   month={sep},

   archivePrefix={"arXiv"},

   primaryClass={cs.DB}

}

Download Download (PDF)   View View   Source Source   

1827

views

Processor manufacturers build increasingly specialized processors to mitigate the effects of the power wall to deliver improved performance. Currently, database engines are manually optimized for each processor: A costly and error prone process. In this paper, we propose concepts to enable the database engine to perform per-processor optimization automatically. Our core idea is to create variants of generated code and to learn a fast variant for each processor. We create variants by modifying parallelization strategies, specializing data structures, and applying different code transformations. Our experimental results show that the performance of variants may diverge up to two orders of magnitude. Therefore, we need to generate custom code for each processor to achieve peak performance. We show that our approach finds a fast custom variant for multi-core CPUs, GPUs, and MICs.
No votes yet.
Please wait...

* * *

* * *

Featured events

2018
November
27-30
Hida Takayama, Japan

The Third International Workshop on GPU Computing and AI (GCA), 2018

2018
September
19-21
Nagoya University, Japan

The 5th International Conference on Power and Energy Systems Engineering (CPESE), 2018

2018
September
22-24
MediaCityUK, Salford Quays, Greater Manchester, England

The 10th International Conference on Information Management and Engineering (ICIME), 2018

2018
August
21-23
No. 1037, Luoyu Road, Hongshan District, Wuhan, China

The 4th International Conference on Control Science and Systems Engineering (ICCSSE), 2018

2018
October
29-31
Nanyang Executive Centre in Nanyang Technological University, Singapore

The 2018 International Conference on Cloud Computing and Internet of Things (CCIOT’18), 2018

HGPU group © 2010-2018 hgpu.org

All rights belong to the respective authors

Contact us: