EUVIMEDEUVIMED entdecken
Crossref

OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning

Zhicheng Pan, Wenwen Sun, Yuanjia Zhang, Terence Purcell, Yu Dong, Chengcheng Yang, Rong Zhang, Xuan Zhou, Jianliang Xu

Proceedings of the VLDB Endowment · 01.03.2026 · 19 (7) · 1674-1687

DOI: 10.14778/3801059.3801077 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Proceedings of the VLDB Endowment, online erschienen am 14.07.2026. Verfasst von Zhicheng Pan und 8 weiteren Autor:innen. Die Arbeit wurde bisher 1-mal zitiert (Crossref) und nennt 78 Literaturangaben.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Query optimization (QO) remains a fundamental challenge in the database community. Despite decades of research, cost-based QO (CQO) is still susceptible to performance regressions due to inherent inaccuracies in cardinality estimation, cost modeling, and plan enumeration. To mitigate the instability, modern databases employ SQL plan management (SPM), which reuses curated plans and bypasses CQO. However, there exists a fundamental issue in SPM: how can we efficiently identify the optimal plans to manage? The existing approach falls short due to low generalizability and poor interpretability. Thus, we argue for revisiting this problem from a novel perspective, where we intervene in the sensitivity of CQO through well-designed cost scaling knobs. Nevertheless, this transformation poses three key challenges: (1) efficient search guidance, (2) comprehensive semantic utilization, and (3) cost-effective performance evaluation. To address these challenges, we propose OBELISK, an Offline Bayesian optimization-informed quEry pLannIng framework, with language model reaSoning over cost scaling Knobs. OBELISK is training-free and can efficiently find optimal query plan through a closed-loop process: a timeout-constrained Bayesian optimization technique to identify promising knob subspaces, thereby informing the search; a feedback-aware self-evolving reasoner to recommend knob configurations; and a lightweight evaluator with history-based admission gatekeeper to avoid redundant evaluations. Extensive experiments on well-established benchmarks demonstrate the effectiveness and superiority of our OBELISK.

Zitieren

APA

Pan, Z., Sun, W., Zhang, Y., Purcell, T., Dong, Y., Yang, C., Zhang, R., Zhou, X., & Xu, J. (2026). OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning. Proceedings of the VLDB Endowment, 19(7), 1674-1687. https://doi.org/10.14778/3801059.3801077

Vancouver

Pan Z, Sun W, Zhang Y, Purcell T, Dong Y, Yang C, et al. OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning. Proceedings of the VLDB Endowment. 2026;19(7):1674-1687. doi:10.14778/3801059.3801077

BibTeX
@article{Pan2026,
  author = {Pan, Zhicheng and Sun, Wenwen and Zhang, Yuanjia and Purcell, Terence and Dong, Yu and Yang, Chengcheng and Zhang, Rong and Zhou, Xuan and Xu, Jianliang},
  title = {OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning},
  journal = {Proceedings of the VLDB Endowment},
  year = {2026},
  volume = {19},
  number = {7},
  pages = {1674--1687},
  doi = {10.14778/3801059.3801077}
}
Kostenlos starten →