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.00012224038
Overall Rank
1,058 | 92.90%
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.00061067652
402 Worst-case Optimal Join Algorithms 2012 PODS 0.00019095982
406 Deep Unsupervised Cardinality Estimation 2020 VLDB 0.00019050182
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
869 Learning Multi-dimensional Indexes 2020 SIGMOD 0.00013363241
981 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012713454
1,065 Are We Ready For Learned Cardinality Estimation? 2021 VLDB 0.00012202293
1,258 Sampling-Based Query Re-Optimization 2016 SIGMOD 0.00011308863
1,580 Deep Learning Models for Selectivity Estimation of Multi-Attribute Queries 2020 SIGMOD 0.00010177136
2,002 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2076835e-05
2,209 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8360101e-05
2,217 Estimating Join Selectivities using Bandwidth-Optimized Kernel Density Models 2017 VLDB 8.8151982e-05
2,518 Learned Cardinality Estimation: A Design Space Exploration and A Comparative Evaluation 2022 VLDB 8.3532841e-05
2,583 Fauce: Fast and Accurate Deep Ensembles with Uncertainty for Cardinality Estimation 2021 VLDB 8.2589842e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
3,053 A Unified Deep Model of Learning from both Data and Queries for Cardinality Estimation 2021 SIGMOD 7.7041081e-05
3,194 A Statistical Perspective on Discovering Functional Dependencies in Noisy Data 2020 SIGMOD 7.5469742e-05
3,327 Robust Query Driven Cardinality Estimation under Changing Workloads 2023 VLDB 7.4233639e-05
3,563 Astrid: Accurate Selectivity Estimation for String Predicates using Deep Learning 2021 VLDB 7.2023194e-05
4,299 ALECE: An Attention-based Learned Cardinality Estimator for SPJ Queries on Dynamic Workloads 2024 VLDB 6.6766173e-05
4,459 Lightweight and Accurate Cardinality Estimation by Neural Network Gaussian Process 2022 SIGMOD 6.5883555e-05
5,211 SAM: Database Generation from Query Workloads with Supervised Autoregressive Models 2022 SIGMOD 6.2232582e-05
5,362 Can Large Language Models Predict Data Correlations from Column Names? 2023 VLDB 6.1592249e-05
5,438 Eraser: Eliminating Performance Regression on Learned Query Optimizer 2024 VLDB 6.1278045e-05
5,657 PGMJoins: Random Join Sampling with Graphical Models 2021 SIGMOD 6.0461e-05
5,835 Pre-training Summarization Models of Structured Datasets for Cardinality Estimation 2022 VLDB 5.9737602e-05
6,472 Cardinality Estimation over Knowledge Graphs with Embeddings and Graph Neural Networks 2024 SIGMOD 5.7716301e-05
8,170 Efficient Query Re-optimization with Judicious Subquery Selections 2023 SIGMOD 5.3827384e-05
8,638 LIMAO: A Framework for Lifelong Modular Learned Query Optimization 2025 VLDB 5.2965922e-05
9,911 AgentTune: An Agent-Based Large Language Model Framework for Database Knob Tuning 2026 SIGMOD 5.1079647e-05
10,222 PRICE: A Pretrained Model for Cross-Database Cardinality Estimation 2025 VLDB 5.0560976e-05
10,329 SSCard: Substring Cardinality Estimation using Suffix Tree-Guided Learned FM-Index 2026 SIGMOD 5.0322912e-05
10,638 CorrBound: Cardinality Estimation Accounting for Inter- and Intra-relation Correlations 2026 SIGMOD 4.9769913e-05
10,751 OBELISK: Efficient Offline Query Planning with Bayesian Optimization-Informed Language Model Reasoning 2026 VLDB 4.9769913e-05
11,265 ACE: A Cardinality Estimator for Set-Valued Queries 2025 VLDB 4.9769913e-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