Bao: Making learned query optimization practical
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 …
practical gains due to substantive training overhead, inability to adapt to changes, and poor …
Neo: A learned query optimizer
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 …
the progress made over the past decades, query optimizers remain extremely complex …
Learned cardinalities: Estimating correlated joins with deep learning
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 …
convolutional network, tailored to representing relational query plans, that employs set …
Deep unsupervised cardinality estimation
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 …
capture the rich multivariate distributions of relational tables, we propose the use of a new …
NeuroCard: one cardinality estimator for all tables
Query optimizers rely on accurate cardinality estimates to produce good execution plans.
Despite decades of research, existing cardinality estimators are inaccurate for complex …
Despite decades of research, existing cardinality estimators are inaccurate for complex …
Optimizing subgraph queries by combining binary and worst-case optimal joins
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 …
plans. Worst-case optimal plans evaluate queries by matching one query vertex at a time …
FLAT: fast, lightweight and accurate method for cardinality estimation
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 …
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
Machine learning (ML) has become the de-facto approach for various scientific domains
such as computer vision and natural language processing. Despite recent breakthroughs …
such as computer vision and natural language processing. Despite recent breakthroughs …
Robust Join Processing with Diamond Hardened Joins
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 …
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
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 …
joint data distributions of a relational table, most of the existing work either uses data as …