Descriptive and Prescriptive Data Cleaning

Summary: Introduces a system for descriptive and prescriptive data cleaning that ties rules on transformation outputs to source data, yielding explanations and fixes. Scalable detection, propagation, and explanation of errors; evaluation on TPC-H for diverse quality rules. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h4da27135058bda88
Venue: SIGMOD
Year: 2014
Pagerank: 6.3207886e-05
Overall Rank: 4,998 | 66.40%
DOI: 10.1145/2588555.2610520

Incoming Non-self Citations Over Time

Authors

1. Anup Chalamalla (University of Waterloo)
2. Ihab F. Ilyas (University of Waterloo)
3. Mourad Ouzzani (Qatar Computing Research Institute)
4. Paolo Papotti (Qatar Computing Research Institute)

BibTeX Citation

@inproceedings{chalamalla_sigmod14,
        title = {{Descriptive and Prescriptive Data Cleaning}},
        author = {Chalamalla, Anup and Ilyas, Ihab F. and Ouzzani, Mourad and Papotti, Paolo},
        series = {{SIGMOD} '14},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2588555.2610520},
        url = {https://dl.acm.org/doi/10.1145/2588555.2610520},
        year = {2014}
}

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
972	The Data Civilizer System	2017	CIDR	0.00012763234
1,043	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD	0.00012335114
1,746	SMOKE: Fine-grained Lineage at Interactive Speed	2018	VLDB	9.7341914e-05
4,019	CLAMS: Bringing Quality to Data Lakes	2016	SIGMOD	6.8512817e-05
4,827	QFix: Diagnosing Errors through Query Histories	2017	SIGMOD	6.3917868e-05
5,388	Explaining Repaired Data with CFDs	2018	VLDB	6.151535e-05
6,381	Qualitative Data Cleaning	2016	VLDB	5.8066959e-05
7,950	A Natural Language Interface for Querying General and Individual Knowledge	2015	VLDB	5.4207861e-05
8,870	Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views	2015	VLDB	5.2601766e-05
8,951	Managing General and Individual Knowledge in Crowd Mining Applications	2015	CIDR	5.252096e-05
10,188	Reptile: Aggregation-level Explanations for Hierarchical Data	2022	SIGMOD	5.0651993e-05
10,515	Understanding the Impact of Data Noise in Federated Learning: [Experiments & Analysis]	2026	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
189	Scorpion: Explaining Away Outliers in Aggregate Queries	2013	VLDB	0.00025840026
697	NADEEF: A Commodity Data Cleaning System	2013	SIGMOD	0.00014694048
767	The LLUNATIC Data-Cleaning Framework	2013	VLDB	0.00014114806
791	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013976192
1,348	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB	0.0001094733
1,615	Sensitivity Analysis and Explanations for Robust Query Evaluation in Probabilistic Databases	2011	SIGMOD	0.00010067073
2,067	Explaining Missing Answers to SPJUA Queries	2010	VLDB	9.0924963e-05
2,458	Tracing Data Errors with View-Conditioned Causality	2011	SIGMOD	8.4371456e-05
6,621	A Demonstration of DBWipes: Clean as You Query	2012	VLDB	5.7307884e-05
6,761	Propagating Functional Dependencies with Conditions	2008	VLDB	5.68869e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,308	Automating Large-Scale Data Quality Verification	2018	VLDB
2	3,263	Automatic Data Repair: Are We Ready to Deploy?	2024	VLDB
3	989	Towards Certain Fixes with Editing Rules and Master Data	2010	VLDB
4	526	Improving Data Quality: Consistency and Accuracy	2007	VLDB
5	1,509	Data Quality and Data Cleaning: An Overview	2003	SIGMOD
6	1,344	Detecting Data Errors: Where are we and what needs to be done?	2016	VLDB
7	2,964	Towards Dependable Data Repairing with Fixing Rules	2014	SIGMOD
8	6,381	Qualitative Data Cleaning	2016	VLDB
9	649	Discovering Data Quality Rules	2008	VLDB
10	1,043	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD