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.00059660827 |
| 62 | Maintaining Views Incrementally | 1993 | SIGMOD | 0.00038944207 |
| 581 | The Complexity of Causality and Responsibility for Query Answers and non-Answers | 2011 | VLDB | 0.00016042765 |
| 624 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB | 0.00015438077 |
| 979 | Incremental Query Evaluation in a Ring of Databases | 2010 | PODS | 0.00012697012 |
| 1,367 | A Unified Approach to Ranking in Probabilistic Databases | 2009 | VLDB | 0.00010878876 |
| 1,551 | Conditioning Probabilistic Databases | 2008 | VLDB | 0.00010257014 |
| 1,556 | Update Exchange with Mappings and Provenance | 2007 | VLDB | 0.00010232016 |
| 1,837 | Querying Data Provenance | 2010 | SIGMOD | 9.5210079e-05 |
| 2,015 | Orchestra: Facilitating Collaborative Data Sharing | 2007 | SIGMOD | 9.1743528e-05 |
| 3,373 | Efficient Querying and Maintenance of Network Provenance at Internet-Scale | 2010 | SIGMOD | 7.348575e-05 |
| 5,623 | Annotated XML: Queries and Provenance | 2008 | PODS | 6.045738e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 10,949 | Computing Why-Provenance for Property Graph Queries | 2026 | VLDB |
| 2 | 624 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB |
| 3 | 7,840 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 4 | 8,338 | Computing How-Provenance for SPARQL Queries via Query Rewriting | 2021 | VLDB |
| 5 | 4,697 | Provenance for Natural Language Queries | 2017 | VLDB |
| 6 | 9,449 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 7 | 17 | Provenance Semirings | 2007 | PODS |
| 8 | 9,630 | Equivalence-Invariant Algebraic Provenance for Hyperplane Update Queries | 2020 | SIGMOD |
| 9 | 6,472 | On Provenance Minimization | 2011 | PODS |
| 10 | 1,837 | Querying Data Provenance | 2010 | SIGMOD |