Interactive Query Explanations Using Fine Grained Provenance
Summary: Fine-grained provenance accelerates interactive query explanations by testing counterfactual interventions without re-running pipelines. Compared with IVM and tree-based methods, it avoids materialization, scales to large deletions, and better aligns with relational plans to improve data locality. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Alexander Yao (Columbia University)
BibTeX Citation
@inproceedings{yao_sigmod22,
title = {{Interactive Query Explanations Using Fine Grained Provenance}},
author = {Yao, Alexander},
series = {{SIGMOD} '22},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3514221.3520251},
url = {https://dl.acm.org/doi/10.1145/3514221.3520251},
year = {2022}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 6,482 | On Data-Aware Global Explainability of Graph Neural Networks | 2023 | VLDB | 5.7702646e-05 |
| 10,828 | Toward Temporal Attribution Analytics in Dataflows | 2026 | VLDB | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 11 of 11 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 |
| 189 | Scorpion: Explaining Away Outliers in Aggregate Queries | 2013 | VLDB | 0.00025840026 |
| 408 | DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views | 2012 | VLDB | 0.00018900199 |
| 590 | On Propagation of Deletions and Annotations Through Views | 2002 | PODS | 0.00015890019 |
| 670 | A Formal Approach to Finding Explanations for Database Queries | 2014 | SIGMOD | 0.00014954494 |
| 978 | Incremental Query Evaluation in a Ring of Databases | 2010 | PODS | 0.00012731074 |
| 1,746 | SMOKE: Fine-grained Lineage at Interactive Speed | 2018 | VLDB | 9.7341914e-05 |
| 1,814 | ProvSQL: Provenance and Probability Management in PostgreSQL | 2018 | VLDB | 9.5800565e-05 |
| 2,160 | DIFF: A Relational Interface for Large-Scale Data Explanation | 2019 | VLDB | 8.9364035e-05 |
| 2,222 | Explaining Query Answers with Explanation-Ready Databases | 2016 | VLDB | 8.8109051e-05 |
| 2,598 | Complaint-driven Training Data Debugging for Query 2.0 | 2020 | SIGMOD | 8.2385793e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 4,687 | Provenance for Natural Language Queries | 2017 | VLDB |
| 2 | 7,819 | You Say ‘What’, I Hear ‘Where’ and ‘Why’ — (Mis-)Interpreting SQL to Derive Fine-Grained Provenance | 2018 | VLDB |
| 3 | 9,414 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 4 | 1,827 | Querying Data Provenance | 2010 | SIGMOD |
| 5 | 7,234 | Hypothetical Reasoning via Provenance Abstraction | 2019 | SIGMOD |
| 6 | 8,583 | OneProvenance: Efficient Extraction of Dynamic Coarse-Grained Provenance From Database Query Event Logs | 2023 | VLDB |
| 7 | 670 | A Formal Approach to Finding Explanations for Database Queries | 2014 | SIGMOD |
| 8 | 622 | On the Provenance of Non-Answers to Queries over Extracted Data | 2008 | VLDB |
| 9 | 2,222 | Explaining Query Answers with Explanation-Ready Databases | 2016 | VLDB |
| 10 | 5,529 | Putting Things into Context: Rich Explanations for Query Answers using Join Graphs | 2021 | SIGMOD |