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.00034367518
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
126 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030430114
188 A Cost-Based Model and Effective Heuristic for Repairing Constraints by Value Modification 2005 SIGMOD 0.00025861123
307 Eliminating Fuzzy Duplicates in Data Warehouses 2002 VLDB 0.00021489374
412 Hippocratic Databases 2002 VLDB 0.00018691177
435 Mining Database Structure; Or, How to Build a Data Quality Browser 2002 SIGMOD 0.0001831946
484 Data Integration for the Relational Web 2009 VLDB 0.00017541069
514 Data Curation at Scale: The Data Tamer System 2013 CIDR 0.00016999652
526 Improving Data Quality: Consistency and Accuracy 2007 VLDB 0.00016879
650 Discovering Data Quality Rules 2008 VLDB 0.00015142855
697 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014687805
716 Guided Data Repair 2011 VLDB 0.00014546968
815 An Interactive Clustering-based Approach to Integrating Source Query Interfaces on the Deep Web 2004 SIGMOD 0.00013713173
1,044 Data Cleaning: Overview and Emerging Challenges 2016 SIGMOD 0.00012329478
1,095 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.00012048043
1,098 KATARA: A Data Cleaning System Powered by Knowledge Bases and Crowdsourcing 2015 SIGMOD 0.00012031983
1,115 Foofah: Transforming Data By Example 2017 SIGMOD 0.00011958625
1,370 Towards Scalable Dataframe Systems 2020 VLDB 0.00010895207
1,669 SystemDS: A Declarative Machine Learning System for the End-to-End Data Science Lifecycle 2020 CIDR 9.9324573e-05
1,872 Predictive Interaction for Data Transformation 2015 CIDR 9.4606235e-05
1,970 Information-Theoretic Tools for Mining Database Structure from Large Data Sets 2004 SIGMOD 9.2892451e-05
2,093 Sato: Contextual Semantic Type Detection in Tables 2020 VLDB 9.0593586e-05
2,505 Query-Oriented Data Cleaning with Oracles 2015 SIGMOD 8.3743595e-05
2,555 DogmatiX Tracks down Duplicates in XML 2005 SIGMOD 8.3009957e-05
2,687 Data X-Ray: A Diagnostic Tool for Data Errors 2015 SIGMOD 8.1271333e-05
2,719 Partial Results in Database Systems 2014 SIGMOD 8.0942034e-05
2,748 Uni-Detect: A Unified Approach to Automated Error Detection in Tables 2019 SIGMOD 8.0572603e-05
2,962 Auto-Detect: Data-Driven Error Detection in Tables 2018 SIGMOD 7.8038782e-05
2,967 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD 7.8016942e-05
3,419 Data Profiling – A Tutorial 2017 SIGMOD 7.3175997e-05
3,622 MOMA - A Mapping-based Object Matching System 2007 CIDR 7.1507704e-05
3,913 Navigating the Data Lake with DATAMARAN: Automatically Extracting Structure from Log Datasets 2018 SIGMOD 6.9274273e-05
4,085 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8129946e-05
4,127 GDR: A System for Guided Data Repair 2010 SIGMOD 6.7886034e-05
4,426 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB 6.601896e-05
4,591 ArcheType: A Novel Framework for Open-Source Column Type Annotation using Large Language Models 2024 VLDB 6.5113872e-05
4,724 Data Auditor: Exploring Data Quality and Semantics using Pattern Tableaux 2010 VLDB 6.4498285e-05
4,829 QFix: Diagnosing Errors through Query Histories 2017 SIGMOD 6.3887613e-05
5,033 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.3025938e-05
5,574 Saga: A Scalable Framework for Optimizing Data Cleaning Pipelines for Machine Learning Applications 2023 SIGMOD 6.0773771e-05
5,642 DataPrep.EDA: Task-Centric Exploratory Data Analysis for Statistical Modeling in Python 2021 SIGMOD 6.0519777e-05
5,785 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 5.9935627e-05
6,137 Semandaq: A Data Quality System Based on Conditional Functional Dependencies 2008 VLDB 5.873345e-05
6,154 NADEEF: A Generalized Data Cleaning System 2013 VLDB 5.8665355e-05
6,384 Qualitative Data Cleaning 2016 VLDB 5.8039496e-05
6,490 Synthesizing Type-Detection Logic for Rich Semantic Data Types using Open-source Code 2018 SIGMOD 5.7653145e-05
6,627 A Demonstration of DBWipes: Clean as You Query 2012 VLDB 5.7281668e-05
6,652 Combining Design and Performance in a Data Visualization Management System 2017 CIDR 5.7190063e-05
6,823 Error Diagnosis and Data Profiling with Data X-Ray 2015 VLDB 5.6701292e-05
7,161 Just-in-time Data Integration in Action 2010 VLDB 5.5941535e-05
7,302 CleanM: An Optimizable Query Language for Unified Scale-Out Data Cleaning 2017 VLDB 5.5584215e-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
182 Schema Mapping as Query Discovery 2000 VLDB 0.00026265768
736 Automatic segmentation of text into structured records 2001 SIGMOD 0.0001436639
763 AJAX: An Extensible Data Cleaning Tool 2000 SIGMOD 0.00014133678
832 NoDoSE - A Tool for Semi-Automatically Extracting Structured and Semistructured Data from Text Documents. 1998 SIGMOD 0.00013578018
1,118 XTRACT: A System for Extracting Document Type Descriptors from XML Documents 2000 SIGMOD 0.00011950028
1,578 SchemaSQL - A Language for Interoperability in Relational Multi-database Systems 1996 VLDB 0.00010182593
1,703 Online Dynamic Reordering for Interactive Data Processing 1999 VLDB 9.8269486e-05
1,729 Using Schematically Heterogeneous Structures 1998 SIGMOD 9.7734376e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,098 KATARA: A Data Cleaning System Powered by Knowledge Bases and Crowdsourcing 2015 SIGMOD
2 1,872 Predictive Interaction for Data Transformation 2015 CIDR
3 7,917 CoCo: Interactive Exploration of Conformance Constraints for Data Understanding and Data Cleaning 2021 SIGMOD
4 6,627 A Demonstration of DBWipes: Clean as You Query 2012 VLDB
5 11,417 Demonstrating Matelda for Multi-Table Error Detection 2025 VLDB
6 5,882 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,626 Interactive and Deterministic Data Cleaning: A Tossed Stone Raises a Thousand Ripples 2016 SIGMOD
9 9,481 VisClean: Interactive Cleaning for Progressive Visualization 2020 VLDB
10 7,538 PIClean: A Probabilistic and Interactive Data Cleaning System 2019 SIGMOD