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.00034319763
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,527	PIClean: A Probabilistic and Interactive Data Cleaning System	2019	SIGMOD	5.4868307e-05
7,755	Auto-Validate: Unsupervised Data Validation Using Data-Domain Patterns Inferred from Data Lakes	2021	SIGMOD	5.4424293e-05
7,787	RECA: Related Tables Enhanced Column Semantic Type Annotation Framework	2023	VLDB	5.4356666e-05
8,047	Foofah: A Programming-By-Example System for Synthesizing Data Transformation Programs	2017	SIGMOD	5.3846335e-05
8,267	Indexing Mixed Types for Approximate Retrieval	2005	VLDB	5.3492332e-05
9,415	JENNER: Just-in-time Enrichment in Query Processing	2022	VLDB	5.1672232e-05
9,654	Interactive and Deterministic Data Cleaning: A Tossed Stone Raises a Thousand Ripples	2016	SIGMOD	5.1310198e-05
9,742	Repairing Data through Regular Expressions	2016	VLDB	5.1183191e-05
9,758	DataVinci: Learning Syntactic and Semantic String Repairs	2025	SIGMOD	5.115551e-05
10,431	Towards Scalable Visual Data Wrangling via Direct Manipulation	2026	CIDR	4.9605343e-05
10,762	The Case For Language Model Approximated LIKE Predicate	2026	SIGMOD	4.9605343e-05
10,902	PrepBench: How Far Are We from Natural-Language-Driven Data Preparation?	2026	VLDB	4.9605343e-05
11,334	Weak-to-Strong Prompts with Lightweight-to-Powerful LLMs for High-Accuracy, Low-Cost, and Explainable Data Transformation	2025	VLDB	4.9605343e-05
12,235	Enabling Data Science for the Majority	2019	VLDB	4.9605343e-05
12,737	Microsoft Codename “Montego” – Data Import, Transformation, and Publication for Information Workers	2011	VLDB	4.9605343e-05
12,957	XClean in Action: A Demonstration of Declarative XML Data Cleaning	2007	CIDR	4.9605343e-05
13,055	Quality Views: Capturing and Exploiting the User Perspective on Data Quality	2006	VLDB	4.9605343e-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
184	Schema Mapping as Query Discovery	2000	VLDB	0.00026196483
737	Automatic segmentation of text into structured records	2001	SIGMOD	0.00014327386
767	AJAX: An Extensible Data Cleaning Tool	2000	SIGMOD	0.00014100723
835	NoDoSE - A Tool for Semi-Automatically Extracting Structured and Semistructured Data from Text Documents.	1998	SIGMOD	0.000135388
1,121	XTRACT: A System for Extracting Document Type Descriptors from XML Documents	2000	SIGMOD	0.00011920252
1,580	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB	0.00010153792
1,713	Online Dynamic Reordering for Interactive Data Processing	1999	VLDB	9.7948649e-05
1,736	Using Schematically Heterogeneous Structures	1998	SIGMOD	9.7450722e-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,875	Predictive Interaction for Data Transformation	2015	CIDR
3	7,041	CoCo: Interactive Exploration of Conformance Constraints for Data Understanding and Data Cleaning	2021	SIGMOD
4	6,636	A Demonstration of DBWipes: Clean as You Query	2012	VLDB
5	11,470	Demonstrating Matelda for Multi-Table Error Detection	2025	VLDB
6	5,868	ActiveClean: An Interactive Data Cleaning Framework For Modern Machine Learning	2016	SIGMOD
7	206	Declarative Data Cleaning: Language, Model, and Algorithms	2001	VLDB
8	9,654	Interactive and Deterministic Data Cleaning: A Tossed Stone Raises a Thousand Ripples	2016	SIGMOD
9	9,510	VisClean: Interactive Cleaning for Progressive Visualization	2020	VLDB
10	7,527	PIClean: A Probabilistic and Interactive Data Cleaning System	2019	SIGMOD