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.

Improving Data Partitioning Performance on Opencl-Based Fpgas

A study of data partitioning on OpenCL-based FPGAs

Multikernel Data Partitioning with Channel on OpenCL-Based FPGAs

A Performance Analysis Framework For Optimizing Opencl Applications On Fpgas

Integrating FPGA-based hardware acceleration with relational databases

From opencl to high-performance hardware on FPGAS

Improving the Performance of OpenCL-based FPGA Accelerator for Convolutional Neural Network

An OpenCL Framework for Distributed Apps on a Multidimensional Network of FPGAs

Exploring memory synchronization and performance considerations for FPGA platform using the high-abstracted OpenCL framework: Benchmarks development and analysis

Automatic multidimensional memory partitioning for FPGA-based accelerators (abstract only).

Understanding Data Partition for Applications on CPU-GPU Integrated Processors.

Improving Communication Patterns in Polyhedral Process Networks

Efficient Memory Partitioning for Parallel Data Access in FPGA via Data Reuse

Resource-Efficient Parallel Tree-Based Join Architecture on FPGA

FCM Clustering Approach Optimization Using Parallel High-Speed Intel FPGA Technology

An Efficient Dispatcher for Large Scale GraphProcessing on OpenCL-based FPGAs

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

Towards Automatic Transformation of Legacy Scientific Code into OpenCL for Optimal Performance on FPGAs

An Universal Hierarchical FPGA Partitioning Algorithm

Programming FPGAs Using OpenCL from Performance Model to Application Study.

High-Performance Genomic Analysis Heterogeneous System Using OpenCL