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)

Paper ID: 6395
Venue: SIGMOD
Year: 2022
Pagerank: 4.7072603e-05
Overall Rank: 7,556 | 47.49%
DOI: 10.1145/3514221.3520251

Incoming Non-self Citations Over Time

Authors

1. Alexander Yao

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
6,156	On Data-Aware Global Explainability of Graph Neural Networks	2023	VLDB	5.1779507e-05

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
31	Provenance Semirings	2007	PODS	0.00078516827
213	Scorpion: Explaining Away Outliers in Aggregate Queries	2013	VLDB	0.0003371037
585	DBToaster: Higher-order Delta Processing for Dynamic, Frequently Fresh Views	2012	VLDB	0.00019682634
655	On Propagation of Deletions and Annotations Through Views	2002	PODS	0.00018593536
943	A Formal Approach to Finding Explanations for Database Queries	2014	SIGMOD	0.00015140995
1,231	Incremental Query Evaluation in a Ring of Databases	2010	PODS	0.00013141213
2,158	DIFF: A Relational Interface for Large-Scale Data Explanation	2019	VLDB	9.4117885e-05
2,259	ProvSQL: Provenance and Probability Management in PostgreSQL	2018	VLDB	9.1790333e-05
2,286	SMOKE: Fine-grained Lineage at Interactive Speed	2018	VLDB	9.102574e-05
2,655	Explaining Query Answers with Explanation-Ready Databases	2016	VLDB	8.3638668e-05
2,759	Complaint-driven Training Data Debugging for Query 2.0	2020	SIGMOD	8.1646193e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
4,853	Provenance for Natural Language Queries	2017	VLDB	5.8711821e-05
8,228	You Say 'What', I Hear 'Where' and 'Why' - (Mis-)Interpreting SQL to Derive Fine-Grained Provenance	2018	VLDB	4.549777e-05
9,031	Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile	2015	VLDB	4.3998298e-05
2,182	Querying Data Provenance	2010	SIGMOD	9.3596252e-05
8,392	Hypothetical Reasoning via Provenance Abstraction	2019	SIGMOD	4.5234647e-05
8,725	OneProvenance: Efficient Extraction of Dynamic Coarse-Grained Provenance From Database Query Event Logs	2023	VLDB	4.453957e-05
943	A Formal Approach to Finding Explanations for Database Queries	2014	SIGMOD	0.00015140995
653	On the Provenance of Non-Answers to Queries over Extracted Data	2008	VLDB	0.00018616975
2,655	Explaining Query Answers with Explanation-Ready Databases	2016	VLDB	8.3638668e-05
5,706	Putting Things into Context: Rich Explanations for Query Answers using Join Graphs	2021	SIGMOD	5.3633001e-05