• DocumentCode
    610947
  • 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
  • fYear
    2013
  • fDate
    28-30 April 2013
  • Firstpage
    25
  • Lastpage
    28
  • 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;
  • fLanguage
    English
  • Publisher
    ieee
  • 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
  • Type

    conf

  • DOI
    10.1109/FCCM.2013.38
  • Filename
    6545990