Lero: A learning-to-rank query optimizer

R Zhu, W Chen, B Ding, X Chen, A Pfadler… - arxiv preprint arxiv …, 2023 - arxiv.org
A recent line of works apply machine learning techniques to assist or rebuild cost-based
query optimizers in DBMS. While exhibiting superiority in some benchmarks, their …

Leon: A new framework for ml-aided query optimization

X Chen, H Chen, Z Liang, S Liu, J Wang… - Proceedings of the …, 2023 - dl.acm.org
Query optimization has long been a fundamental yet challenging topic in the database field.
With the prosperity of machine learning (ML), some recent works have shown the …

Loger: A learned optimizer towards generating efficient and robust query execution plans

T Chen, J Gao, H Chen, Y Tu - Proceedings of the VLDB Endowment, 2023 - dl.acm.org
Query optimization based on deep reinforcement learning (DRL) has become a hot research
topic recently. Despite the achieved promising progress, DRL optimizers still face great …

Fastgres: Making learned query optimizer hinting effective

L Woltmann, J Thiessat, C Hartmann… - Proceedings of the …, 2023 - dl.acm.org
The traditional and well-established cost-based query optimizer approach enumerates
different execution plans for each query, assesses each plan with costs, and selects the plan …

Kepler: robust learning for parametric query optimization

L Doshi, V Zhuang, G Jain, R Marcus… - Proceedings of the …, 2023 - dl.acm.org
Most existing parametric query optimization (PQO) techniques rely on traditional query
optimizer cost models, which are often inaccurate and result in suboptimal query …

Pilotscope: Steering databases with machine learning drivers

R Zhu, L Weng, W Wei, D Wu, J Peng, Y Wang… - Proceedings of the …, 2024 - dl.acm.org
Learned databases, or AI4DB techniques, have rapidly developed in the last decade.
Deploying machine learning (ML) and AI4DB algorithms into actual databases is the gold …

Stage: Query execution time prediction in amazon redshift

Z Wu, R Marcus, Z Liu, P Negi, V Nathan… - Companion of the 2024 …, 2024 - dl.acm.org
Query performance (eg, execution time) prediction is a critical component of modern
DBMSes. As a pioneering cloud data warehouse, Amazon Redshift relies on an accurate …

Bladedisc: Optimizing dynamic shape machine learning workloads via compiler approach

Z Zheng, Z Pan, D Wang, K Zhu, W Zhao… - Proceedings of the …, 2023 - dl.acm.org
Compiler optimization plays an increasingly important role to boost the performance of
machine learning models for data processing and management. With increasingly complex …

NeurDB: an AI-powered autonomous data system

BC Ooi, S Cai, G Chen, Y Shen, KL Tan, Y Wu… - Science China …, 2024 - Springer
In the wake of rapid advancements in artificial intelligence (AI), we stand on the brink of a
transformative leap in data systems. The imminent fusion of AI and DB (AI× DB) promises a …

Base: Bridging the gap between cost and latency for query optimization

X Chen, Z Wang, S Liu, Y Li, K Zeng, B Ding… - Proceedings of the …, 2023 - dl.acm.org
Some recent works have shown the advantages of reinforcement learning (RL) based
learned query optimizers. These works often use the cost (ie, the estimation of cost model) or …