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.00034382643
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.00030439683
188 A Cost-Based Model and Effective Heuristic for Repairing Constraints by Value Modification 2005 SIGMOD 0.00025872962
307 Eliminating Fuzzy Duplicates in Data Warehouses 2002 VLDB 0.00021499031
411 Hippocratic Databases 2002 VLDB 0.00018699914
435 Mining Database Structure; Or, How to Build a Data Quality Browser 2002 SIGMOD 0.0001832766
484 Data Integration for the Relational Web 2009 VLDB 0.00017548541
514 Data Curation at Scale: The Data Tamer System 2013 CIDR 0.00017006745
526 Improving Data Quality: Consistency and Accuracy 2007 VLDB 0.00016886621
649 Discovering Data Quality Rules 2008 VLDB 0.00015149865
697 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014694048
716 Guided Data Repair 2011 VLDB 0.00014553463
814 An Interactive Clustering-based Approach to Integrating Source Query Interfaces on the Deep Web 2004 SIGMOD 0.00013719268
1,043 Data Cleaning: Overview and Emerging Challenges 2016 SIGMOD 0.00012335114
1,094 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.0001205355
1,099 KATARA: A Data Cleaning System Powered by Knowledge Bases and Crowdsourcing 2015 SIGMOD 0.00012037058
1,115 Foofah: Transforming Data By Example 2017 SIGMOD 0.00011964111
1,369 Towards Scalable Dataframe Systems 2020 VLDB 0.00010899832
1,668 SystemDS: A Declarative Machine Learning System for the End-to-End Data Science Lifecycle 2020 CIDR 9.9371612e-05
1,871 Predictive Interaction for Data Transformation 2015 CIDR 9.464979e-05
1,969 Information-Theoretic Tools for Mining Database Structure from Large Data Sets 2004 SIGMOD 9.2935435e-05
2,092 Sato: Contextual Semantic Type Detection in Tables 2020 VLDB 9.0626928e-05
2,504 Query-Oriented Data Cleaning with Oracles 2015 SIGMOD 8.3782213e-05
2,555 DogmatiX Tracks down Duplicates in XML 2005 SIGMOD 8.3046884e-05
2,686 Data X-Ray: A Diagnostic Tool for Data Errors 2015 SIGMOD 8.1308928e-05
2,717 Partial Results in Database Systems 2014 SIGMOD 8.0980367e-05
2,748 Uni-Detect: A Unified Approach to Automated Error Detection in Tables 2019 SIGMOD 8.0610697e-05
2,960 Auto-Detect: Data-Driven Error Detection in Tables 2018 SIGMOD 7.8075103e-05
2,964 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD 7.8052551e-05
3,418 Data Profiling – A Tutorial 2017 SIGMOD 7.3210362e-05
3,621 MOMA - A Mapping-based Object Matching System 2007 CIDR 7.1539025e-05
3,912 Navigating the Data Lake with DATAMARAN: Automatically Extracting Structure from Log Datasets 2018 SIGMOD 6.9306061e-05
4,108 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.8020689e-05
4,127 GDR: A System for Guided Data Repair 2010 SIGMOD 6.791747e-05
4,424 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB 6.6048065e-05
4,589 ArcheType: A Novel Framework for Open-Source Column Type Annotation using Large Language Models 2024 VLDB 6.5144711e-05
4,723 Data Auditor: Exploring Data Quality and Semantics using Pattern Tableaux 2010 VLDB 6.4528647e-05
4,827 QFix: Diagnosing Errors through Query Histories 2017 SIGMOD 6.3917868e-05
5,031 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.3055788e-05
5,572 Saga: A Scalable Framework for Optimizing Data Cleaning Pipelines for Machine Learning Applications 2023 SIGMOD 6.0802555e-05
5,640 DataPrep.EDA: Task-Centric Exploratory Data Analysis for Statistical Modeling in Python 2021 SIGMOD 6.0548401e-05
5,783 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 5.9963988e-05
6,135 Semandaq: A Data Quality System Based on Conditional Functional Dependencies 2008 VLDB 5.8761214e-05
6,152 NADEEF: A Generalized Data Cleaning System 2013 VLDB 5.8693135e-05
6,381 Qualitative Data Cleaning 2016 VLDB 5.8066959e-05
6,488 Synthesizing Type-Detection Logic for Rich Semantic Data Types using Open-source Code 2018 SIGMOD 5.76799e-05
6,621 A Demonstration of DBWipes: Clean as You Query 2012 VLDB 5.7307884e-05
6,647 Combining Design and Performance in a Data Visualization Management System 2017 CIDR 5.7217042e-05
6,817 Error Diagnosis and Data Profiling with Data X-Ray 2015 VLDB 5.6727207e-05
7,158 Just-in-time Data Integration in Action 2010 VLDB 5.5967949e-05
7,298 CleanM: An Optimizable Query Language for Unified Scale-Out Data Cleaning 2017 VLDB 5.561054e-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.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
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,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