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
10505
Venue
VLDB
Year
2011
Pagerank
0.00012322342
Overall Rank
1,071 | 92.66%
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
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
401 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019092557
411 Worst-case Optimal Join Algorithms 2012 PODS 0.00018902089
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
873 Learning Multi-dimensional Indexes 2020 SIGMOD 0.00013481915
1,061 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012369764
1,122 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.0001209124
1,256 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011457194
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,203 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.9610447e-05
2,420 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.605257e-05
2,620 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.3363963e-05
2,723 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.2049453e-05
2,991 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.8880723e-05
3,086 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7708642e-05
3,338 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.5068221e-05
3,441 A Statistical Perspective on Discovering Functional Dependencies in Noisy Data 2020 SIGMOD 7.4138323e-05
3,545 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.3249967e-05
4,349 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.7504619e-05
4,368 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.7393882e-05
5,105 SAM: Database Generation from Query Workloads with Supervised Autoregressive Models 2022 SIGMOD 6.3628539e-05
5,354 Can Large Language Models Predict Data Correlations from Column Names? 2023 VLDB 6.2515841e-05
5,551 PGMJoins: Random Join Sampling with Graphical Models 2021 SIGMOD 6.1782856e-05
5,573 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 6.1682747e-05
5,792 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 6.0871213e-05
6,341 Cardinality Estimation over Knowledge Graphs with Embeddings and Graph Neural Networks 2024 SIGMOD 5.9068986e-05
9,428 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2709145e-05
9,756 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.2258278e-05
10,028 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.1745962e-05
10,097 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.1502319e-05
10,340 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.093636e-05
10,438 CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations 2026 SIGMOD 5.093636e-05
10,559 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 5.093636e-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 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