DBScholar

Back to papers

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

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 50 of 67 citing papers.

Rank Citing Paper Year Venue Pagerank
127 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030337791
190 A Cost-Based Model and Effective Heuristic for Repairing Constraints by Value Modification 2005 SIGMOD 0.00025812169
308 Eliminating Fuzzy Duplicates in Data Warehouses 2002 VLDB 0.0002143466
414 Hippocratic Databases 2002 VLDB 0.00018629709
435 Mining Database Structure; Or, How to Build a Data Quality Browser 2002 SIGMOD 0.00018277436
484 Data Integration for the Relational Web 2009 VLDB 0.00017535511
516 Data Curation at Scale: The Data Tamer System 2013 CIDR 0.00016963937
527 Improving Data Quality: Consistency and Accuracy 2007 VLDB 0.00016859013
653 Discovering Data Quality Rules 2008 VLDB 0.00015102328
695 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014679058
717 Guided Data Repair 2011 VLDB 0.00014531658
816 An Interactive Clustering-based Approach to Integrating Source Query Interfaces on the Deep Web 2004 SIGMOD 0.00013671567
989 Data Cleaning: Overview and Emerging Challenges 2016 SIGMOD 0.00012638176
1,094 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.00012039085
1,099 KATARA: A Data Cleaning System Powered by Knowledge Bases and Crowdsourcing 2015 SIGMOD 0.00012008783
1,111 Foofah: Transforming Data By Example 2017 SIGMOD 0.00011946262
1,374 Towards Scalable Dataframe Systems 2020 VLDB 0.00010862447
1,616 SystemDS: A Declarative Machine Learning System for the End-to-End Data Science Lifecycle 2020 CIDR 0.00010048776
1,875 Predictive Interaction for Data Transformation 2015 CIDR 9.4433754e-05
1,979 Information-Theoretic Tools for Mining Database Structure from Large Data Sets 2004 SIGMOD 9.2615384e-05
1,985 Sato: Contextual Semantic Type Detection in Tables 2020 VLDB 9.2378767e-05
2,492 Query-Oriented Data Cleaning with Oracles 2015 SIGMOD 8.3722864e-05
2,558 DogmatiX Tracks down Duplicates in XML 2005 SIGMOD 8.2766441e-05
2,685 Data X-Ray: A Diagnostic Tool for Data Errors 2015 SIGMOD 8.116387e-05
2,730 Partial Results in Database Systems 2014 SIGMOD 8.0676725e-05
2,752 Uni-Detect: A Unified Approach to Automated Error Detection in Tables 2019 SIGMOD 8.0387193e-05
2,958 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD 7.7991971e-05
2,960 Auto-Detect: Data-Driven Error Detection in Tables 2018 SIGMOD 7.7967245e-05
3,420 Data Profiling – A Tutorial 2017 SIGMOD 7.300051e-05
3,631 MOMA - A Mapping-based Object Matching System 2007 CIDR 7.1281012e-05
3,897 Navigating the Data Lake with DATAMARAN: Automatically Extracting Structure from Log Datasets 2018 SIGMOD 6.9202872e-05
4,079 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8026178e-05
4,128 GDR: A System for Guided Data Repair 2010 SIGMOD 6.7763091e-05
4,335 ArcheType: A Novel Framework for Open-Source Column Type Annotation using Large Language Models 2024 VLDB 6.6432811e-05
4,444 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB 6.5812416e-05
4,741 Data Auditor: Exploring Data Quality and Semantics using Pattern Tableaux 2010 VLDB 6.4290861e-05
4,852 QFix: Diagnosing Errors through Query Histories 2017 SIGMOD 6.3680596e-05
5,058 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.2817535e-05
5,230 Saga: A Scalable Framework for Optimizing Data Cleaning Pipelines for Machine Learning Applications 2023 SIGMOD 6.2059854e-05
5,655 DataPrep.EDA: Task-Centric Exploratory Data Analysis for Statistical Modeling in Python 2021 SIGMOD 6.0320824e-05
5,798 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 5.9738467e-05
6,152 Semandaq: A Data Quality System Based on Conditional Functional Dependencies 2008 VLDB 5.8545735e-05
6,156 NADEEF: A Generalized Data Cleaning System 2013 VLDB 5.8539963e-05
6,327 Qualitative Data Cleaning 2016 VLDB 5.7945802e-05
6,467 Synthesizing Type-Detection Logic for Rich Semantic Data Types using Open-source Code 2018 SIGMOD 5.7580747e-05
6,636 A Demonstration of DBWipes: Clean as You Query 2012 VLDB 5.7094244e-05
6,663 Combining Design and Performance in a Data Visualization Management System 2017 CIDR 5.7001805e-05
6,837 Error Diagnosis and Data Profiling with Data X-Ray 2015 VLDB 5.6518411e-05
7,183 Just-in-time Data Integration in Action 2010 VLDB 5.5757293e-05
7,320 CleanM: An Optimizable Query Language for Unified Scale-Out Data Cleaning 2017 VLDB 5.5401823e-05
Previous Page 1 / 2 Next

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
Previous Page 1 / 1 Next

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