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
h9edd3a495e8dbbc0
Venue
SIGMOD
Year
2023
Pagerank
5.1031384e-05
Overall Rank
9,976 | 32.93%
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,718 A Practical Theory of Generalization in Selectivity Learning 2025 VLDB 5.1353964e-05
10,336 An Elephant Under The Microscope: Analyzing The Interaction Of Optimizer Components In PostgreSQL 2025 SIGMOD 5.0200193e-05
11,257 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9793485e-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
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
37 Improved Histograms for Selectivity Estimation of Range Predicates 1996 SIGMOD 0.00047731453
79 Practical Selectivity Estimation through Adaptive Sampling 1990 SIGMOD 0.00036487763
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035864347
98 LEO - DB2's LEarning Optimizer 2001 VLDB 0.00034106982
103 Selectivity Estimation Without the Attribute Value Independence Assumption 1997 VLDB 0.00033894985
286 Selectivity Estimation using Probabilistic Models 2001 SIGMOD 0.0002211981
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021167555
386 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019444411
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
454 Self-tuning Histograms: Building Histograms Without Looking at Data 1999 SIGMOD 0.00017962189
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
701 Independence is Good: Dependency-Based Histogram Synopses for High-Dimensional Data 2001 SIGMOD 0.00014680907
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
1,156 QuickSel: Quick Selectivity Learning with Mixture Models 2020 SIGMOD 0.00011777105
1,465 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010576304
1,467 On the Relative Cost of Sampling for Join Selectivity Estimation 1994 PODS 0.00010567959
1,508 Self-Tuning, GPU-Accelerated Kernel Density Models for Multidimensional Selectivity Estimation 2015 SIGMOD 0.00010440205
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010180835
2,004 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2065719e-05
2,140 SASH: A Self-Adaptive Histogram Set for Dynamically Changing Workloads 2003 VLDB 8.9682092e-05
2,216 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8177753e-05
2,354 Hashed Samples: Selectivity Estimators For Set Similarity Selection Queries 2008 VLDB 8.5896515e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-05
3,210 Efficiently Approximating Selectivity Functions using Low Overhead Regression Models 2020 VLDB 7.5363533e-05
3,741 FACE: A Normalizing Flow based Cardinality Estimator 2022 VLDB 7.0594076e-05
5,840 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9737703e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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