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.

Hardware Thread Accelerating Method Based on CPU/FPGA Hybrid Architecture

Elliptic curve parallel computation based on hardware dynamic instruction schedule

FPGA-based hardware implementation of new edge-directed interpolation algorithm

A Hybrid Approach to Cache Management in Heterogeneous CPU-FPGA Platforms.

A Scalable Hybrid Architecture for High Performance Data-Parallel Applications

Design for HW/SW Co-Testing Based on FPGA

A partially reconfigurable architecture supporting hardware threads

Design of H.264/AVC Video Coder Based on Mixed Architecture

The Hardware Thread Interface Design and Adaptation on Dynamically Reconfigurable SoC

Hardware Implementation on FPGA for Task-Level Parallel Dataflow Execution Engine.

Software/Hardware Hybrid Network-On-Chip Simulation On Fpga

A hybrid ARM‐FPGA cluster for cryptographic algorithm acceleration

Memory Coherency Based CPU-Cache-FPGA Acceleration Architecture for Cloud Computing

Integrating FPGA-based hardware acceleration with relational databases

A Hardware/Software Method for Heterogeneous Cores Cooperating on Stream Architecture

Hardware Acceleration for the Banded Smith-Waterman Algorithm with the Cycled Systolic Array

Migration between Software and Hardware Task on Preemptive Multitasking CPU/FPGA Hybrid Architecture

A Hybrid Reconfigurable Architecture and Design Methods Aiming at Control-Intensive Kernels

A Scalable Multi-FPGA Platform for Hybrid Intelligent Optimization Algorithms

Heterothread: Hybrid Thread Level Parallelism on Heterogeneous Multicore Architectures.

Performance evaluation based on task division and scheduling in heterogeneous multi-core systems