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.

FAERY: An FPGA-accelerated Embedding-based Retrieval System

An FPGA-Based Accelerator for Neighborhood-Based Collaborative Filtering Recommendation Algorithms

MicroRec: Efficient Recommendation Inference by Hardware and Data Structure Solutions

An Fpga-Cluster-Accelerated Match Engine For Content-Based Image Retrieval

DRAF: A Low-Power DRAM-Based Reconfigurable Acceleration Fabric

A High-Performance Accelerator for Real-Time Super-Resolution on Edge FPGAs

Fleche: an efficient GPU embedding cache for personalized recommendations

FlexSaaS

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

FPGA-Accelerated Erasure Coding Encoding in Ceph Based on an Efficient Layered Strategy

An Energy-Efficient Look-up Table Framework for Super Resolution on FPGA

Integrating FPGA-based hardware acceleration with relational databases

Progressively Optimized Bi-Granular Document Representation for Scalable Embedding Based Retrieval

Towards On-Board SAR Processing with FPGA Accelerators and a PCIe Interface

RF-RISA: A novel flexible random forest accelerator based on FPGA

FeReX: A Reconfigurable Design of Multi-bit Ferroelectric Compute-in-Memory for Nearest Neighbor Search

Accelerating Recommendation System Training by Leveraging Popular Choices

A Ubiquitous Machine Learning Accelerator With Automatic Parallelization on FPGA

Deep random forest with ferroelectric analog content addressable memory

Divide and Conquer: Towards Better Embedding-based Retrieval for Recommender Systems From a Multi-task Perspective