DBScholar

Back to papers

A Practical Theory of Generalization in Selectivity Learning

Summary: Proves learnability of signed-measure selectivity predictors and provides out-of-distribution generalization bounds beyond the PAC framework. Derives two practical strategies that empirically boost OOD selectivity accuracy and query latency while retaining in-distribution performance. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
hcc0235248bd6ecf0
Venue
VLDB
Year
2025
Pagerank
5.1159926e-05
Overall Rank
9,753 | 34.63%
DOI
10.14778/3725688.3725708
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{wu_vldb25,
        title = {{A Practical Theory of Generalization in Selectivity Learning}},
        author = {Wu, Peizhi and Xu, Haoshu and Marcus, Ryan and Ives, Zachary G.},
        journal = {PVLDB},
        series = {{VLDB} '25},
        volume = {18},
        number = {6},
        pages = {1811--1824},
        doi = {10.14778/3725688.3725708},
        url = {https://doi.org/10.14778/3725688.3725708},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank Citing Paper Year Venue Pagerank
10,327 Data-Agnostic Cardinality Learning from Imperfect Workloads 2025 VLDB 5.0241309e-05
10,873 BaCon: Efficient Batch Processing of Counting Queries 2026 VLDB 4.9605343e-05
10,994 TATA: An Efficient Framework for Task Transfer in Query Plan Representation 2026 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 37 of 37 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
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061463175
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035920657
91 On the Propagation of Errors in the Size of Join Results 1991 SIGMOD 0.00034691614
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034050614
234 Adaptive Selectivity Estimation Using Query Feedback 1994 SIGMOD 0.00023726296
320 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021128745
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
453 An End-to-End Learning-based Cost Estimator 2020 VLDB 0.0001801482
457 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017915659
508 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017108973
646 Exploiting Statistics on Query Expressions for Optimization 2002 SIGMOD 0.00015166402
690 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB 0.00014703258
960 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB 0.00012825107
983 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012677179
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011759683
1,436 Towards a Learning Optimizer for Shared Clouds 2019 VLDB 0.00010658836
1,513 DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems 2021 VLDB 0.00010394557
1,740 Flow-Loss: Learning Cardinality Estimates That Matter 2021 VLDB 9.7289523e-05
2,154 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9382906e-05
2,348 Learned Cardinality Estimation: An In-depth Study 2022 SIGMOD 8.5910072e-05
2,731 TPC-DS, Taking Decision Support Benchmarking to the Next Level 2002 SIGMOD 8.0676575e-05
2,852 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9201312e-05
3,060 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.6828463e-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
4,315 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6545412e-05
5,075 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.2721634e-05
5,457 Sample-Efficient Cardinality Estimation Using Geometric Deep Learning 2024 VLDB 6.1058928e-05
5,854 Modeling Shifting Workloads for Learned Database Systems 2024 SIGMOD 5.9520525e-05
6,672 Speeding Up End-to-end Query Execution via Learning-based Progressive Cardinality Estimation 2023 SIGMOD 5.6975871e-05
6,840 ASM: Harmonizing Autoregressive Model, Sampling, and Multi-dimensional Statistics Merging for Cardinality Estimation 2024 SIGMOD 5.6513231e-05
7,355 Selectivity Functions of Range Queries are Learnable* 2022 SIGMOD 5.529034e-05
7,587 Convolution and Cross-Correlation of Count Sketches Enables Fast Cardinality Estimation of Multi-Join Queries 2024 SIGMOD 5.4745198e-05
8,412 PARQO: Penalty-Aware Robust Plan Selection in Query Optimization 2024 VLDB 5.3211467e-05
10,014 Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes 2023 SIGMOD 5.0838565e-05
Previous Page 1 / 1 Next

Semantically Similar Papers