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.

Beyond Traditional Microprocessors for Geoscience High-Performance Computing Applications

Chapter Four - Data Flow Computing in Geoscience Applications.

Accelerating Seismic Computations Using Customized Number Representations on FPGAs

Accelerating Seismic Computations on FPGAs – from the Perspective of Number Representations

FPGA‐based HPC accelerators: An evaluation on performance and energy efficiency

Eliminating The Memory Bottleneck: An Fpga-Based Solution For 3d Reverse Time Migration

A MapReduce Computing Framework Based on GPU Cluster.

Scaling Reverse Time Migration Performance Through Reconfigurable Dataflow Engines

Exploring the acceleration of the Met Office NERC Cloud model using FPGAs

Efficient Execution of Microscopy Image Analysis on CPU, GPU, and MIC Equipped Cluster Systems

FPGA-Based Near-Memory Acceleration of Modern Data-Intensive Applications

Performance Portable Graphics Processing Unit Acceleration of a High-Order Finite Element Multiphysics Application

Scientific Computing Using Consumer Video-Gaming Hardware Devices

Integrating FPGA-based hardware acceleration with relational databases

Solving the Global Atmospheric Equations Through Heterogeneous Reconfigurable Platforms.

Designing a High Performance Parallel Personal Cluster

Translating Novel HPC Techniques into Efficient Geoscience Solutions

Accelerating the 3D Elastic Wave Forward Modeling on GPU and MIC

High Performance Computing Via a GPU

Direct N-body application on low-power and energy-efficient parallel architectures

Application Experiences on a GPU-Accelerated Arm-based HPC Testbed