Resource-Efficient Database Query Processing on FPGAs

被引:8
|
作者
Moghaddamfar, Mehdi [1 ,2 ]
Farber, Christian [3 ]
Lehner, Wolfgang [1 ]
May, Norman [2 ]
Kumar, Akash [1 ]
机构
[1] Tech Univ Dresden, Dresden, Germany
[2] SAP SE, Walldorf, Germany
[3] Intel Corp, Santa Clara, CA USA
来源
17TH INTERNATIONAL WORKSHOP ON DATA MANAGEMENT ON NEW HARDWARE, DAMON 2021 | 2021年
关键词
query processing; FPGA; sorting; aggregation; join; treap; morphing sort-merge; Chisel; OPAE;
D O I
10.1145/3465998.3466006
中图分类号
TP3 [计算技术、计算机技术];
学科分类号
0812 ;
摘要
FPGA technology has introduced new ways to accelerate database query processing, that often result in higher performance and energy efficiency. This is thanks to the unique architecture of FPGAs using reconfigurable resources to behave like an application-specific integrated circuit upon programming. The limited amount of these resources restricts the number and type of modules that an FPGA can simultaneously support. In this paper, we propose "morphing sort-merge": a set of run-time configurable FPGA modules that achieves resource efficiency by reusing the FPGA's resources to support different pipeline-breaking database operators, namely sort, aggregation, and equi-join. The proposed modules use dynamic optimization mechanisms that adapt the implementation to the distribution of data at run-time, thus resulting in higher performance. Our benchmarks show that morphing sort-merge reaches an average speedup of 5x compared to MonetDB.
引用
收藏
页数:8
相关论文
共 50 条
  • [1] ThunderGP: Resource-Efficient Graph Processing Framework on FPGAs with HLS
    Chen, Xinyu
    Cheng, Feng
    Tan, Hongshi
    Chen, Yao
    He, Bingsheng
    Wong, Weng-Fai
    Chen, Deming
    ACM TRANSACTIONS ON RECONFIGURABLE TECHNOLOGY AND SYSTEMS, 2022, 15 (04)
  • [2] A Resource-Efficient Communication Architecture for Chip Multiprocessors on FPGAs
    Xiaofang (Maggie) Wang
    Swetha Thota
    Journal of Computer Science and Technology, 2011, 26 : 434 - 447
  • [3] Implementation of PRINCE with resource-efficient structures based on FPGAs
    Li, Lang
    Feng, Jingya
    Liu, Botao
    Guo, Ying
    Li, Qiuping
    FRONTIERS OF INFORMATION TECHNOLOGY & ELECTRONIC ENGINEERING, 2021, 22 (11) : 1505 - 1516
  • [4] A Resource-Efficient Communication Architecture for Chip Multiprocessors on FPGAs
    Maggie
    Swetha Thota
    Journal of Computer Science & Technology, 2011, 26 (03) : 434 - 447
  • [5] A Resource-Efficient Communication Architecture for Chip Multiprocessors on FPGAs
    Wang, Xiaofang
    Thota, Swetha
    JOURNAL OF COMPUTER SCIENCE AND TECHNOLOGY, 2011, 26 (03) : 434 - 447
  • [6] A Study of Early Aggregation in Database Query Processing on FPGAs
    Moghaddamfar, Mehdi
    May, Norman
    Faerber, Christian
    Lehner, Wolfgang
    Kumar, Akash
    PROCEEDINGS OF THE 2023 ACM/SIGDA INTERNATIONAL SYMPOSIUM ON FIELD PROGRAMMABLE GATE ARRAYS, FPGA 2023, 2023, : 55 - 65
  • [7] Clockwork: Resource-Efficient Static Scheduling for Multi-Rate Image Processing Applications on FPGAs
    Huff, Dillon
    Dai, Steve
    Hanrahan, Pat
    2021 IEEE 29TH ANNUAL INTERNATIONAL SYMPOSIUM ON FIELD-PROGRAMMABLE CUSTOM COMPUTING MACHINES (FCCM 2021), 2021, : 186 - 194
  • [8] Resource-Efficient Dynamic Partial Reconfiguration on FPGAs for Space Instruments
    Doerflinger, Alexander
    Fiethe, Bjoern
    Michalik, Harald
    Fekete, Sandor P.
    Keldenich, Phillip
    Scheffer, Christian
    2017 NASA/ESA CONFERENCE ON ADAPTIVE HARDWARE AND SYSTEMS (AHS), 2017, : 24 - 31
  • [9] Efficient Query Processing for Web Search Engine with FPGAs
    Yan, Jing
    Zhao, Zhang-Xiang
    Xu, Ning-Yi
    Jin, Xi
    Zhang, Lin-Tao
    Hsu, Feng-Hsiung
    2012 IEEE 20TH ANNUAL INTERNATIONAL SYMPOSIUM ON FIELD-PROGRAMMABLE CUSTOM COMPUTING MACHINES (FCCM), 2012, : 97 - 100
  • [10] Resource-Efficient Logarithmic Number Scale Arithmetic for SPN Inference on FPGAs
    Weber, Lukas
    Sommer, Lukas
    Oppermann, Julian
    Molina, Alejandro
    Kersting, Kristian
    Koch, Andreas
    2019 INTERNATIONAL CONFERENCE ON FIELD-PROGRAMMABLE TECHNOLOGY (ICFPT 2019), 2019, : 251 - 254