Cardinality estimation in dbms: A comprehensive benchmark evaluation

Y Han, Z Wu, P Wu, R Zhu, J Yang, LW Tan… - arxiv preprint arxiv …, 2021‏ - arxiv.org
Cardinality estimation (CardEst) plays a significant role in generating high-quality query
plans for a query optimizer in DBMS. In the last decade, an increasing number of advanced …

Robust query driven cardinality estimation under changing workloads

P Negi, Z Wu, A Kipf, N Tatbul, R Marcus… - Proceedings of the …, 2023‏ - dl.acm.org
Query driven cardinality estimation models learn from a historical log of queries. They are
lightweight, having low storage requirements, fast inference and training, and are easily …

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 …

FactorJoin: a new cardinality estimation framework for join queries

Z Wu, P Negi, M Alizadeh, T Kraska… - Proceedings of the ACM …, 2023‏ - dl.acm.org
Cardinality estimation is one of the most fundamental and challenging problems in query
optimization. Neither classical nor learning-based methods yield satisfactory performance …

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 …

Fauce: fast and accurate deep ensembles with uncertainty for cardinality estimation

J Liu, W Dong, Q Zhou, D Li - Proceedings of the VLDB Endowment, 2021‏ - dl.acm.org
Cardinality estimation is a fundamental and critical problem in databases. Recently, many
estimators based on deep learning have been proposed to solve this problem and they have …

Spatial Query Optimization With Learning

X Zhang, A Eldawy - Proceedings of the VLDB Endowment, 2024‏ - dl.acm.org
Query optimization is a key component in database management systems (DBMS) and
distributed data processing platforms. Recent research in the database community …

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 …

Bayescard: Revitilizing bayesian frameworks for cardinality estimation

Z Wu, A Shaikhha, R Zhu, K Zeng, Y Han… - arxiv preprint arxiv …, 2020‏ - arxiv.org
Cardinality estimation (CardEst) is an essential component in query optimizers and a
fundamental problem in DBMS. A desired CardEst method should attain good algorithm …