Title :
Acceleration of SQL Restrictions and Aggregations through FPGA-Based Dynamic Partial Reconfiguration
Author :
Dennl, Christopher ; Ziener, Daniel ; Teich, Jurgen
Author_Institution :
Hardware/Software Co.-Design, Univ. of Erlangen-Nuremberg, Nuremberg, Germany
Abstract :
SQL query processing on large database systems is recognized as one of the most important emerging disciplines of computing nowadays. However, current approaches do not provide a substantial coverage of typical query operators in hardware. In this paper, we provide an important step to higher operator coverage by proposing a) full dynamic data path generation for support also complex operators such as restrictions and aggregations. b) Also, an analysis of the computation times of a real database queries when running on a normal desktop computer is proposed to show that c) speedups ranging between 4 and 50 are obtainable by providing generative support also for the important restrict and aggregate operators using FPGAs.
Keywords :
SQL; computational complexity; field programmable gate arrays; query processing; relational databases; FPGA-based dynamic partial reconfiguration; SQL aggregation acceleration; SQL query processing; SQL restriction acceleration; complex operators; computation time analysis; database queries; database systems; full dynamic data path generation; operator coverage; relational database management systems; Acceleration; Benchmark testing; Databases; Field programmable gate arrays; Hardware; Remuneration; Software; Aggregation; Partial Reconfiguration; SQL processing;
Conference_Titel :
Field-Programmable Custom Computing Machines (FCCM), 2013 IEEE 21st Annual International Symposium on
Conference_Location :
Seattle, WA
Print_ISBN :
978-1-4673-6005-0
DOI :
10.1109/FCCM.2013.38