Cardinality estimation in dbms: A comprehensive benchmark evaluation
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 …
plans for a query optimizer in DBMS. In the last decade, an increasing number of advanced …
Robust query driven cardinality estimation under changing workloads
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 …
lightweight, having low storage requirements, fast inference and training, and are easily …
Learned cardinality estimation: An in-depth study
Learned cardinality estimation (CE) has recently gained significant attention for replacing
long-studied traditional CE with machine learning, especially for deep learning. However …
long-studied traditional CE with machine learning, especially for deep learning. However …
Fauce: fast and accurate deep ensembles with uncertainty for cardinality estimation
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 …
estimators based on deep learning have been proposed to solve this problem and they have …
Check out the big brain on BRAD: simplifying cloud data processing with learned automated data meshes
The last decade of database research has led to the prevalence of specialized systems for
different workloads. Consequently, organizations often rely on a combination of specialized …
different workloads. Consequently, organizations often rely on a combination of specialized …
Leon: A new framework for ml-aided query optimization
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 …
With the prosperity of machine learning (ML), some recent works have shown the …
FactorJoin: a new cardinality estimation framework for join queries
Cardinality estimation is one of the most fundamental and challenging problems in query
optimization. Neither classical nor learning-based methods yield satisfactory performance …
optimization. Neither classical nor learning-based methods yield satisfactory performance …
ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads
For efficient query processing, DBMS query optimizers have for decades relied on delicate
cardinality estimation methods. In this work, we propose an Attention-based LEarned …
cardinality estimation methods. In this work, we propose an Attention-based LEarned …
Kepler: Robust learning for parametric query optimization
Most existing parametric query optimization (PQO) techniques rely on traditional query
optimizer cost models, which are often inaccurate and result in suboptimal query …
optimizer cost models, which are often inaccurate and result in suboptimal query …
A unified transferable model for ml-enhanced dbms
Recently, the database management system (DBMS) community has witnessed the power of
machine learning (ML) solutions for DBMS tasks. Despite their promising performance …
machine learning (ML) solutions for DBMS tasks. Despite their promising performance …