[176879]
Title: A Co-Design Approach for Accelerated SQL Query Processing via FPGA-based Data Filtering. <em>In Proceedings of the International Conference on Field-Programmable Technology (FPT)</em>
Written by: Andreas Becher, Daniel Ziener, Klaus Meyer-Wegener and J&uuml;rgen Teich
in: December (2015).
Volume: Number:
on pages:
Chapter:
Editor:
Publisher:
Series:
Address: Queenstown / New Zealand
Edition:
ISBN: 10.1109/FPT.2015.7393148
how published: 15-20 GRBZFTH15 FPT
Organization:
School:
Institution:
Type:
DOI:
URL:
ARXIVID:
PMID:

[BibTex]

Note: dziener, ESD

Abstract: In this paper, we present a novel architecture for high throughput database query processing. This architecture is based on an intelligent hardware/software co-design and consists of a highly configurable FPGA-based filter chain with arithmetic operation support and an alignment unit. It feeds the filtered data directly and in a cache-optimized way to an embedded processor which are responsible for joining tables and post processing. High throughput interfaces and parallelism of FPGAs are thus combined in order to provide reduced and cache-aligned data for optimized processor access. As a key component, we introduce a new highly configurable bloom filter cascade to relieve a processor of time-consuming hash-value computation and to significantly reduce the data for hash joins. It is shown that this unique approach may reduce the amount of data to be processed by the processors in typical data-warehouse applications by several orders of magnitude. The proposed architecture has been implemented on the embedded low-energy system-on-chip (SoC) platform Xilinx Zynq. Performance results for standard benchmarks show an up to 10~x higher throughput compared to a full featured x86-based processor at only a fraction of energy consumption.