Query Processing and Optimization in Modern Database Systems
Author:
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 e ectively 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 e ciently. 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.
- Citation
- BibTeX
Leis, V.,
(2017).
Query Processing and Optimization in Modern Database Systems.
In:
Mitschang, B., Nicklas, D., Leymann, F., Schöning, H., Herschel, M., Teubner, J., Härder, T., Kopp, O. & Wieland, M.
(Hrsg.),
Datenbanksysteme für Business, Technologie und Web (BTW 2017).
Gesellschaft für Informatik, Bonn.
(S. 507-518).
@inproceedings{mci/Leis2017,
author = {Leis, Viktor},
title = {Query Processing and Optimization in Modern Database Systems},
booktitle = {Datenbanksysteme für Business, Technologie und Web (BTW 2017)},
year = {2017},
editor = {Mitschang, Bernhard AND Nicklas, Daniela AND Leymann, Frank AND Schöning, Harald AND Herschel, Melanie AND Teubner, Jens AND Härder, Theo AND Kopp, Oliver AND Wieland, Matthias} ,
pages = { 507-518 },
publisher = {Gesellschaft für Informatik, Bonn},
address = {}
}
author = {Leis, Viktor},
title = {Query Processing and Optimization in Modern Database Systems},
booktitle = {Datenbanksysteme für Business, Technologie und Web (BTW 2017)},
year = {2017},
editor = {Mitschang, Bernhard AND Nicklas, Daniela AND Leymann, Frank AND Schöning, Harald AND Herschel, Melanie AND Teubner, Jens AND Härder, Theo AND Kopp, Oliver AND Wieland, Matthias} ,
pages = { 507-518 },
publisher = {Gesellschaft für Informatik, Bonn},
address = {}
}
Dateien | Groesse | Format | Anzeige | |
---|---|---|---|---|
paper32.pdf | 358.9Kb | View/ |
Haben Sie fehlerhafte Angaben entdeckt? Sagen Sie uns Bescheid: Send Feedback
More Info
ISBN: 978-3-88579-659-6
ISSN: 1617-5468
xmlui.MetaDataDisplay.field.date: 2017
Language:
(en)

Content Type: Text/Conference Paper