Abstract:The explosion of data over the last decades puts significant strain on the computational capacity of the central processing unit (CPU), challenging online analytical processing (OLAP). While previous studies have shown the potential of using Field Programmable Gate Arrays (FPGAs) in database systems, integrating FPGA-based hardware acceleration with relational databases remains challenging because of the complex nature of relational database operations and the need for specialized FPGA programming skills. Additionally, there are significant challenges related to optimizing FPGA-based acceleration for specific database workloads, ensuring data consistency and reliability, and integrating FPGA-based hardware acceleration with existing database infrastructure. In this study, we proposed a novel end-to-end FPGA-based acceleration system that supports native SQL statements and storage engine. We defined a callback process to reload the database query logic and customize the scanning method for database queries. Through middleware process development, we optimized offloading efficiency on PCIe bus by scheduling data transmission and computation in a pipeline workflow. Additionally, we designed a novel five-stage FPGA microarchitecture module that achieves optimal clock frequency, further enhancing offloading efficiency. Results from systematic evaluations indicate that our solution allows a single FPGA card to perform as well as 8 CPU query processes, while reducing CPU load by 34%. Compared to using 4 CPU cores, our FPGA-based acceleration system reduces query latency by 1.7 times without increasing CPU load. Furthermore, our proposed solution achieves 2.1 times computation speedup for data filtering compared with the software baseline in a single core environment. Overall, our work presents a valuable end-to-end hardware acceleration system for OLAP databases.

SODA: Software Defined FPGA Based Accelerators for Big Data.

SAKMA: Specialized FPGA-Based Accelerator Architecture for Data-Intensive K-Means Algorithms

SODA: A Set of Fast Oblivious Algorithms in Distributed Secure Data Analytics.

AutoDSE: Enabling Software Programmers to Design Efficient FPGA Accelerators

A Domain-Specific Accelerator for Ultralow Latency Market Data Distribution System

A Ubiquitous Machine Learning Accelerator With Automatic Parallelization on FPGA

Integrating FPGA-based hardware acceleration with relational databases

FPGA Based Big Data Accelerator Design in Teaching Computer Architecture and Organization.

SASA: A Scalable and Automatic Stencil Acceleration Framework for Optimized Hybrid Spatial and Temporal Parallelism on HBM-based FPGAs

SECDA: Efficient Hardware/Software Co-Design of FPGA-based DNN Accelerators for Edge Inference

RapidPath: Accelerating Constrained Shortest Path Finding in Graphs on FPGA (Abstract Only).

Accelerating Graph Analytics by Co-Optimizing Storage and Access on an FPGA-HMC Platform

HeteroFlow: An Accelerator Programming Model with Decoupled Data Placement for Software-Defined FPGAs

TAPA-CS: Enabling Scalable Accelerator Design on Distributed HBM-FPGAs

Exploiting Stable Data Dependency in Stream Processing Acceleration on FPGAs

A Study of FPGA Virtualization and Accelerator Scheduling

Design and Application Space Exploration of a Domain-Specific Accelerator System

Calabash: Accelerating Attention Using a Systolic Array Chain on FPGAs

WooKong: A Ubiquitous Accelerator for Recommendation Algorithms with Custom Instruction Sets on FPGA

IO and data management for infrastructure as a service FPGA accelerators

SODA: Similar 3D Object Detection Accelerator at Network Edge for Autonomous Driving