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: 8953
Venue: VLDB
Year: 2001
Pagerank: 0.00034616103
Overall Rank: 94 | 99.36%
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 16 of 66 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,387	PIClean: A Probabilistic and Interactive Data Cleaning System	2019	SIGMOD	5.6270554e-05
7,690	Auto-Validate: Unsupervised Data Validation Using Data-Domain Patterns Inferred from Data Lakes	2021	SIGMOD	5.5669307e-05
7,869	Foofah: A Programming-By-Example System for Synthesizing Data Transformation Programs	2017	SIGMOD	5.5273054e-05
8,078	Indexing Mixed Types for Approximate Retrieval	2005	VLDB	5.492543e-05
8,458	RECA: Related Tables Enhanced Column Semantic Type Annotation Framework	2023	VLDB	5.4217059e-05
9,200	JENNER: Just-in-time Enrichment in Query Processing	2022	VLDB	5.3058708e-05
9,442	Interactive and Deterministic Data Cleaning: A Tossed Stone Raises a Thousand Ripples	2016	SIGMOD	5.2677992e-05
9,523	Repairing Data through Regular Expressions	2016	VLDB	5.2556545e-05
9,539	DataVinci: Learning Syntactic and Semantic String Repairs	2025	SIGMOD	5.2528121e-05
10,131	Towards Scalable Visual Data Wrangling via Direct Manipulation	2026	CIDR	5.093636e-05
10,505	The Case For Language Model Approximated LIKE Predicate	2026	SIGMOD	5.093636e-05
10,867	Weak-to-Strong Prompts with Lightweight-to-Powerful LLMs for High-Accuracy, Low-Cost, and Explainable Data Transformation	2025	VLDB	5.093636e-05
11,886	Enabling Data Science for the Majority	2019	VLDB	5.093636e-05
12,397	Microsoft Codename “Montego” – Data Import, Transformation, and Publication for Information Workers	2011	VLDB	5.093636e-05
12,619	XClean in Action: A Demonstration of Declarative XML Data Cleaning	2007	CIDR	5.093636e-05
12,717	Quality Views: Capturing and Exploiting the User Perspective on Data Quality	2006	VLDB	5.093636e-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
180	Schema Mapping as Query Discovery	2000	VLDB	0.00026772368
717	Automatic segmentation of text into structured records	2001	SIGMOD	0.00014649121
751	AJAX: An Extensible Data Cleaning Tool	2000	SIGMOD	0.00014369237
812	NoDoSE - A Tool for Semi-Automatically Extracting Structured and Semistructured Data from Text Documents.	1998	SIGMOD	0.00013851743
1,142	XTRACT: A System for Extracting Document Type Descriptors from XML Documents	2000	SIGMOD	0.00012002609
1,558	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB	0.00010366362
1,680	Online Dynamic Reordering for Interactive Data Processing	1999	VLDB	0.00010024295
1,708	Using Schematically Heterogeneous Structures	1998	SIGMOD	9.958846e-05

Semantically Similar Papers

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