Energy-aware SQL query acceleration through FPGA-based dynamic partial reconfiguration

Andreas Becher, Florian Bauer, Daniel Ziener, Jürgen Teich

    Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

    24 Citations (Scopus)
    1 Downloads (Pure)

    Abstract

    In this paper, we propose an approach for energy-aware FPGA-based query acceleration for databases on embedded devices. After the analysis of an incoming query, a query-specific hardware accelerator is generated on-the-fly and loaded on the FPGA for subsequent query execution using partial dynamic reconfiguration. For each SQL query operation, a pre-synthesized partial bitstream implementation exists in a module library. This library includes modules for all major SQL operations like restrictions, aggregations, as well as more complex operations such as join and sort. The implementation of this flexible FPGA-based query accelerator approach on the embedded low-energy system-on-chip (SoC) platform Xilinx Zynq shows SQL query processing speeds comparable to high-end database servers, however, at a much lower energy consumption. Indeed, provided experimental results give evidence that the proposed architecture may reduce the amount of consumed energy to just 5% of the energy needed of an in-memory database system running on an x86-based server at equal throughput for respective benchmarks.

    Original languageEnglish
    Title of host publicationConference Digest - 24th International Conference on Field Programmable Logic and Applications, FPL 2014
    PublisherIEEE
    ISBN (Electronic)978-3-00-044645-0, 978-3-00-044909-3
    ISBN (Print)978-1-4799-3362-4
    DOIs
    Publication statusPublished - 16 Oct 2014
    Event24th International Conference on Field Programmable Logic and Applications, FPL 2014 - Munich, Germany
    Duration: 1 Sep 20145 Sep 2014
    Conference number: 24

    Conference

    Conference24th International Conference on Field Programmable Logic and Applications, FPL 2014
    Abbreviated titleFPL
    CountryGermany
    CityMunich
    Period1/09/145/09/14

    Fingerprint

    Dive into the research topics of 'Energy-aware SQL query acceleration through FPGA-based dynamic partial reconfiguration'. Together they form a unique fingerprint.

    Cite this