EUVIMEDEUVIMED entdecken
Crossref

Learned Offline Query Planning via Bayesian Optimization

Jeffrey Tao, Natalie Maus, Haydn Jones, Yimeng Zeng, Jacob R. Gardner, Ryan Marcus

Proceedings of the ACM on Management of Data · 17.06.2025 · 3 (3) · 1-29

DOI: 10.1145/3725316 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the ACM on Management of Data, online erschienen am 18.06.2025. Verfasst von Jeffrey Tao und 5 weiteren Autor:innen. Die Arbeit wurde bisher 7-mal zitiert (Crossref) und nennt 106 Literaturangaben. Gefördert von: NSF.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Analytics database workloads often contain queries that are executed repeatedly. Existing optimization techniques generally prioritize keeping optimization cost low, normally well below the time it takes to execute a single instance of a query. If a given query is going to be executed thousands of times, could it be worth investing significantly more optimization time? In contrast to traditional online query optimizers, we propose an offline query optimizer that searches a wide variety of plans and incorporates query execution as a primitive. Our offline query optimizer combines variational auto-encoders with Bayesian optimization to find optimized plans for a given query. We compare our technique to the optimal plans possible with PostgreSQL and recent RL-based systems over several datasets, and show that our technique finds faster query plans.

Förderung

  • NSF

Zitieren

APA

Tao, J., Maus, N., Jones, H., Zeng, Y., Gardner, J. R., & Marcus, R. (2025). Learned Offline Query Planning via Bayesian Optimization. Proceedings of the ACM on Management of Data, 3(3), 1-29. https://doi.org/10.1145/3725316

Vancouver

Tao J, Maus N, Jones H, Zeng Y, Gardner JR, Marcus R. Learned Offline Query Planning via Bayesian Optimization. Proceedings of the ACM on Management of Data. 2025;3(3):1-29. doi:10.1145/3725316

BibTeX
@article{Tao2025,
  author = {Tao, Jeffrey and Maus, Natalie and Jones, Haydn and Zeng, Yimeng and Gardner, Jacob R. and Marcus, Ryan},
  title = {Learned Offline Query Planning via Bayesian Optimization},
  journal = {Proceedings of the ACM on Management of Data},
  year = {2025},
  volume = {3},
  number = {3},
  pages = {1--29},
  doi = {10.1145/3725316}
}
Kostenlos starten →