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 50 of 50 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.00059813669 |
| 62 | Maintaining Views Incrementally | 1993 | SIGMOD | 0.00039040346 |
| 578 | The Complexity of Causality and Responsibility for Query Answers and non-Answers | 2011 | VLDB | 0.00016093679 |
| 621 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB | 0.0001548582 |
| 977 | Incremental Query Evaluation in a Ring of Databases | 2010 | PODS | 0.00012730241 |
| 1,360 | A Unified Approach to Ranking in Probabilistic Databases | 2009 | VLDB | 0.00010913787 |
| 1,548 | Conditioning Probabilistic Databases | 2008 | VLDB | 0.00010288842 |
| 1,554 | Update Exchange with Mappings and Provenance | 2007 | VLDB | 0.00010265583 |
| 1,827 | Querying Data Provenance | 2010 | SIGMOD | 9.5518797e-05 |
| 2,006 | Orchestra: Facilitating Collaborative Data Sharing | 2007 | SIGMOD | 9.2046844e-05 |
| 3,364 | Efficient Querying and Maintenance of Network Provenance at Internet-Scale | 2010 | SIGMOD | 7.3715499e-05 |
| 5,612 | Annotated XML: Queries and Provenance | 2008 | PODS | 6.0656179e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,888 | Computing Why-Provenance for Property Graph Queries | 2026 | VLDB |
| 2 | 621 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB |
| 3 | 7,823 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 4 | 4,684 | Provenance for Natural Language Queries | 2017 | VLDB |
| 5 | 8,323 | Computing How-Provenance for SPARQL Queries via Query Rewriting | 2021 | VLDB |
| 6 | 9,423 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 7 | 17 | Provenance Semirings | 2007 | PODS |
| 8 | 9,604 | Equivalence-Invariant Algebraic Provenance for Hyperplane Update Queries | 2020 | SIGMOD |
| 9 | 6,459 | On Provenance Minimization | 2011 | PODS |
| 10 | 1,827 | Querying Data Provenance | 2010 | SIGMOD |