DBScholar

Back to papers

LpBound: Pessimistic Cardinality Estimation using ℓp-Norms of Degree Sequences

Summary: LpBound yields upper bound on multi-join cardinalities via lp-norms of degree sequences; solved by an LP with data stats. Two optimizations exploit query structure to speed estimation; it beats traditional ML estimators in accuracy with comparable cost. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h5d0a21afa7cd5aba
Venue
SIGMOD
Year
2025
Pagerank
6.3775929e-05
Overall Rank
4,854 | 67.38%
DOI
10.1145/3725321
PDF
Download (CC BY 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{zhang_sigmod25,
        title = {{LpBound: Pessimistic Cardinality Estimation using ℓp-Norms of Degree Sequences}},
        author = {Zhang, Haozhe and Mayer, Christoph and Khamis, Mahmoud Abo and Olteanu, Dan and Suciu, Dan},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3725321},
        url = {https://dl.acm.org/doi/10.1145/3725321},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 13 of 13 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank Cited Paper Year Venue Pagerank
1 Access Path Selection in a Relational Database Management System 1979 SIGMOD 0.0023943337
15 How Good Are Query Optimizers, Really? 2016 VLDB 0.00061067652
85 Learned Cardinalities: Estimating Correlated Joins with Deep Learning 2019 CIDR 0.00035876108
318 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021166957
510 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017059914
981 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.00012713454
1,091 What do Shannon-type Inequalities, Submodular Width, and Disjunctive Datalog have to do with one another? 2017 PODS 0.00012068611
1,180 In-Memory Subgraph Matching: An In-depth Study 2020 SIGMOD 0.00011622165
1,465 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010572023
2,002 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.2076835e-05
2,844 FactorJoin: A New Cardinality Estimation Framework for Join Queries 2023 SIGMOD 7.9446987e-05
2,975 Accurate Summary-based Cardinality Estimation Through the Lens of Cardinality Estimation Graphs 2022 VLDB 7.7905662e-05
3,132 Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates 2019 CIDR 7.6107287e-05
3,983 Simplicity Done Right for Join Ordering 2021 CIDR 6.8722161e-05
5,020 Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server 2023 VLDB 6.3096708e-05
5,224 SafeBound: A Practical System for Generating Cardinality Bounds 2023 SIGMOD 6.2197808e-05
5,910 Join Size Bounds using l_p-Norms on Degree Sequences 2024 PODS 5.9478947e-05
6,745 Computing Join Queries with Functional Dependencies 2016 PODS 5.6890943e-05
Previous Page 1 / 1 Next

Semantically Similar Papers