DBScholar

Back to papers

Selectivity Estimation for Range Predicates using Lightweight Models

Summary: Framing selectivity for multi-dimensional range predicates as regression and evaluating lightweight neural nets and tree ensembles; naive use underperforms simple baselines. It introduces regression-label transformation and feature engineering, delivering fast, accurate estimates across diverse datasets for optimizers. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h9ca47ddcdbacab57
Venue
VLDB
Year
2019
Pagerank
0.00014703258
Overall Rank
690 | 95.38%
DOI
10.14778/3329772.3329780
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{dutt_vldb19,
        title = {{Selectivity Estimation for Range Predicates using Lightweight Models}},
        author = {Dutt, Anshuman and Wang, Chi and Nazi, Azade and Kandula, Srikanth and Narasayya, Vivek and Chaudhuri, Surajit},
        journal = {PVLDB},
        series = {{VLDB} '19},
        volume = {12},
        number = {9},
        pages = {1044--1057},
        doi = {10.14778/3329772.3329780},
        url = {https://doi.org/10.14778/3329772.3329780},
        year = {2019}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 83 citing papers.

Rank Citing Paper Year Venue Pagerank
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
405 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019020138
427 ALEX: An Updatable Adaptive Learned Index 2020 SIGMOD 0.00018429918
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012181459
1,132 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011873466
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011759683
1,175 Balsa: Learning a Query Optimizer Without Expert Demonstrations 2022 SIGMOD 0.00011630532
1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010148362
1,740 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7289523e-05
2,009 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.1813272e-05
2,190 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8848923e-05
2,348 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.5910072e-05
2,523 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3316032e-05
2,584 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2435322e-05
2,772 Instance-Optimized Data Layouts for Cloud Analytics Workloads 2021 SIGMOD 8.0148928e-05
2,828 Cost Models for Big Data Query Processing: Learning, Retrofitting, and Our Findings 2020 SIGMOD 7.9476509e-05
2,852 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9201312e-05
2,913 AI Meets Database: AI4DB and DB4AI 2021 SIGMOD 7.855786e-05
3,060 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.6828463e-05
3,105 A Learned Sketch for Subgraph Counting 2021 SIGMOD 7.6278115e-05
3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5145409e-05
3,269 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.463682e-05
3,486 HUNTER: An Online Cloud Database Hybrid Tuning System for Personalized Requirements 2022 SIGMOD 7.2428834e-05
3,555 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.1877332e-05
3,740 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0398782e-05
3,959 MB2: Decomposed Behavior Modeling for Self-Driving Database Management Systems 2021 SIGMOD 6.8804723e-05
4,247 LEON: A New Framework for ML-Aided Query Optimization 2023 VLDB 6.6920059e-05
4,315 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6545412e-05
4,459 Warper: Efficiently Adapting Learned Cardinality Estimators to Data and Workload Drifts 2022 SIGMOD 6.5757572e-05
4,479 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5665703e-05
4,765 Machine Learning for Databases 2021 VLDB 6.4166895e-05
4,971 Debunking the Myth of Join Ordering: Toward Robust SQL Analytics 2025 SIGMOD 6.3209003e-05
5,029 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.2952031e-05
5,044 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.2888728e-05
5,062 Leveraging Query Logs and Machine Learning for Parametric Query Optimization 2022 VLDB 6.2791511e-05
5,126 Steering Query Optimizers: A Practical Take on Big Data Workloads 2021 SIGMOD 6.2493606e-05
5,153 Monotonic Cardinality Estimation of Similarity Selection: A Deep Learning Approach 2020 SIGMOD 6.2375324e-05
5,457 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1058928e-05
5,469 High-Performance Row Pattern Recognition Using Joins 2023 VLDB 6.1022571e-05
5,837 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9600736e-05
6,672 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 5.6975871e-05
6,690 Index-Accelerated Pattern Matching in Event Stores 2021 SIGMOD 5.6917141e-05
6,725 Simple Adaptive Query Processing vs. Learned Query Optimizers: Observations and Analysis 2023 VLDB 5.6826988e-05
6,768 Multi-Tenant Cloud Data Services: State-of-the-Art, Challenges and Opportunities 2022 SIGMOD 5.6693759e-05
6,840 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.6513231e-05
7,347 Scalable Multi-Query Execution using Reinforcement Learning 2021 SIGMOD 5.5308106e-05
7,355 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 5.529034e-05
7,377 PerfGuard: Deploying ML-for-Systems without Performance Regressions, Almost! 2021 VLDB 5.5238616e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 17 of 17 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033847446
160 CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies 2004 SIGMOD 0.00027775994
171 Wavelet-Based Histograms for Selectivity Estimation 1998 SIGMOD 0.00027063233
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022060616
372 STHoles: A Multidimensional Workload-Aware Histogram 2001 SIGMOD 0.00019768921
381 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019497061
457 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017915659
1,511 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010408003
1,541 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB 0.00010288394
2,310 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB 8.6493038e-05
2,544 Applying the Golden Rule of Sampling for Query Estimation 2001 SIGMOD 8.2988657e-05
2,888 Query Optimizers: Time to Rethink the Contract? 2009 SIGMOD 7.8895201e-05
4,480 DigitHist: a Histogram-Based Data Summary with Tight Error Bounds 2017 VLDB 6.566036e-05
5,490 A Pay-As-You-Go Framework for Query Execution Feedback 2008 VLDB 6.0970166e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,541 Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses 2018 VLDB
2 287 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
3 10,014 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD
4 1,511 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD
5 9,365 Deep Query Optimization 2019 SIGMOD
6 2,310 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB
7 8,297 Consistent and Flexible Selectivity Estimation for High-Dimensional Data 2021 SIGMOD
8 7,355 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD
9 1,583 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD
10 3,212 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB