DBScholar

Back to papers

Adaptive Selectivity Estimation Using Query Feedback

Summary: Adaptive selectivity estimation via query feedback using curve-fitting to approximate the real value distribution. No extra database access for statistics; continuous adaptation through queries and updates; accuracy comparable to traditional statistics-based methods. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
haeeb2bc83128ce50
Venue
SIGMOD
Year
1994
Pagerank
0.00023726296
Overall Rank
234 | 98.44%
DOI
10.1145/191839.191874

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{chen_sigmod94,
        title = {{Adaptive Selectivity Estimation Using Query Feedback}},
        author = {Chen, Chungmin Melvin and Roussopoulos, Nick},
        series = {{SIGMOD} '94},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/191839.191874},
        url = {https://dl.acm.org/doi/10.1145/191839.191874},
        year = {1994}
}

Incoming Citations (Sorted by Pagerank)

Showing 40 of 40 citing papers.

Rank Citing Paper Year Venue Pagerank
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047654188
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029532435
254 The History of Histograms (abridged) 2003 VLDB 0.00022999992
285 Balancing Histogram Optimality and Practicality for Query Result Size Estimation 1995 SIGMOD 0.00022143946
372 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019768921
374 Approximate Query Processing: Taming the TeraBytes! A Tutorial 2001 VLDB 0.00019698889
401 Query Caching and Optimization in Distributed Mediator Systems 1996 SIGMOD 0.00019080589
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
450 Histogram-Based Approximation of Set-Valued Query Answers 1999 VLDB 0.0001806593
457 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017915659
568 Towards a Robust Query Optimizer: A Principled and Practical Approach 2005 SIGMOD 0.00016221103
690 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014703258
971 Recovering Information from Summary Data 1997 VLDB 0.00012748313
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,080 Multi-dimensional Selectivity Estimation Using Compressed Histogram Information 1999 SIGMOD 0.00012114187
1,117 Adaptive Range Filters for Cold Data: Avoiding Trips to Siberia 2013 VLDB 0.00011928965
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011759683
1,282 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011197535
1,754 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB 9.7111856e-05
2,154 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9382906e-05
2,174 A Black-Box Approach to Query Cardinality Estimation 2007 CIDR 8.9067128e-05
2,176 Selectivity Estimation in Spatial Databases 1999 SIGMOD 8.9031141e-05
2,310 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB 8.6493038e-05
3,001 Adapting to Source Properties in Processing Data Integration Queries 2004 SIGMOD 7.7492907e-05
3,062 Towards a Hands-Free Query Optimizer through Deep Learning 2019 CIDR 7.6809918e-05
3,361 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3621595e-05
4,502 Xplus: A SQL-Tuning-Aware Query Optimizer 2010 VLDB 6.5572851e-05
4,916 A Characterization of the Sensitivity of Query Optimization to Storage Access Cost Parameters 2003 SIGMOD 6.3450917e-05
4,956 A Comparison of Selectivity Estimators for Range Queries on Metric Attributes 1999 SIGMOD 6.326039e-05
5,490 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.0970166e-05
6,243 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8220831e-05
6,725 Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis 2023 VLDB 5.6826988e-05
7,094 Plan Stitch: Harnessing the Best of Many Plans 2018 VLDB 5.5863735e-05
7,432 POLAR: Adaptive and Non-invasive Join Order Selection via Plans of Least Resistance 2024 VLDB 5.5133928e-05
7,654 Consistent Histograms In The Presence of Distinct Value Counts 2009 VLDB 5.4588598e-05
8,067 Adaptive Optimizations of Recursive Queries in Teradata 2012 SIGMOD 5.3810658e-05
8,883 Adaptive Index Structures 2002 VLDB 5.2436823e-05
9,753 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1159926e-05
10,327 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0241309e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 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
36 Accurate Estimation Of The Number Of Tuples Satisfying A Condition 1984 SIGMOD 0.00047770864
58 Statistical Estimators for Relational Algebra Expressions 1988 PODS 0.00039922419
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
119 Equi-Depth Histograms For Estimating Selectivity Factors For Multi-Dimensional Queries 1988 SIGMOD 0.00031291457
346 Sequential Sampling Procedures For Query Size Estimation 1992 SIGMOD 0.00020265363
425 Estimating Block Transfers and Join Sizes 1983 SIGMOD 0.00018437618
806 Universality of Serial Histograms 1993 VLDB 0.00013752086
960 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB 0.00012825107
1,187 An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment 1993 SIGMOD 0.00011580993
1,189 An Analytic Approach to Statistical Databases 1983 VLDB 0.00011569335
1,648 A Model of Data Distribution Based on Texture Analysis 1985 SIGMOD 9.9739132e-05
3,339 Database Evaluation Using Multiple Regression Techniques 1984 SIGMOD 7.3895792e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 3,371 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
2 4,806 Adaptive Database Buffer Allocation Using Query Feedback 1993 VLDB
3 10,014 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD
4 171 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD
5 1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
6 960 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB
7 3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB
8 287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
9 1,754 Combining Histograms and Parametric Curve Fitting for Feedback-Driven Query Result-Size Estimation 1999 VLDB
10 79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD