Potter's Wheel: An Interactive Data Cleaning System

Summary: Potter's Wheel is an interactive data-cleaning system that tightly couples transformation with discrepancy detection, enabling progressive fixes in a spreadsheet-like interface. Transforms are defined graphically or by example, with immediate visual feedback; the system infers value structures and checks constraints in the background. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h91943e67ba716b59
Venue: VLDB
Year: 2001
Pagerank: 0.00034382643
Overall Rank: 95 | 99.37%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Vijayshankar Raman (University of California Berkeley)
2. Joseph M. Hellerstein (University of California Berkeley)

BibTeX Citation

@article{raman_vldb01,
        title = {{Potter's Wheel: An Interactive Data Cleaning System}},
        author = {Raman, Vijayshankar and Hellerstein, Joseph M.},
        journal = {PVLDB},
        series = {{VLDB} '01},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 67 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,532	PIClean: A Probabilistic and Interactive Data Cleaning System	2019	SIGMOD	5.5007996e-05
7,738	Auto-Validate: Unsupervised Data Validation Using Data-Domain Patterns Inferred from Data Lakes	2021	SIGMOD	5.4623434e-05
8,025	Foofah: A Programming-By-Example System for Synthesizing Data Transformation Programs	2017	SIGMOD	5.4047151e-05
8,245	Indexing Mixed Types for Approximate Retrieval	2005	VLDB	5.3694945e-05
8,594	RECA: Related Tables Enhanced Column Semantic Type Annotation Framework	2023	VLDB	5.3063445e-05
9,380	JENNER: Just-in-time Enrichment in Query Processing	2022	VLDB	5.1868213e-05
9,619	Interactive and Deterministic Data Cleaning: A Tossed Stone Raises a Thousand Ripples	2016	SIGMOD	5.1502244e-05
9,705	Repairing Data through Regular Expressions	2016	VLDB	5.1377317e-05
9,722	DataVinci: Learning Syntactic and Semantic String Repairs	2025	SIGMOD	5.1349531e-05
10,352	Towards Scalable Visual Data Wrangling via Direct Manipulation	2026	CIDR	4.9793485e-05
10,691	The Case For Language Model Approximated LIKE Predicate	2026	SIGMOD	4.9793485e-05
10,831	PrepBench: How Far Are We from Natural-Language-Driven Data Preparation?	2026	VLDB	4.9793485e-05
11,270	Weak-to-Strong Prompts with Lightweight-to-Powerful LLMs for High-Accuracy, Low-Cost, and Explainable Data Transformation	2025	VLDB	4.9793485e-05
12,186	Enabling Data Science for the Majority	2019	VLDB	4.9793485e-05
12,688	Microsoft Codename “Montego” – Data Import, Transformation, and Publication for Information Workers	2011	VLDB	4.9793485e-05
12,909	XClean in Action: A Demonstration of Declarative XML Data Cleaning	2007	CIDR	4.9793485e-05
13,007	Quality Views: Capturing and Exploiting the User Perspective on Data Quality	2006	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 8 of 8 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
182	Schema Mapping as Query Discovery	2000	VLDB	0.00026277842
735	Automatic segmentation of text into structured records	2001	SIGMOD	0.00014373044
763	AJAX: An Extensible Data Cleaning Tool	2000	SIGMOD	0.00014140127
832	NoDoSE - A Tool for Semi-Automatically Extracting Structured and Semistructured Data from Text Documents.	1998	SIGMOD	0.00013584281
1,118	XTRACT: A System for Extracting Document Type Descriptors from XML Documents	2000	SIGMOD	0.00011951924
1,578	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB	0.00010187094
1,703	Online Dynamic Reordering for Interactive Data Processing	1999	VLDB	9.8315219e-05
1,728	Using Schematically Heterogeneous Structures	1998	SIGMOD	9.7779564e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,099	KATARA: A Data Cleaning System Powered by Knowledge Bases and Crowdsourcing	2015	SIGMOD
2	1,871	Predictive Interaction for Data Transformation	2015	CIDR
3	7,912	CoCo: Interactive Exploration of Conformance Constraints for Data Understanding and Data Cleaning	2021	SIGMOD
4	6,621	A Demonstration of DBWipes: Clean as You Query	2012	VLDB
5	11,411	Demonstrating Matelda for Multi-Table Error Detection	2025	VLDB
6	5,881	ActiveClean: An Interactive Data Cleaning Framework For Modern Machine Learning	2016	SIGMOD
7	204	Declarative Data Cleaning: Language, Model, and Algorithms	2001	VLDB
8	9,619	Interactive and Deterministic Data Cleaning: A Tossed Stone Raises a Thousand Ripples	2016	SIGMOD
9	9,470	VisClean: Interactive Cleaning for Progressive Visualization	2020	VLDB
10	7,532	PIClean: A Probabilistic and Interactive Data Cleaning System	2019	SIGMOD