Back to papers
Every Row Counts: Combining Sketches and Sampling for Accurate Group-By Result Estimates
Summary: Hybrid estimator combining per-column sketches that capture full-frequency information with small random samples to correct inter-column correlation bias, enabling accurate group-by distinct-count estimates for arbitrary attribute combinations. Achieves near-perfect per-column accuracy, high multi-column accuracy, low integration overhead, and negligible estimation time via an efficient sample-scan algorithm.
(summarized by gpt-5-mini on Feb 09 2026)
- Paper ID
- 329
- Venue
- CIDR
- Year
- 2019
- Pagerank
- 6.8232992e-05
- Overall Rank
- 3,706 | 74.25%
- DOI
-
-
Incoming Non-self Citations Over Time
Incoming Citations (Sorted by Pagerank)
Showing 16 of 16 citing papers.
| Rank |
Citing Paper |
Year |
Venue |
Pagerank |
| 729 |
Umbra: A Disk-Based System with In-Memory Performance |
2020 |
CIDR |
0.00017448059 |
| 2,281 |
Adopting Worst-Case Optimal Joins in Relational Database Systems |
2020 |
VLDB |
9.122455e-05 |
| 4,835 |
MNC: Structure-Exploiting Sparsity Estimation for Matrix Expressions |
2019 |
SIGMOD |
5.8861112e-05 |
| 5,201 |
SetSketch: Filling the Gap between MinHash and HyperLogLog |
2021 |
VLDB |
5.6283451e-05 |
| 6,605 |
MotherDuck: DuckDB in the cloud and in the client |
2024 |
CIDR |
4.9923144e-05 |
| 6,967 |
LpBound: Pessimistic Cardinality Estimation using ℓp-Norms of Degree Sequences |
2025 |
SIGMOD |
4.875312e-05 |
| 7,021 |
DuckPGQ: Bringing SQL/PGQ to DuckDB |
2023 |
VLDB |
4.8546368e-05 |
| 7,340 |
Weighted Distinct Sampling: Cardinality Estimation for SPJ Queries |
2021 |
SIGMOD |
4.7526052e-05 |
| 7,666 |
Fast Detection of Denial Constraint Violations |
2022 |
VLDB |
4.6792751e-05 |
| 7,708 |
UltraLogLog: A Practical and More Space-Efficient Alternative to HyperLogLog for Approximate Distinct Counting |
2024 |
VLDB |
4.6675856e-05 |
| 8,271 |
Adaptive Factorization Using Linear-Chained Hash Tables |
2025 |
CIDR |
4.539672e-05 |
| 8,676 |
A Practical Approach to Groupjoin and Nested Aggregates |
2021 |
VLDB |
4.4652082e-05 |
| 9,230 |
Panakos: Chasing the Tails for Multidimensional Data Streams |
2023 |
VLDB |
4.3650857e-05 |
| 10,012 |
A Fast, Mergeable, and LDP Compatible Sketch for Counting the Number of Distinct Values in Fully Dynamic Tables |
2026 |
SIGMOD |
4.1905499e-05 |
| 10,227 |
Sample-based Distinct Cardinality Estimation for Multiple Attributes in Multi-Dataset Queries |
2026 |
VLDB |
4.1905499e-05 |
| 11,256 |
Asymptotically Better Query Optimization Using Indexed Algebra |
2023 |
VLDB |
4.1905499e-05 |
Outgoing Citations (Sorted by Pagerank)
Showing 14 of 14 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank |
Cited Paper |
Year |
Venue |
Pagerank |
| 60 |
Sampling-Based Estimation of the Number of Distinct Values of an Attribute |
1995 |
VLDB |
0.00064450997 |
| 71 |
How Good Are Query Optimizers, Really? |
2016 |
VLDB |
0.00059446482 |
| 224 |
CORDS: Automatic Discovery of Correlations and Soft Functional Dependencies |
2004 |
SIGMOD |
0.00032743209 |
| 316 |
Distinct Sampling for Highly-Accurate Answers to Distinct Values Queries and Event Reports |
2001 |
VLDB |
0.00027981848 |
| 380 |
Towards Estimation Error Guarantees for Distinct Values |
2000 |
PODS |
0.00024943236 |
| 1,047 |
Functional Dependency Discovery: An Experimental Evaluation of Seven Algorithms |
2015 |
VLDB |
0.00014442219 |
| 1,104 |
Cardinality Estimation Done Right: Index-Based Join Sampling |
2017 |
CIDR |
0.0001398479 |
| 1,683 |
Cardinality Estimation: An Experimental Survey |
2018 |
VLDB |
0.0001091276 |
| 1,978 |
Improved Selectivity Estimation by Combining Knowledge from Sampling and Synopses |
2018 |
VLDB |
9.8764627e-05 |
| 2,583 |
Sample + Seek: Approximating Aggregates with Distribution Precision Guarantee |
2016 |
SIGMOD |
8.4973431e-05 |
| 3,013 |
Cardinality Estimation Using Sample Views with Quality Assurance |
2007 |
SIGMOD |
7.7082045e-05 |
| 4,566 |
Adaptive Statistics in Oracle 12c |
2017 |
VLDB |
6.073045e-05 |
| 4,815 |
DigitHist: a Histogram-Based Data Summary with Tight Error Bounds |
2017 |
VLDB |
5.8978716e-05 |
| 5,371 |
Efficient Estimation of Inclusion Coefficient using HyperLogLog Sketches |
2018 |
VLDB |
5.5424564e-05 |
Semantically Similar Papers