DBScholar

Back to papers

Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions

Summary: Proposes a selectivity model that drops independence assumptions and factorizes joint distribution into 2D factors via graphical models. Implemented in PostgreSQL with optimizations, achieving order-of-magnitude gains in selectivity within tens-of-ms. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h711a07b4c067036f
Venue
VLDB
Year
2011
Pagerank
0.00012224575
Overall Rank
1,060 | 92.88%
DOI
10.14778/3402707.3402724

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{tzoumas_vldb11,
        title = {{Lightweight Graphical Models for Selectivity Estimation Without Independence Assumptions}},
        author = {Tzoumas, Kostas and Deshpande, Amol and Jensen, Christian S.},
        journal = {PVLDB},
        series = {{VLDB} '11},
        volume = {4},
        number = {11},
        pages = {852--863},
        doi = {10.14778/3402707.3402724},
        url = {https://doi.org/10.14778/3402707.3402724},
        year = {2011}
}

Incoming Citations (Sorted by Pagerank)

Showing 35 of 35 citing papers.

Rank Citing Paper Year Venue Pagerank
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061066921
402 Worst-case Optimal Join Algorithms 2012 PODS 0.00019104625
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019045544
512 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017050173
868 Learning Multi-dimensional Indexes 2020 SIGMOD 0.00013354403
982 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012714044
1,064 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202282
1,257 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011310561
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,210 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8257742e-05
2,216 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8177753e-05
2,522 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3477168e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589758e-05
2,846 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9453616e-05
3,052 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7052471e-05
3,193 A Statistical Perspective on Discovering Functional Dependencies in Noisy Data 2020 SIGMOD 7.5505481e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4207879e-05
3,562 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2046519e-05
4,311 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6727978e-05
4,457 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5913732e-05
5,209 SAM: Database Generation from Query Workloads with Supervised Autoregressive Models 2022 SIGMOD 6.2262056e-05
5,357 Can Large Language Models Predict Data Correlations from Column Names? 2023 VLDB 6.1619918e-05
5,456 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 6.1239873e-05
5,657 PGMJoins: Random Join Sampling with Graphical Models 2021 SIGMOD 6.0488437e-05
5,840 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9737703e-05
6,469 Cardinality Estimation over Knowledge Graphs with Embeddings and Graph Neural Networks 2024 SIGMOD 5.7743636e-05
8,164 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.3852872e-05
9,610 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.1526493e-05
9,904 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.1103839e-05
10,216 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.0584922e-05
10,322 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0346745e-05
10,627 CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations 2026 SIGMOD 4.9793485e-05
10,741 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9793485e-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 13 of 13 cited papers.

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

Previous Page 1 / 1 Next

Semantically Similar Papers