EUVIMEDEUVIMED entdecken
Systematische ÜbersichtOpen Access · CC BY 4.0

A Systematic Review of Modern Machine Learning in Query Optimization

Emmanouil Limnaios, Haridimos Kondylakis

ACM Computing Surveys · 31.01.2027 · 59 (1) · 1-20

DOI: 10.1145/3847509 ↗

Kurz gefasst

Systematische Übersicht in der Zeitschrift ACM Computing Surveys, online erschienen am 31.10.2026. Verfasst von Emmanouil Limnaios und 1 weiteren Autor:innen. Die Arbeit nennt 43 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Traditional query optimization struggles with modern, heterogeneous workloads. This PRISMA-guided survey examines 27 recent studies (2018–2025) on machine learning for query optimization, addressing two research questions: (RQ1) how learning-based approaches intervene across the classical optimization pipeline and what tradeoffs characterize each stage, and (RQ2) what limitations persist in generalization, benchmark standardization, and deployment readiness. We synthesize the literature across five intervention points: component-level estimation, learned enumeration, hint steering, end-to-end optimization, and emerging trends. Results show a paradigm shift from isolated predictors to integrated optimizers, while gaps in generalization and standardized evaluation persist. We conclude with a roadmap for robust and reproducible data-driven query optimization.

Zitieren

APA

Limnaios, E., & Kondylakis, H. (2027). A Systematic Review of Modern Machine Learning in Query Optimization. ACM Computing Surveys, 59(1), 1-20. https://doi.org/10.1145/3847509

Vancouver

Limnaios E, Kondylakis H. A Systematic Review of Modern Machine Learning in Query Optimization. ACM Computing Surveys. 2027;59(1):1-20. doi:10.1145/3847509

BibTeX
@article{Limnaios2027,
  author = {Limnaios, Emmanouil and Kondylakis, Haridimos},
  title = {A Systematic Review of Modern Machine Learning in Query Optimization},
  journal = {ACM Computing Surveys},
  year = {2027},
  volume = {59},
  number = {1},
  pages = {1--20},
  doi = {10.1145/3847509}
}
Kostenlos starten →