Auflistung Datenbank Spektrum 21(2) - Juli 2021 nach Autor:in "Broneske, David"
1 - 2 von 2
Treffer pro Seite
Sortieroptionen
- ZeitschriftenartikelIn-Depth Analysis of OLAP Query Performance on Heterogeneous Hardware(Datenbank-Spektrum: Vol. 21, No. 2, 2021) Broneske, David; Drewes, Anna; Gurumurthy, Bala; Hajjar, Imad; Pionteck, Thilo; Saake, GunterClassical 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.
- ZeitschriftenartikelSQLValidator – An Online Student Playground to Learn SQL(Datenbank-Spektrum: Vol. 21, No. 2, 2021) Obionwu, Victor; Broneske, David; Hawlitschek, Anja; Köppen, Veit; Saake, GunterThe Structured Query Language (SQL) is the most widely-used language in database-related courses. As a consequence, writing SQL queries is a fundamental expectation from any university course in database systems. Practical exercises are an essential part of the SQL learning experience. These exercises enable participants to practice and acquire experience in the use of the different SQL concepts, such as clauses, predicates, and expressions. To this end, we developed the tool SQLValidator as a web-based interactive tool for learning and practicing SQL. Apart from using it for teaching, we also use it to administer questionnaires and practice tests to improve students’ learning experience. In this paper, we present the architecture and functions of SQLValidator. In order to assess the usefulness of SQLValidator, we monitor the performance of our students based on the semester activities and examinations. Our evaluation shows that SQLValidator is an effective tool that improves a student’s learning experience when learning SQL.