Provenance for Aggregate Queries
Summary: Shows semiring tuple annotations fail for aggregate queries; proposes value-level provenance that annotates individual attribute values to record how aggregate results are computed. Gives constructions for simple (aggregation-last) and general positive RA with aggregation, and studies semantics including an encoding of difference. (summarized by gpt-5-mini on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Yael Amsterdamer (Tel Aviv University; University of Pennsylvania)
- 2. Daniel Deutch (Ben Gurion University; University of Pennsylvania)
- 3. Val Tannen (University of Pennsylvania)
BibTeX Citation
@inproceedings{amsterdamer_pods11,
address = {New York, NY, USA},
series = {{PODS} '11},
title = {{Provenance for Aggregate Queries}},
url = {https://dl.acm.org/doi/10.1145/1989284.1989302},
doi = {10.1145/1989284.1989302},
booktitle = {Proceedings of the {ACM} {SIGMOD} Symposium on {Principles} of {Database} {Systems}},
publisher = {Association for Computing Machinery},
author = {Amsterdamer, Yael and Deutch, Daniel and Tannen, Val},
year = {2011}
}Incoming Citations (Sorted by Pagerank)
Showing 49 of 49 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 12 of 12 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 17 | Provenance Semirings | 2007 | PODS | 0.00059752575 |
| 62 | Maintaining Views Incrementally | 1993 | SIGMOD | 0.00039045511 |
| 578 | The Complexity of Causality and Responsibility for Query Answers and non-Answers | 2011 | VLDB | 0.00016096504 |
| 622 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB | 0.00015484312 |
| 978 | Incremental Query Evaluation in a Ring of Databases | 2010 | PODS | 0.00012731074 |
| 1,365 | A Unified Approach to Ranking in Probabilistic Databases | 2009 | VLDB | 0.00010913898 |
| 1,549 | Conditioning Probabilistic Databases | 2008 | VLDB | 0.00010288725 |
| 1,555 | Update Exchange with Mappings and Provenance | 2007 | VLDB | 0.00010269848 |
| 1,827 | Querying Data Provenance | 2010 | SIGMOD | 9.5545888e-05 |
| 2,002 | Orchestra: Facilitating Collaborative Data Sharing | 2007 | SIGMOD | 9.208994e-05 |
| 3,368 | Efficient Querying and Maintenance of Network Provenance at Internet-Scale | 2010 | SIGMOD | 7.3701213e-05 |
| 5,611 | Annotated XML: Queries and Provenance | 2008 | PODS | 6.0684862e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,879 | Computing Why-Provenance for Property Graph Queries | 2026 | VLDB |
| 2 | 622 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB |
| 3 | 7,819 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 4 | 4,687 | Provenance for Natural Language Queries | 2017 | VLDB |
| 5 | 8,330 | Computing How-Provenance for SPARQL Queries via Query Rewriting | 2021 | VLDB |
| 6 | 9,414 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 7 | 17 | Provenance Semirings | 2007 | PODS |
| 8 | 9,596 | Equivalence-Invariant Algebraic Provenance for Hyperplane Update Queries | 2020 | SIGMOD |
| 9 | 6,457 | On Provenance Minimization | 2011 | PODS |
| 10 | 1,827 | Querying Data Provenance | 2010 | SIGMOD |