DBScholar

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
3590
Venue
SIGMOD
Year
2004
Pagerank
7.5368417e-05
Overall Rank
3,309 | 77.30%
DOI
10.1145/1007568.1007604

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{bruno_sigmod04,
        title = {{Conditional Selectivity for Statistics on Query Expressions}},
        author = {Bruno, Nicolas and Chaudhuri, Surajit},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007604},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007604},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Rank Citing Paper Year Venue Pagerank
938 Flexible Database Generators 2005 VLDB 0.00013089351
1,573 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010328171
1,936 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB 9.4557372e-05
3,545 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.3249967e-05
5,354 Can Large Language Models Predict Data Correlations from Column Names? 2023 VLDB 6.2515841e-05
5,365 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.2462467e-05
5,514 StatAdvisor: Recommending Statistical Views 2009 VLDB 6.1901666e-05
6,084 Efficient Detection of Empty-Result Queries 2006 VLDB 5.9830699e-05
8,109 Relational Support for Flexible Schema Scenarios 2008 VLDB 5.4843869e-05
10,090 Fast Approximate Computation of Statistics on Views 2006 SIGMOD 5.1557535e-05
10,097 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.1502319e-05
10,891 Cardinality Estimation for Having-Clauses 2025 VLDB 5.093636e-05
12,502 Filtered Statistics 2009 SIGMOD 5.093636e-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.0024089429
5 Optimal Aggregation Algorithms for Middleware [Extended Abstract] 2001 PODS 0.0010828372
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00048351457
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
101 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00034376651
118 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031922279
136 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00030123303
235 Fast Incremental Maintenance of Approximate Histograms 1997 VLDB 0.00023783792
267 Optimal Histograms with Quality Guarantees 1998 VLDB 0.00022798161
268 Extensible Query Processing in Starburst 1989 SIGMOD 0.00022788687
280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022454217
365 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00020041735
402 Fuzzy Queries in Multimedia Database Systems 1998 PODS 0.00019072958
448 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00018292618
559 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016528822
664 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015167825
692 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014919816
850 Approximating Multi-Dimensional Aggregate Range Queries Over Real Attributes 2000 SIGMOD 0.00013619394
1,166 ICICLES: Self-tuning Samples for Approximate Query Answering 2000 VLDB 0.00011850439
1,729 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.908788e-05
3,093 Statistics on Views 2003 VLDB 7.7664764e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
2 9,455 Small Selectivities Matter: Lifting the Burden of Empty Samples 2021 SIGMOD
3 3,093 Statistics on Views 2003 VLDB
4 566 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD
5 3,070 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB
6 1,536 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB
7 3,162 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB
8 664 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD
9 7,495 On the Calculation of Optimality Ranges for Relational Query Execution Plans 2018 SIGMOD
10 1,936 Consistently Estimating the Selectivity of Conjuncts of Predicates 2005 VLDB