EUVIMEDEUVIMED entdecken
Crossref

Query Optimization in the Wild: Realities and Trends

Yuanyuan Tian

ACM SIGMOD Record · 20.07.2026 · 55 (2) · 51-57

DOI: 10.1145/3829088.3829095 ↗

Kurz gefasst

Fachartikel in der Zeitschrift ACM SIGMOD Record, online erschienen am 21.07.2026. Verfasst von Yuanyuan Tian. Die Arbeit nennt 71 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

For nearly half a century, the core design of query optimizers in industrial database systems has remained remarkably stable, relying on foundational principles from System R and the Volcano/Cascades framework. However, the rise of cloud computing, massive data volumes, and unified data platforms has exposed the limitations of this traditional, monolithic architecture. Taking an industrial perspective, this paper reviews the past and present of query optimization in production systems and identifies the challenges they face today. Then this paper highlights three key trends gaining momentum in the industry that promise to address these challenges. First, a tighter feedback loop between query optimization and query execution is being used to improve the robustness of query performance. Second, the scope of optimization is expanding from a single query to entire workloads through the convergence of query optimization and workload optimization. Third, and perhaps most transformatively, the industry is moving from monolithic designs to composable architectures that foster agility and cross-engine collaboration. Together, these trends chart a clear path toward a more dynamic, holistic, and adaptable future for query optimization in practice.

Zitieren

APA

Tian, Y. (2026). Query Optimization in the Wild: Realities and Trends. ACM SIGMOD Record, 55(2), 51-57. https://doi.org/10.1145/3829088.3829095

Vancouver

Tian Y. Query Optimization in the Wild: Realities and Trends. ACM SIGMOD Record. 2026;55(2):51-57. doi:10.1145/3829088.3829095

BibTeX
@article{Tian2026,
  author = {Tian, Yuanyuan},
  title = {Query Optimization in the Wild: Realities and Trends},
  journal = {ACM SIGMOD Record},
  year = {2026},
  volume = {55},
  number = {2},
  pages = {51--57},
  doi = {10.1145/3829088.3829095}
}
Kostenlos starten →