Query processing and optimization in modern database systems
Leis V (2017)
Publication Type: Conference contribution
Publication year: 2017
Publisher: Gesellschaft fur Informatik (GI)
Book Volume: 265
Pages Range: 507-516
Conference Proceedings Title: Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)
Event location: Stuttgart
ISBN: 9783885796596
Abstract
Relational database management systems, which were designed decades ago, are still the dominant data processing platform. Since then, large DRAM capacities and servers with many cores have fundamentally changed the hardware landscape. As a consequence, traditional database systems cannot exploit modern hardware effectively anymore. This paper summarizes author’s thesis, which focuses on the challenges posed by modern hardware for transaction processing, query processing, and query optimization. In particular, we present a concurrent transaction processing system based on hardware transactional memory and show how to synchronize data structures efficiently. We further design a parallel query engine for many-core CPUs that supports the important relational operators including join, aggregation, window functions, etc. Finally, we dissect the query optimization process in the main memory setting and show the contribution of each query optimizer component to the overall query performance.
Authors with CRIS profile
Involved external institutions
How to cite
APA:
Leis, V. (2017). Query processing and optimization in modern database systems. In Bernhard Mitschang, Daniela Nicklas, Frank Leymann, Harald Schoning, Melanie Herschel, Jens Teubner, Theo Harder (Eds.), Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI) (pp. 507-516). Stuttgart, DE: Gesellschaft fur Informatik (GI).
MLA:
Leis, Viktor. "Query processing and optimization in modern database systems." Proceedings of the Datenbanksysteme fur Business, Technologie und Web, BTW 2017, 17. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme", DBIS - Database Systems for Business, Technology and Web, BTW 2017, 17th Symposium of the GI Department "Databases and Information Systems", DBIS, Stuttgart Ed. Bernhard Mitschang, Daniela Nicklas, Frank Leymann, Harald Schoning, Melanie Herschel, Jens Teubner, Theo Harder, Gesellschaft fur Informatik (GI), 2017. 507-516.
BibTeX: Download