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
3529
Venue
SIGMOD
Year
2004
Pagerank
6.8712579e-05
Overall Rank
3,656 | 74.60%
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
933 Flexible Database Generators 2005 VLDB 0.00015220613
2,359 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.967267e-05
2,364 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 8.955077e-05
4,352 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 6.2542257e-05
5,506 Can Large Language Models Predict Data Correlations from Column Names? 2023 VLDB 5.4711611e-05
5,676 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 5.3768269e-05
5,824 StatAdvisor: Recommending Statistical Views 2009 VLDB 5.311975e-05
5,846 Efficient Detection of Empty-Result Queries 2006 VLDB 5.3052255e-05
7,786 Relational Support for Flexible Schema Scenarios 2008 VLDB 4.6469243e-05
9,937 Fast Approximate Computation of Statistics on Views 2006 SIGMOD 4.2441896e-05
9,947 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 4.2391999e-05
10,647 Cardinality Estimation for Having-Clauses 2025 VLDB 4.1905499e-05
12,316 Filtered Statistics 2009 SIGMOD 4.1905499e-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.0040465394
8 Optimal Aggregation Algorithms for Middleware [Extended Abstract] 2001 PODS 0.0015436578
28 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00080571183
63 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00063595699
114 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00046317654
141 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00041819767
171 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00038843975
181 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00036970794
212 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00033997204
270 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00029648047
309 Extensible Query Processing in Starburst 1989 SIGMOD 0.00028195213
326 Optimal Histograms with Quality Guarantees 1998 VLDB 0.0002737538
373 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00025354685
512 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00021385343
527 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00020862475
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
786 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00016624743
838 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00016024923
995 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00014745185
1,331 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00012553948
1,691 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 0.00010890775
3,398 Statistics on Views 2003 VLDB 7.1381433e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
373 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00025354685
9,387 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD 4.341968e-05
3,398 Statistics on Views 2003 VLDB 7.1381433e-05
680 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00018193263
3,516 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.018912e-05
1,978 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB 9.8764627e-05
786 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00016624743
3,955 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 6.5895015e-05
8,193 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD 4.5575291e-05
2,359 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 8.967267e-05