Deep unsupervised cardinality estimation

Z Yang, E Liang, A Kamsetty, C Wu, Y Duan… - arXiv preprint arXiv …, 2019 - arxiv.org
Cardinality estimation has long been grounded in statistical tools for density estimation. To
capture the rich multivariate distributions of relational tables, we propose the use of a new …

NeuroCard: one cardinality estimator for all tables

Z Yang, A Kamsetty, S Luan, E Liang, Y Duan… - arXiv preprint arXiv …, 2020 - arxiv.org
Query optimizers rely on accurate cardinality estimates to produce good execution plans.
Despite decades of research, existing cardinality estimators are inaccurate for complex …

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 …

Are we ready for learned cardinality estimation?

X Wang, C Qu, W Wu, J Wang, Q Zhou - arXiv preprint arXiv:2012.06743, 2020 - arxiv.org
Cardinality estimation is a fundamental but long unresolved problem in query optimization.
Recently, multiple papers from different research groups consistently report that learned …

Learning state representations for query optimization with deep reinforcement learning

J Ortiz, M Balazinska, J Gehrke, SS Keerthi - Proceedings of the Second …, 2018 - dl.acm.org
We explore the idea of using deep reinforcement learning for query optimization. The
approach is to build queries incrementally by encoding properties of subqueries using a …

A survey on advancing the dbms query optimizer: Cardinality estimation, cost model, and plan enumeration

H Lan, Z Bao, Y Peng - Data Science and Engineering, 2021 - Springer
Query optimizer is at the heart of the database systems. Cost-based optimizer studied in this
paper is adopted in almost all current database systems. A cost-based optimizer introduces …

Deep learning models for selectivity estimation of multi-attribute queries

S Hasan, S Thirumuruganathan, J Augustine… - Proceedings of the …, 2020 - dl.acm.org
Selectivity estimation-the problem of estimating the result size of queries-is a fundamental
problem in databases. Accurate estimation of query selectivity involving multiple correlated …

FLAT: fast, lightweight and accurate method for cardinality estimation

R Zhu, Z Wu, Y Han, K Zeng, A Pfadler, Z Qian… - arXiv preprint arXiv …, 2020 - arxiv.org
Query optimizers rely on accurate cardinality estimation (CardEst) to produce good
execution plans. The core problem of CardEst is how to model the rich joint distribution of …

FACE: A normalizing flow based cardinality estimator

J Wang, C Chai, J Liu, G Li - Proceedings of the VLDB Endowment, 2021 - dl.acm.org
Cardinality estimation is one of the most important problems in query optimization. Recently,
machine learning based techniques have been proposed to effectively estimate cardinality …

Learned cardinality estimation: A design space exploration and a comparative evaluation

J Sun, J Zhang, Z Sun, G Li, N Tang - Proceedings of the VLDB …, 2021 - dl.acm.org
Cardinality estimation is core to the query optimizers of DBMSs. Non-learned methods,
especially based on histograms and samplings, have been widely used in commercial and …