In-Depth Analysis of OLAP Query Performance on Heterogeneous Hardware
Open Access
- 26 July 2021
- journal article
- schwerpunktbeitrag
- Published by Springer Nature in Datenbank-Spektrum
- Vol. 21 (2) , 133-143
Abstract
Classical database systems are now facing the challenge of processing high-volume data feeds at unprecedented rates as efficiently as possible while also minimizing power consumption. Since CPU-only machines hit their limits, co-processors like GPUs and FPGAs are investigated by database system designers for their distinct capabilities. As a result, database systems over heterogeneous processing architectures are on the rise. In order to better understand their potentials and limitations, in-depth performance analyses are vital. This paper provides interesting performance data by benchmarking a portable operator set for column-based systems on CPU, GPU, and FPGA – all available processing devices within the same system. We consider TPC‑H query Q6 and additionally a hash join to profile the execution across the systems. We show that system memory access and/or buffer management remains the main bottleneck for device integration, and that architecture-specific execution engines and operators offer significantly higher performance.Keywords
Funding Information
- Otto-von-Guericke-Universität Magdeburg
This publication has 30 references indexed in Scilit:
- GPU-Accelerated Database Systems: Survey and Open Challenges2014
- The Design and Implementation of CoGaDB: A Column-oriented GPU-accelerated DBMSDatenbank-Spektrum, 2014
- Why it is time for a HyPEProceedings of the VLDB Endowment, 2013
- OmniDBProceedings of the VLDB Endowment, 2013
- Hardware-oblivious parallelism for in-memory column-storesProceedings of the VLDB Endowment, 2013
- Big Data Analytics on Modern Hardware Architectures: A Technology Survey2013
- FPGA vs. Multi-core CPUs vs. GPUs: Hands-On Experience with a Sorting Application2010
- Relational query coprocessing on graphics processorsACM Transactions on Database Systems, 2009
- MIL primitives for querying a fragmented worldThe VLDB Journal, 1999
- VPR: a new packing, placement and routing tool for FPGA research1997