Fast Approximate Computation of Statistics on Views
Summary: Fast statistics for views/SITs on joins between large fact and small dimension, avoiding materialization. Uses fact-key frequency stats plus a dimension scan to capture correlations, skew, and domain ranges; yields speedups with minor accuracy loss. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Calisto Zuzarte (IBM)
- 2. Xiaohui Yu (University of Toronto)
BibTeX Citation
@inproceedings{zuzarte_sigmod06,
title = {{Fast Approximate Computation of Statistics on Views}},
author = {Zuzarte, Calisto and Yu, Xiaohui},
series = {{SIGMOD} '06},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/1142473.1142564},
url = {https://dl.acm.org/doi/10.1145/1142473.1142564},
year = {2006}
}Incoming Citations (Sorted by Pagerank)
Showing 1 of 1 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 10,891 | Cardinality Estimation for Having-Clauses | 2025 | VLDB | 5.093636e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 664 | Exploiting Statistics on Query Expressions for Optimization | 2002 | SIGMOD | 0.00015167825 |
| 3,093 | Statistics on Views | 2003 | VLDB | 7.7664764e-05 |
| 3,309 | Conditional Selectivity for Statistics on Query Expressions | 2004 | SIGMOD | 7.5368417e-05 |
| 6,562 | Query Sampling in DB2 Universal Database | 2004 | SIGMOD | 5.838575e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 11,644 | Index-Based Join Size Estimation Using Adaptive Sampling | 2021 | SIGMOD |
| 2 | 235 | Fast Incremental Maintenance of Approximate Histograms | 1997 | VLDB |
| 3 | 2,991 | FactorJoin: A New Cardinality Estimation Framework for Join Queries | 2023 | SIGMOD |
| 4 | 2,404 | Cardinality Estimation Using Sample Views with Quality Assurance | 2007 | SIGMOD |
| 5 | 5,514 | StatAdvisor: Recommending Statistical Views | 2009 | VLDB |
| 6 | 3,093 | Statistics on Views | 2003 | VLDB |
| 7 | 149 | New Sampling-Based Summary Statistics for Improving Approximate Query Answers | 1998 | SIGMOD |
| 8 | 1,172 | An Instant and Accurate Size Estimation Method for Joins and Selection in a Retrieval-Intensive Environment | 1993 | SIGMOD |
| 9 | 3,309 | Conditional Selectivity for Statistics on Query Expressions | 2004 | SIGMOD |
| 10 | 136 | Join Synopses for Approximate Query Answering | 1999 | SIGMOD |