Please use this identifier to cite or link to this item:
Title: In-depth analysis of OLAP query performance on heterogeneous hardware
Author(s): Broneske, DavidLook up in the Integrated Authority File of the German National Library
Drewes, Anna
Gurumurthy, Bala
Hajjar, Imad
Pionteck, ThiloLook up in the Integrated Authority File of the German National Library
Saake, GunterLook up in the Integrated Authority File of the German National Library
Issue Date: 2021
Type: Article
Language: English
URN: urn:nbn:de:gbv:ma9:1-1981185920-1031432
Subjects: Heterogeneous database systems
Overlay architecture
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.
Open Access: Open access publication
License: (CC BY 4.0) Creative Commons Attribution 4.0(CC BY 4.0) Creative Commons Attribution 4.0
Sponsor/Funder: Projekt DEAL 2021
Journal Title: Datenbank-Spektrum
Publisher: Springer
Publisher Place: Berlin
Volume: 21
Original Publication: 10.1007/s13222-021-00384-w
Page Start: 133
Page End: 143
Appears in Collections:Fakultät für Informatik (OA)

Files in This Item:
File Description SizeFormat 
Broneske et al._In-depth analysis_2021.pdfZweitveröffentlichung1.28 MBAdobe PDFThumbnail