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.00059843817 |
| 61 | Maintaining Views Incrementally | 1993 | SIGMOD | 0.00039026867 |
| 605 | The Complexity of Causality and Responsibility for Query Answers and non-Answers | 2011 | VLDB | 0.00015839628 |
| 628 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB | 0.00015630285 |
| 960 | Incremental Query Evaluation in a Ring of Databases | 2010 | PODS | 0.00012945163 |
| 1,327 | A Unified Approach to Ranking in Probabilistic Databases | 2009 | VLDB | 0.00011141552 |
| 1,520 | Conditioning Probabilistic Databases | 2008 | VLDB | 0.00010510496 |
| 1,599 | Update Exchange with Mappings and Provenance | 2007 | VLDB | 0.00010241307 |
| 1,912 | Querying Data Provenance | 2010 | SIGMOD | 9.4946756e-05 |
| 2,026 | Orchestra: Facilitating Collaborative Data Sharing | 2007 | SIGMOD | 9.287998e-05 |
| 3,323 | Efficient Querying and Maintenance of Network Provenance at Internet-Scale | 2010 | SIGMOD | 7.5211754e-05 |
| 5,502 | Annotated XML: Queries and Provenance | 2008 | PODS | 6.1961339e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,502 | Annotated XML: Queries and Provenance | 2008 | PODS |
| 2 | 628 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB |
| 3 | 8,145 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 4 | 4,602 | Provenance for Natural Language Queries | 2017 | VLDB |
| 5 | 8,976 | Computing How-Provenance for SPARQL Queries via Query Rewriting | 2021 | VLDB |
| 6 | 9,241 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 7 | 17 | Provenance Semirings | 2007 | PODS |
| 8 | 9,416 | Equivalence-Invariant Algebraic Provenance for Hyperplane Update Queries | 2020 | SIGMOD |
| 9 | 6,358 | On Provenance Minimization | 2011 | PODS |
| 10 | 1,912 | Querying Data Provenance | 2010 | SIGMOD |