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: 4953
Venue: SIGMOD
Year: 2014
Pagerank: 6.4590072e-05
Overall Rank: 4,890 | 66.46%
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
963	The Data Civilizer System	2017	CIDR	0.00012935145
1,323	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD	0.00011152602
1,798	SMOKE: Fine-grained Lineage at Interactive Speed	2018	VLDB	9.7361937e-05
4,201	CLAMS: Bringing Quality to Data Lakes	2016	SIGMOD	6.8355878e-05
4,959	QFix: Diagnosing Errors through Query Histories	2017	SIGMOD	6.4283324e-05
5,312	Explaining Repaired Data with CFDs	2018	VLDB	6.2698779e-05
6,392	Qualitative Data Cleaning	2016	VLDB	5.8883971e-05
7,788	A Natural Language Interface for Querying General and Individual Knowledge	2015	VLDB	5.5446256e-05
8,714	Stale View Cleaning: Getting Fresh Answers from Stale Materialized Views	2015	VLDB	5.3778009e-05
8,788	Managing General and Individual Knowledge in Crowd Mining Applications	2015	CIDR	5.3726124e-05
10,001	Reptile: Aggregation-level Explanations for Hierarchical Data	2022	SIGMOD	5.1814573e-05
10,303	Understanding the Impact of Data Noise in Federated Learning: [Experiments & Analysis]	2026	SIGMOD	5.093636e-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.00026096009
725	NADEEF: A Commodity Data Cleaning System	2013	SIGMOD	0.00014617251
800	The LLUNATIC Data-Cleaning Framework	2013	VLDB	0.00013911223
856	How to ConQueR Why-Not Questions	2010	SIGMOD	0.00013573466
1,332	Sampling the Repairs of Functional Dependency Violations under Hard Constraints	2010	VLDB	0.00011129529
1,594	Sensitivity Analysis and Explanations for Robust Query Evaluation in Probabilistic Databases	2011	SIGMOD	0.00010252583
2,032	Explaining Missing Answers to SPJUA Queries	2010	VLDB	9.2828822e-05
2,432	Tracing Data Errors with View-Conditioned Causality	2011	SIGMOD	8.5870067e-05
6,499	A Demonstration of DBWipes: Clean as You Query	2012	VLDB	5.8609765e-05
6,639	Propagating Functional Dependencies with Conditions	2008	VLDB	5.8165825e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,350	Automating Large-Scale Data Quality Verification	2018	VLDB
2	3,580	Automatic Data Repair: Are We Ready to Deploy?	2024	VLDB
3	998	Towards Certain Fixes with Editing Rules and Master Data	2010	VLDB
4	533	Improving Data Quality: Consistency and Accuracy	2007	VLDB
5	1,484	Data Quality and Data Cleaning: An Overview	2003	SIGMOD
6	1,351	Detecting Data Errors: Where are we and what needs to be done?	2016	VLDB
7	2,981	Towards Dependable Data Repairing with Fixing Rules	2014	SIGMOD
8	6,392	Qualitative Data Cleaning	2016	VLDB
9	647	Discovering Data Quality Rules	2008	VLDB
10	1,323	Data Cleaning: Overview and Emerging Challenges	2016	SIGMOD