DBScholar

Back to papers

Convolution and Cross-Correlation of Count Sketches Enables Fast Cardinality Estimation of Multi-Join Queries

Summary: Combines Count Sketch with convolution/cross-correlation to support AMS-style cardinality estimation for complex multi-way equi-joins, finally getting fast updates for multi-join sketches. Unbiased estimator with AMS-level error guarantees; orders-of-magnitude faster maintenance, often better accuracy. (summarized by gpt-5.4-mini on May 24 2026)

Paper ID
6956
Venue
SIGMOD
Year
2024
Pagerank
5.5529458e-05
Overall Rank
7,747 | 46.85%
DOI
10.1145/3654932

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{heddes_sigmod24,
        title = {{Convolution and Cross-Correlation of Count Sketches Enables Fast Cardinality Estimation of Multi-Join Queries}},
        author = {Heddes, Mike and Nunes, Igor and Givargis, Tony and Nicolau, Alex},
        series = {{SIGMOD} '24},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3654932},
        url = {https://dl.acm.org/doi/10.1145/3654932},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 5 of 5 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 24 of 24 cited papers.

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

Rank Cited Paper Year Venue Pagerank
18 How Good Are Query Optimizers, Really? 2016 VLDB 0.00059284255
290 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002227038
311 Surfing Wavelets on Streams: One-Pass Summaries for Approximate Aggregate Queries 2001 VLDB 0.00021760621
323 DeepDB: Learn from Data, not from Queries! 2020 VLDB 0.00021264788
388 Preventing Bad Plans by Bounding the Impact of Cardinality Estimation Errors 2009 VLDB 0.00019410042
418 Tracking Join and Self-Join Sizes in Limited Storage 1999 PODS 0.00018812821
513 NeuroCard: One Cardinality Estimator for All Tables 2021 VLDB 0.00017190574
737 Join Size Estimation Subject to Filter Conditions 2015 VLDB 0.00014490983
817 Processing Complex Aggregate Queries over Data Streams 2002 SIGMOD 0.00013823702
1,045 Sketching Streams Through the Net: Distributed Approximate Query Tracking 2005 VLDB 0.00012440928
1,122 Cardinality Estimation in DBMS: A Comprehensive Benchmark Evaluation 2022 VLDB 0.0001209124
1,294 Augmented Sketch: Faster and More Accurate Stream Processing 2016 SIGMOD 0.00011291308
1,499 Pessimistic Cardinality Estimation: Tighter Upper Bounds for Intermediate Join Cardinalities 2019 SIGMOD 0.00010564536
1,988 FLAT: Fast, Lightweight and Accurate Method for Cardinality Estimation 2021 VLDB 9.3501502e-05
3,031 Interactive Outlier Exploration in Big Data Streams 2014 VLDB 7.8324917e-05
4,529 TencentRec: Real-time Stream Recommendation in Practice 2015 SIGMOD 6.6446748e-05
4,863 Pyramid Sketch: a Sketch Framework for Frequency Estimation of Data Streams 2017 VLDB 6.4740702e-05
4,900 COMPASS: Online Sketch-based Query Optimization for In-Memory Databases 2021 SIGMOD 6.4534715e-05
5,036 Finding Hierarchical Heavy Hitters in Data Streams 2003 VLDB 6.3915389e-05
5,647 IBM InfoSphere Streams for Scalable, Real-Time, Intelligent Transportation Services 2010 SIGMOD 6.1354257e-05
5,988 Complex Event Recognition in the Big Data Era 2017 VLDB 6.0177874e-05
8,990 STAR: A Distributed Stream Warehouse System for Spatial Data 2020 SIGMOD 5.3378159e-05
9,027 JoinSketch: A Sketch Algorithm for Accurate and Unbiased Inner-Product Estimation 2023 SIGMOD 5.3293224e-05
9,888 TeRec: A Temporal Recommender System Over Tweet Stream 2013 VLDB 5.2004234e-05
Previous Page 1 / 1 Next

Semantically Similar Papers