EUVIMEDEUVIMED entdecken
Crossref

AutoSteer: Learned Query Optimization for Any SQL Database

Christoph Anneser, Nesime Tatbul, David Cohen, Zhenggang Xu, Prithviraj Pandian, Nikolay Laptev, Ryan Marcus

Proceedings of the VLDB Endowment · 2023-08 · 16 (12) · 3515-3527

DOI: 10.14778/3611540.3611544 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, 2023-08. Verfasst von Christoph Anneser und 6 weiteren Autor:innen. Die Arbeit wurde bisher 51-mal zitiert (Crossref) und nennt 51 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This paper presents AutoSteer, a learning-based solution that automatically drives query optimization in any SQL database that exposes tunable optimizer knobs. AutoSteer builds on the Bandit optimizer (Bao) and extends it with new capabilities (e.g., automated hint-set discovery) to minimize integration effort and facilitate usability in both monolithic and disaggregated SQL systems. We successfully applied AutoSteer on PostgreSQL, PrestoDB, Spark-SQL, MySQL, and DuckDB - five popular open-source database engines with diverse query optimizers. We then conducted a detailed experimental evaluation with public benchmarks (JOB, Stackoverflow, TPC-DS) and a production workload from Meta's PrestoDB deployments. Our evaluation shows that AutoSteer can not only outperform these engines' native query optimizers (e.g., up to 40% improvements for PrestoDB) but can also match the performance of Bao-for-PostgreSQL with reduced human supervision and increased adaptivity, as it replaces Bao's static, expert-picked hint-sets with those that are automatically discovered. We also provide an open-source implementation of AutoSteer together with a visual tool for interactive use by query optimization experts.

Zitieren

APA

Anneser, C., Tatbul, N., Cohen, D., Xu, Z., Pandian, P., Laptev, N., & Marcus, R. (2023). AutoSteer: Learned Query Optimization for Any SQL Database. Proceedings of the VLDB Endowment, 16(12), 3515-3527. https://doi.org/10.14778/3611540.3611544

Vancouver

Anneser C, Tatbul N, Cohen D, Xu Z, Pandian P, Laptev N, et al. AutoSteer: Learned Query Optimization for Any SQL Database. Proceedings of the VLDB Endowment. 2023;16(12):3515-3527. doi:10.14778/3611540.3611544

BibTeX
@article{Anneser2023,
  author = {Anneser, Christoph and Tatbul, Nesime and Cohen, David and Xu, Zhenggang and Pandian, Prithviraj and Laptev, Nikolay and Marcus, Ryan},
  title = {AutoSteer: Learned Query Optimization for Any SQL Database},
  journal = {Proceedings of the VLDB Endowment},
  year = {2023},
  volume = {16},
  number = {12},
  pages = {3515--3527},
  doi = {10.14778/3611540.3611544}
}
Kostenlos starten →