DBScholar

Back to papers

Towards a Robust Query Optimizer: A Principled and Practical Approach

Summary: Proposes robust query optimization by treating cardinality estimation probabilistically rather than exact. A Bayesian, sample-based estimator from precomputed samples captures correlations and enables performance/predictability tradeoffs, integrating with optimizers. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h7c5c5e38e12d9528
Venue
SIGMOD
Year
2005
Pagerank
0.00016221103
Overall Rank
568 | 96.20%
DOI
10.1145/1066157.1066172

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{babcock_sigmod05,
        title = {{Towards a Robust Query Optimizer: A Principled and Practical Approach}},
        author = {Babcock, Brian and Chaudhuri, Surajit},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066172},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066172},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 45 of 45 citing papers.

Rank Citing Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
142 Neo: A Learned Query Optimizer 2019 VLDB 0.00029114937
545 Plan-Structured Deep Neural Network Models for Query Performance Prediction 2019 VLDB 0.0001657599
838 Proactive Re-Optimization 2005 SIGMOD 0.00013528646
1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011289724
1,444 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010616242
1,609 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2019 SIGMOD 0.0001007196
1,803 SkinnerDB: Regret-Bounded Query Evaluation via Reinforcement Learning 2018 VLDB 9.5987229e-05
1,987 Plan Bouquets: Query Processing without Selectivity Estimation 2014 SIGMOD 9.2323722e-05
2,531 Multi-Objective Parametric Query Optimization 2015 VLDB 8.3140235e-05
2,696 Cost-based or Learning-based? A Hybrid Query Optimizer for Query Plan Selection 2022 VLDB 8.1068354e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
3,062 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6809918e-05
3,280 Large-Scale Collective Entity Matching 2011 VLDB 7.4495028e-05
3,406 Variance Aware Optimization of Parameterized Queries 2010 SIGMOD 7.3151509e-05
3,531 Identifying Robust Plans through Plan Diagram Reduction 2008 VLDB 7.2065332e-05
3,602 Looking Ahead Makes Query Plans Robust: Making the Initial Case with In-Memory Star Schema Data Warehouse Workloads 2017 VLDB 7.1572829e-05
4,502 Xplus: A SQL-Tuning-Aware Query Optimizer 2010 VLDB 6.5572851e-05
4,971 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3209003e-05
5,101 Leveraging Re-costing for Online Optimization of Parameterized Queries with Guarantees 2017 SIGMOD 6.2623728e-05
5,223 Exact Cardinality Query Optimization with Bounded Execution Cost 2019 SIGMOD 6.210331e-05
5,248 Approximation Schemes for Many-Objective Query Optimization 2014 SIGMOD 6.1980997e-05
5,324 CliffGuard: A Principled Framework for Finding Robust Database Designs 2015 SIGMOD 6.1645235e-05
5,490 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.0970166e-05
5,611 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.0498181e-05
5,670 Uncertainty Aware Query Execution Time Prediction 2014 VLDB 6.0266818e-05
5,999 On the Stability of Plan Costs and the Costs of Plan Stability 2010 VLDB 5.9034324e-05
6,128 Robustness Metrics for Relational Query Execution Plans 2018 VLDB 5.860258e-05
6,258 Warding off the Dangers of Data Corruption with Amulet 2011 SIGMOD 5.8155723e-05
6,812 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6597129e-05
6,816 ROX: Run-time Optimization of XQueries 2009 SIGMOD 5.6593309e-05
7,094 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.5863735e-05
8,064 Efficiently Computing Join Orders with Heuristic Search 2023 SIGMOD 5.3813708e-05
8,361 MONSOON: Multi-Step Optimization and Execution of Queries with Partially Obscured Predicates 2020 SIGMOD 5.3310744e-05
8,412 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 5.3211467e-05
8,550 ROME: Robust Query Optimization via Parallel Multi-Plan Execution 2024 SIGMOD 5.3030089e-05
8,989 Conformal Prediction for Verifiable Learned Query Optimization 2025 VLDB 5.2304457e-05
9,667 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 5.1278365e-05
9,767 PAR2QO: Parametric Penalty-Aware Robust Query Optimization 2025 VLDB 5.115551e-05
10,446 Coresets for Robust Query Optimization 2026 PODS 4.9605343e-05
10,753 RIB: Robust Learning-based Index Benefit Estimation 2026 SIGMOD 4.9605343e-05
11,347 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB 4.9605343e-05
12,251 Tighter Upper Bounds for Join Cardinality Estimates 2018 SIGMOD 4.9605343e-05
12,844 Large-Scale Uncertainty Management Systems: Learning and Exploiting Your Data (Tutorial Summary) 2009 SIGMOD 4.9605343e-05
13,019 Asking the Right Questions: Model-driven Optimization using Probes 2006 PODS 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023948467
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047654188
78 Sampling-Based Estimation of the Number of Distinct Values of an Attribute 1995 VLDB 0.00036725074
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036394222
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034691614
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033847446
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031291457
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029532435
171 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027063233
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
277 Optimal Histograms with Quality Guarantees 1998 VLDB 0.0002235043
287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022060616
346 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00020265363
701 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.0001464136
1,080 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012114187
1,124 Least Expected Cost Query Optimization: An Exercise in Utility 1999 PODS 0.00011898749
1,831 Least Expected Cost Query Optimization: What Can We Expect? 2002 PODS 9.5366955e-05
2,193 Probabilistic Optimization of Top N Queries 1999 VLDB 8.8828694e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 471 Robust Query Processing through Progressive Optimization 2004 SIGMOD
2 983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB
3 5,670 Uncertainty Aware Query Execution Time Prediction 2014 VLDB
4 1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB
5 1,261 Sampling-Based Query Re-Optimization 2016 SIGMOD
6 7,619 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD
7 676 Robust Estimation of Resource Consumption for SQL Queries using Statistical Techniques 2012 VLDB
8 11,347 Robust Plan Evaluation based on Approximate Probabilistic Machine Learning 2025 VLDB
9 10,446 Coresets for Robust Query Optimization 2026 PODS
10 6,128 Robustness Metrics for Relational Query Execution Plans 2018 VLDB