DBScholar

Back to papers

Efficiently Approximating Selectivity Functions using Low Overhead Regression Models

Summary: Introduces incremental data generation with approximate labels to train low-overhead selectivity regression models. Extends to select-project-join with ranges and IN clauses, yielding 95th percentile error 10–100x lower than baselines. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h8fc86ba712ac2799
Venue
VLDB
Year
2020
Pagerank
7.5355264e-05
Overall Rank
3,208 | 78.44%
DOI
10.14778/3407790.3407820
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{dutt_vldb20,
        title = {{Efficiently Approximating Selectivity Functions using Low Overhead Regression Models}},
        author = {Dutt, Anshuman and Wang, Chi and Narasayya, Vivek and Chaudhuri, Surajit},
        journal = {PVLDB},
        series = {{VLDB} '20},
        volume = {13},
        number = {11},
        pages = {2215--2228},
        doi = {10.14778/3407790.3407820},
        url = {https://doi.org/10.14778/3407790.3407820},
        year = {2020}
}

Incoming Citations (Sorted by Pagerank)

Showing 24 of 24 citing papers.

Rank Citing Paper Year Venue Pagerank
1,065 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202293
1,515 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010418766
1,735 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7566604e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589842e-05
3,016 Data Acquisition for Improving Machine Learning Models 2021 VLDB 7.7492494e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4233639e-05
4,459 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5883555e-05
4,559 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5324275e-05
5,042 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2995365e-05
5,110 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2678118e-05
6,664 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 5.715134e-05
6,758 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 5.6877154e-05
6,796 dbET: Execution Time Distribution-based Plan Selection 2023 SIGMOD 5.6784895e-05
7,356 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB 5.5421826e-05
7,426 Learning to be a Statistician: Learned Estimator for Number of Distinct Values 2022 VLDB 5.5295692e-05
7,904 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4277674e-05
8,170 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.3827384e-05
8,638 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2965922e-05
9,134 Hit the Gym: Accelerating Query Execution to Efficiently Bootstrap Behavior Models for Self-Driving Database Management Systems 2024 VLDB 5.2223611e-05
9,723 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1329654e-05
9,983 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.1007226e-05
10,222 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.0560976e-05
10,300 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0407989e-05
11,024 Vodka: Rethink Benchmarking Philosophy in HTAP Systems 2026 VLDB 4.9769913e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 29 of 29 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.0023943337
57 On Random Sampling over Joins 1999 SIGMOD 0.00040095727
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
138 Join Synopses for Approximate Query Answering 1999 SIGMOD 0.00029618887
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022112534
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021166957
371 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019822444
373 Umbra: A Disk-Based System with In-Memory Performance 2020 CIDR 0.00019705706
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019446558
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019050182
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017955913
644 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015209065
688 Cardinality Estimation Done Right: Index-Based Join Sampling 2017 CIDR 0.00014749318
691 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014737455
749 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00014261044
930 Dynamic Sample Selection for Approximate Query Processing 2003 SIGMOD 0.00013009255
1,155 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011777046
1,432 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010676754
1,509 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010436933
1,543 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB 0.00010305662
1,678 Two-Level Sampling for Join Size Estimation 2017 SIGMOD 9.9056116e-05
1,892 CS2: A New Database Synopsis for Query Estimation 2013 SIGMOD 9.4150583e-05
2,174 A Black-Box Approach to Query Cardinality Estimation 2007 CIDR 8.9193253e-05
2,303 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB 8.6685874e-05
2,890 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.9010819e-05
3,134 Statistics on Views 2003 VLDB 7.6093829e-05
4,644 Efficient Join Synopsis Maintenance for Data Warehouse 2020 SIGMOD 6.4869417e-05
5,475 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.115573e-05
5,816 Exploiting Ordered Dictionaries to Efficiently Construct Histograms with Q-Error Guarantees in SAP HANA 2014 SIGMOD 5.9817821e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 955 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB
2 6,664 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD
3 1,543 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB
4 7,334 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD
5 1,058 Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions 2011 VLDB
6 3,361 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
7 9,342 Deep Query Optimization 2019 SIGMOD
8 286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
9 1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
10 691 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB