DBScholar

Back to papers

Robust Query Driven Cardinality Estimation under Changing Workloads

Summary: Robustifies query-driven cardinality estimation under workload/data drift using feature masking and join-consistent sampling bitmaps. Enables strong cross-workload and update generalization, improving runtimes while avoiding the catastrophic regressions of standard models. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
h941eeed0456ae961
Venue
VLDB
Year
2023
Pagerank
7.463682e-05
Overall Rank
3,269 | 78.09%
DOI
10.14778/3583140.3583164
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{negi_vldb23,
        title = {{Robust Query Driven Cardinality Estimation under Changing Workloads}},
        author = {Negi, Parimarjan and Wu, Ziniu and Kipf, Andreas and Tatbul, Nesime and Marcus, Ryan and Madden, Sam and Kraska, Tim and Alizadeh, Mohammad},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {6},
        pages = {1520--1533},
        doi = {10.14778/3583140.3583164},
        url = {https://doi.org/10.14778/3583140.3583164},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 38 of 38 citing papers.

Rank Citing Paper Year Venue Pagerank
3,328 Auto-WLM: Machine Learning Enhanced Workload Management in Amazon Redshift 2023 SIGMOD 7.4094448e-05
4,315 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6545412e-05
4,833 Stage: Query Execution Time Prediction in Amazon Redshift 2024 SIGMOD 6.3834856e-05
5,457 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1058928e-05
5,854 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9520525e-05
5,911 Yannakakis+: Practical Acyclic Query Evaluation with Theoretical Guarantees 2025 SIGMOD 5.9338021e-05
6,121 Breaking It Down: An In-depth Study of Index Advisors 2024 VLDB 5.863893e-05
7,238 Refactoring Index Tuning Process with Benefit Estimation 2024 VLDB 5.5624225e-05
7,363 Blueprinting the Cloud: Unifying and Automatically Optimizing Cloud Data Infrastructures with BRAD 2024 VLDB 5.5279826e-05
7,666 Disclosure-Compliant Query Answering 2024 SIGMOD 5.4565877e-05
7,997 The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions 2024 VLDB 5.3938336e-05
8,657 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2790784e-05
8,908 Spatial Query Optimization With Learning 2024 VLDB 5.2369727e-05
8,989 Conformal Prediction for Verifiable Learned Query Optimization 2025 VLDB 5.2304457e-05
9,011 Improving DBMS Scheduling Decisions with Accurate Performance Prediction on Concurrent Queries 2025 VLDB 5.2238303e-05
9,031 ByteCard: Enhancing ByteDance’s Data Warehouse with Learned Cardinality Estimation 2024 SIGMOD 5.219814e-05
9,143 Check Out the Big Brain on BRAD: Simplifying Cloud Data Processing with Learned Automated Data Meshes 2023 VLDB 5.2074327e-05
9,256 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB 5.1860131e-05
9,583 Athena: An Effective Learning-based Framework for Query Optimizer Performance Improvement 2025 SIGMOD 5.140977e-05
9,655 Db2une: Tuning Under Pressure via Deep Learning 2024 VLDB 5.1307018e-05
9,662 Low Rank Learning for Offline Query Optimization 2025 SIGMOD 5.1283524e-05
9,753 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1159926e-05
9,995 Graph Transformers for Query Plan Representation: Potentials and Challenges 2025 VLDB 5.0845476e-05
10,094 SPACE: Cardinality Estimation for Path Queries Using Cardinality-Aware Sequence-based Learning 2025 SIGMOD 5.068372e-05
10,221 Path-centric Cardinality Estimation for Subgraph Matching 2025 VLDB 5.0460607e-05
10,257 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.039379e-05
10,323 This is Going to Sound Crazy, But What If We Used Large Language Models to Boost Automatic Database Tuning Algorithms By Leveraging Prior History? We Will Find Better Configurations More Quickly Than Retraining From Scratch! 2026 SIGMOD 5.0241309e-05
10,327 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0241309e-05
10,358 WoW: A Window-to-Window Incremental Index for Range-Filtering Approximate Nearest Neighbor Search 2026 SIGMOD 5.0156513e-05
10,370 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0010514e-05
10,392 E-LQO: A Comprehensive Energy Evaluation Framework for Learned Query Optimization 2027 SIGMOD 4.9605343e-05
10,490 Are Learned DBMS Components Robust to Workload Drift?: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,561 NeurBench: A Benchmark Suite for Learned Database Components with Drift Modeling: [Experiments & Analysis] 2026 SIGMOD 4.9605343e-05
10,620 Approximate Query Processing under Updates 2026 SIGMOD 4.9605343e-05
10,764 Practical Parameterized Query Optimization via Efficient Plan Reuse and List-wise Ranking 2026 SIGMOD 4.9605343e-05
10,873 BaCon: Efficient Batch Processing of Counting Queries 2026 VLDB 4.9605343e-05
10,994 TATA: An Efficient Framework for Task Transfer in Query Plan Representation 2026 VLDB 4.9605343e-05
11,501 LEAP: A Low-cost Spark SQL Query Optimizer using Pairwise Comparison 2025 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 30 of 30 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022060616
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
337 The Aqua Approximate Query Answering System 1999 SIGMOD 0.00020593498
355 Bao: Making Learned Query Optimization Practical 2021 SIGMOD 0.00020146245
381 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019497061
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
690 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014703258
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
1,061 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB 0.00012207625
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011759683
1,444 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010616242
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
1,740 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7289523e-05
2,009 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.1813272e-05
2,310 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB 8.6493038e-05
2,348 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.5910072e-05
2,584 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2435322e-05
2,852 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9201312e-05
3,060 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.6828463e-05
3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5145409e-05
3,282 Estimating Cardinalities with Deep Sketches 2019 SIGMOD 7.4491295e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
3,995 Simplicity Done Right for Join Ordering 2021 CIDR 6.8530469e-05
4,459 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5757572e-05
4,549 One Model to Rule them All: Towards Zero-Shot Learning for Databases 2022 CIDR 6.5328866e-05
Previous Page 1 / 1 Next

Semantically Similar Papers