A Study of Early Aggregation in Database Query Processing on FPGAs.
Publikation: Beitrag in Buch/Konferenzbericht/Sammelband/Gutachten › Beitrag in Konferenzband › Beigetragen › Begutachtung
Beitragende
Abstract
In database query processing, aggregation is an operator by which data with a common property is grouped and expressed in a summary form. Early aggregation is a popular method for improving the performance of the aggregation operator. In this paper, we study early aggregation algorithms in the context of query processing acceleration in database systems on FPGAs. The comparative study leads us to set-Associative caches with a low inter-reference recency set (LIRS) replacement policy. They show both great performance and modest implementation complexity compared to some of the most prominent early aggregation algorithms. We also present a novel application-specific architecture for implementing set-Associative caches. Benchmarks of our implementation show speedups of up to 3x for end-To-end aggregation compared to a state-of-The-Art FPGA-based query engine.
Details
Originalsprache | Englisch |
---|---|
Titel | FPGA 2023 - Proceedings of the 2023 ACM/SIGDA International Symposium on Field Programmable Gate Arrays |
Seiten | 55-65 |
Seitenumfang | 11 |
ISBN (elektronisch) | 9781450394178 |
Publikationsstatus | Veröffentlicht - 12 Feb. 2023 |
Peer-Review-Status | Ja |
Externe IDs
Scopus | 85148637560 |
---|---|
Mendeley | ab40a993-ba7b-3072-93d4-9a3c0758b8e9 |
ORCID | /0000-0001-8107-2775/work/142253562 |
Schlagworte
Forschungsprofillinien der TU Dresden
DFG-Fachsystematik nach Fachkollegium
Fächergruppen, Lehr- und Forschungsbereiche, Fachgebiete nach Destatis
ASJC Scopus Sachgebiete
Schlagwörter
- FPGA, aggregation, cache, database, early aggregation