DBScholar

Back to papers

Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes

Summary: Introduces selectivity estimation for predicates on set-valued attrs via factorization, turning containment into numeric predicates. Proposes ST and ST-hist factorization with Postgres, NeuroCard, and DeepDB, for improved accuracy and efficiency. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6824
Venue
SIGMOD
Year
2023
Pagerank
5.2193018e-05
Overall Rank
9,793 | 32.82%
DOI
10.1145/3626755

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{meng_sigmod23,
        title = {{Selectivity Estimation for Queries Containing Predicates over Set-Valued Attributes}},
        author = {Meng, Zizhong and Cao, Xin and Cong, Gao},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3626755},
        url = {https://dl.acm.org/doi/10.1145/3626755},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank Citing Paper Year Venue Pagerank
9,958 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1879626e-05
10,108 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.1347137e-05
10,851 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 27 of 27 cited papers.

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

Rank Cited Paper Year Venue Pagerank
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
35 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00048481081
76 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00037054261
84 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035838391
100 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034385207
101 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00034376651
280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.00022454217
323 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021264788
388 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019410042
401 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019092557
448 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00018292618
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
692 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014919816
1,122 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.0001209124
1,170 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011827259
1,440 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010778889
1,499 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010564536
1,503 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.000105564
1,573 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010328171
1,988 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.3501502e-05
2,121 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 9.1402718e-05
2,203 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.9610447e-05
2,308 Hashed Samples: Selectivity Estimators For Set Similarity Selection Queries 2008 VLDB 8.7738996e-05
3,086 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7708642e-05
3,162 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.6785856e-05
3,688 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.201795e-05
5,792 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 6.0871213e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 8,124 Consistent and Flexible Selectivity Estimation for High-Dimensional Data 2021 SIGMOD
2 2,281 Selectivity Estimation in Extensible Databases - A Neural Network Approach 1998 VLDB
3 280 Selectivity Estimation using Probabilistic Models 2001 SIGMOD
4 3,309 Conditional Selectivity for Statistics on Query Expressions 2004 SIGMOD
5 934 Selectivity Estimation and Query Optimization in Large Databases with Highly Skewed Distributions of Column Values 1988 VLDB
6 3,162 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB
7 1,503 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD
8 101 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB
9 697 Selectivity Estimation for Range Predicates using Lightweight Models 2019 VLDB
10 1,573 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD