Database Paper Browser

Back to papers

Conditional Selectivity for Statistics on Query Expressions

Summary: Frames SITs on query expressions with conditional selectivity, replacing view-matching to improve cardinality estimates. Proposes a DP algorithm to compute optimal conditional selectivities per query, enabling integration with minimal optimizer changes. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3528
Venue
SIGMOD
Year
2004
Pagerank
6.8768678e-05
Overall Rank
3,651 | 74.61%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank Citing Paper Year Venue Pagerank
934 Flexible Database Generators 2005 VLDB 0.00015227409
2,356 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.9620762e-05
2,364 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 8.9554751e-05
4,359 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 6.2569955e-05
5,509 Can Large Language Models Predict Data Correlations from Column Names? 2023 VLDB 5.4703368e-05
5,668 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 5.3806337e-05
5,815 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.3165295e-05
5,834 Efficient Detection of Empty-Result Queries 2006 VLDB 5.3103189e-05
7,786 Relational Support for Flexible Schema Scenarios 2008 VLDB 4.6513838e-05
9,938 Fast Approximate Computation of Statistics on Views 2006 SIGMOD 4.2482599e-05
9,945 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 4.2432653e-05
10,639 Cardinality Estimation for Having-Clauses 2025 VLDB 4.1945683e-05
12,308 Filtered Statistics 2009 SIGMOD 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 22 of 22 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.0040449103
7 Optimal Aggregation Algorithms for Middleware [Extended Abstract] 2001 PODS 0.0015496097
28 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00080435857
64 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00063612837
116 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00046148737
141 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00041786333
169 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00038895438
182 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036962631
211 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00033981214
269 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00029656549
307 Extensible Query Processing in Starburst 1989 SIGMOD 0.00028211308
326 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00027358981
372 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00025354779
512 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00021380733
529 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020828852
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
790 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001663283
842 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00016031973
996 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00014741524
1,335 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00012502131
1,695 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010882793
3,397 Statistics on Views 2003 VLDB 7.1437062e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
372 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00025354779
9,380 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 4.3461329e-05
684 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00018179769
3,397 Statistics on Views 2003 VLDB 7.1437062e-05
3,511 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.0254052e-05
1,981 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB 9.8687545e-05
3,954 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 6.5926838e-05
790 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.0001663283
8,213 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 4.557937e-05
2,356 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.9620762e-05