QFix: Diagnosing Errors through Query Histories

Summary: QFix diagnoses data-quality errors by tracing how queries affected data to derive explanations and repairs. Formalizes query-based diagnosis, provides exact diagnosis/repair methods, optimizations, a tunable accuracy–performance tradeoff to scale to large logs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 5292
Venue: SIGMOD
Year: 2017
Pagerank: 5.4967096e-05
Overall Rank: 5,454 | 62.10%
DOI: 10.1145/3035918.3035925

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 10 of 10 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,759	Complaint-driven Training Data Debugging for Query 2.0	2020	SIGMOD	8.1646193e-05
3,303	SCODED: Statistical Constraint Oriented Data Error Detection	2020	SIGMOD	7.2438671e-05
4,661	Efficient Answering of Historical What-if Queries	2022	SIGMOD	6.0069281e-05
5,660	Query Refinement for Diverse Top-k Selection	2024	SIGMOD	5.3859487e-05
7,024	A Unified Approach for Resilience and Causal Responsibility with Integer Linear Programming (ILP) and LP Relaxations	2023	SIGMOD	4.8530001e-05
8,335	BugDoc: Algorithms to Debug Computational Processes	2020	SIGMOD	4.538972e-05
10,289	Efficient Query Repair for Aggregate Constraints	2026	VLDB	4.1905499e-05
10,405	Ultraverse: An Efficient What-if Analysis Framework for Software Applications Interacting with Database Systems	2025	SIGMOD	4.1905499e-05
10,639	Is Integer Linear Programming All You Need for Deletion Propagation?	2025	VLDB	4.1905499e-05
11,845	QFix: Demonstrating Error Diagnosis in Query Histories	2016	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 33 of 33 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
112	Potter's Wheel: An Interactive Data Cleaning System	2001	VLDB	0.00047010908
213	Scorpion: Explaining Away Outliers in Aggregate Queries	2013	VLDB	0.0003371037
321	Record Linkage: Similarity Measures and Algorithms	2006	SIGMOD	0.00027524716
339	OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases	2014	VLDB	0.00026895683
372	A Bayesian Approach to Discovering Truth from Conflicting Sources for Data Integration	2012	VLDB	0.00025371138
487	Why Not?	2009	SIGMOD	0.00022030123
621	Improving Data Quality: Consistency and Accuracy	2007	VLDB	0.00018978331
641	Corleone: Hands-Off Crowdsourcing for Entity Matching	2014	SIGMOD	0.00018759417
690	AJAX: An Extensible Data Cleaning Tool	2000	SIGMOD	0.00018068707
830	Guided Data Repair	2011	VLDB	0.00016125759
943	A Formal Approach to Finding Explanations for Database Queries	2014	SIGMOD	0.00015140995
1,012	NADEEF: A Commodity Data Cleaning System	2013	SIGMOD	0.00014638349
1,124	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013832959
1,187	On Generating Near-Optimal Tableaux for Conditional Functional Dependencies	2008	VLDB	0.00013432048
1,376	Tiresias: The Database Oracle for How-To Queries	2012	SIGMOD	0.00012315734
1,403	Detecting Data Errors: Where are we and what needs to be done?	2016	VLDB	0.00012180046
1,533	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	0.00011462982
1,625	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB	0.0001109361
2,031	Putting Lipstick on Pig: Enabling Database-style Workflow Provenance	2012	VLDB	9.7341007e-05
2,453	Data Fusion – Resolving Data Conflicts for Integration	2009	VLDB	8.7815427e-05
2,600	Tracing Data Errors with View-Conditioned Causality	2011	SIGMOD	8.4652308e-05
2,854	MRI: Meaningful Interpretations of Collaborative Ratings	2011	VLDB	8.0139911e-05
3,107	Data X-Ray: A Diagnostic Tool for Data Errors	2015	SIGMOD	7.5549177e-05
3,248	Explanation-Based Auditing	2012	VLDB	7.3232501e-05
4,380	Incremental Record Linkage	2014	VLDB	6.2325868e-05
4,453	CLAMShell: Speeding up Crowds for Low-latency Data Labeling	2016	VLDB	6.1690121e-05
4,932	Data Auditor: Exploring Data Quality and Semantics using Pattern Tableaux	2010	VLDB	5.8163536e-05
5,428	High-Level Why-Not Explanations using Ontologies	2015	PODS	5.5125084e-05
5,671	Descriptive and Prescriptive Data Cleaning	2014	SIGMOD	5.3797808e-05
6,606	Explainable Security for Relational Databases	2014	SIGMOD	4.9917624e-05
6,621	We Challenge You to Certify Your Updates	2011	SIGMOD	4.9857889e-05
6,746	MapRat: Meaningful Explanation, Interactive Exploration and Geo-Visualization of Collaborative Ratings	2012	VLDB	4.937341e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
5,671	Descriptive and Prescriptive Data Cleaning	2014	SIGMOD	5.3797808e-05
9,623	Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries	2024	SIGMOD	4.3120302e-05
3,397	Automatic Data Repair: Are We Ready to Deploy?	2024	VLDB	7.1386386e-05
2,574	Database Repairs and Consistent Query Answering: Origins and Further Developments	2019	PODS	8.5126812e-05
3,107	Data X-Ray: A Diagnostic Tool for Data Errors	2015	SIGMOD	7.5549177e-05
1,160	Towards Certain Fixes with Editing Rules and Master Data	2010	VLDB	0.0001358129
3,198	Towards Dependable Data Repairing with Fixing Rules	2014	SIGMOD	7.4029546e-05
8,363	Deducing Certain Fixes to Graphs	2019	VLDB	4.5311185e-05
621	Improving Data Quality: Consistency and Accuracy	2007	VLDB	0.00018978331
11,845	QFix: Demonstrating Error Diagnosis in Query Histories	2016	SIGMOD	4.1905499e-05