Bao: Making learned query optimization practical

R Marcus, P Negi, H Mao, N Tatbul… - Proceedings of the …, 2021 - dl.acm.org
Recent efforts applying machine learning techniques to query optimization have shown few
practical gains due to substantive training overhead, inability to adapt to changes, and poor …

Neo: A learned query optimizer

R Marcus, P Negi, H Mao, C Zhang, M Alizadeh… - arxiv preprint arxiv …, 2019 - arxiv.org
Query optimization is one of the most challenging problems in database systems. Despite
the progress made over the past decades, query optimizers remain extremely complex …

Learned cardinalities: Estimating correlated joins with deep learning

A Kipf, T Kipf, B Radke, V Leis, P Boncz… - arxiv preprint arxiv …, 2018 - arxiv.org
We describe a new deep learning approach to cardinality estimation. MSCN is a multi-set
convolutional network, tailored to representing relational query plans, that employs set …

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 …

Optimizing subgraph queries by combining binary and worst-case optimal joins

A Mhedhbi, S Salihoglu - Proceedings of the VLDB Endowment, 2019 - dl.acm.org
We study the problem of optimizing subgraph queries using the new worst-case optimal join
plans. Worst-case optimal plans evaluate queries by matching one query vertex at a time …

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 …

Machine learning for computer systems and networking: A survey

ME Kanakis, R Khalili, L Wang - ACM Computing Surveys, 2022 - dl.acm.org
Machine learning (ML) has become the de-facto approach for various scientific domains
such as computer vision and natural language processing. Despite recent breakthroughs …

Robust Join Processing with Diamond Hardened Joins

A Birler, A Kemper, T Neumann - Proceedings of the VLDB Endowment, 2024 - dl.acm.org
Join ordering and join processing has a huge impact on query execution and can easily
affect the query response time by orders of magnitude. In particular, when joins are …

A unified deep model of learning from both data and queries for cardinality estimation

P Wu, G Cong - Proceedings of the 2021 International Conference on …, 2021 - dl.acm.org
Cardinality estimation is a fundamental problem in database systems. To capture the rich
joint data distributions of a relational table, most of the existing work either uses data as …