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.2989483e-05
Overall Rank: 5,022 | 66.34%
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.00012742827
989	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD	0.00012638176
1,722	SMOKE: Fine-grained Lineage at Interactive Speed	2018	VLDB	9.781628e-05
4,016	CLAMS: Bringing Quality to Data Lakes	2016	SIGMOD	6.8370819e-05
4,852	QFix: Diagnosing Errors through Query Histories	2017	SIGMOD	6.3680596e-05
5,387	Explaining Repaired Data with CFDs	2018	VLDB	6.1374778e-05
6,327	Qualitative Data Cleaning	2016	VLDB	5.7945802e-05
7,969	A Natural Language Interface for Querying General and Individual Knowledge	2015	VLDB	5.4004078e-05
8,894	Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views	2015	VLDB	5.2415191e-05
8,972	Managing General and Individual Knowledge in Crowd Mining Applications	2015	CIDR	5.2347984e-05
10,224	Reptile: Aggregation-level Explanations for Hierarchical Data	2022	SIGMOD	5.0460607e-05
10,592	Understanding the Impact of Data Noise in Federated Learning: [Experiments & Analysis]	2026	SIGMOD	4.9605343e-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
191	Scorpion: Explaining Away Outliers in Aggregate Queries	2013	VLDB	0.0002578784
695	NADEEF: A Commodity Data Cleaning System	2013	SIGMOD	0.00014679058
769	The LLUNATIC Data-Cleaning Framework	2013	VLDB	0.00014091996
790	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013929166
1,354	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB	0.00010912271
1,619	Sensitivity Analysis and Explanations for Robust Query Evaluation in Probabilistic Databases	2011	SIGMOD	0.00010044303
2,079	Explaining Missing Answers to SPJUA Queries	2010	VLDB	9.0602682e-05
2,459	Tracing Data Errors with View-Conditioned Causality	2011	SIGMOD	8.4137923e-05
6,636	A Demonstration of DBWipes: Clean as You Query	2012	VLDB	5.7094244e-05
6,783	Propagating Functional Dependencies with Conditions	2008	VLDB	5.6675149e-05

Semantically Similar Papers

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