arrow
Return

Resource-Efficient Parallel Tree-Based Join Architecture on FPGA

delete2019-01-01
delete8
PRE
AI
H
Huan Zhang
B
Bei Zhao
W
Weijun Li
Z
Zhenguo Ma
F
Feng Yu *
DOI:10.1109/TCSII.2018.2836920delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
The offloading and acceleration of database operations on field programmable gate arrays (FPGAs) have been extensively studied for a long time. Architectures of join, a key database operation, have been proposed and optimized on FPGAs. However, these join architectures are either resource-intensive or have low-throughput. In this brief, we focus on the equi-join and propose a resource-efficient join architecture based on a tree model. The architecture needs two phases: the build phase, in which a binary tree is built by using the first database table, and the probe phase, in which the architecture searches the tree to find matching solutions through a second database table. In addition, we propose a parallel implementation for this architecture to improve its performance. The proposed design was implemented on a Xilinx FPGA, and the results were compared with the most recent works on hardware join. The experimental results demonstrate that for a range of parallelism and dataset sizes, our design achieves a data throughput of 8-100 million tuples per second, which is compatible with the bus rate, and performs well in balancing resource utilization and data throughput.
Keywords:
FPGA
database
hardware acceleration
equi-join
AI Summary

AI Summary

Key information extracted from the uploaded paper, including a brief overview, abstract, background, key highlights, visual analysis, and future outlook.

Journal

I
IEEE Transactions on Circuits and Systems and Express Briefs
IF:
4.9
Papers:
8.8K
Citations:
2.5W

Organization

H
Hangzhou Dianzi University
Scholars:
1.3W
Papers: 9.6K
Citations: 7.5K
Z
zhejiang university
Scholars:
17.5W
Papers: 12.0W
Citations: 152