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

Rank Citing Paper Year Venue Pagerank
125 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030932014
185 A Cost-Based Model and Effective Heuristic for Repairing Constraints by Value Modification 2005 SIGMOD 0.00026231189
306 Eliminating Fuzzy Duplicates in Data Warehouses 2002 VLDB 0.00021839661
404 Hippocratic Databases 2002 VLDB 0.00019065022
432 Mining Database Structure; Or, How to Build a Data Quality Browser 2002 SIGMOD 0.00018572055
493 Data Integration for the Relational Web 2009 VLDB 0.00017558709
516 Data Curation at Scale: The Data Tamer System 2013 CIDR 0.00017171198
533 Improving Data Quality: Consistency and Accuracy 2007 VLDB 0.0001705859
647 Discovering Data Quality Rules 2008 VLDB 0.00015334666
714 Guided Data Repair 2011 VLDB 0.00014662041
725 NADEEF: A Commodity Data Cleaning System 2013 SIGMOD 0.00014617251
791 An Interactive Clustering-based Approach to Integrating Source Query Interfaces on the Deep Web 2004 SIGMOD 0.00013995705
1,101 KATARA: A Data Cleaning System Powered by Knowledge Bases and Crowdsourcing 2015 SIGMOD 0.00012168934
1,160 BlinkFill: Semi-supervised Programming By Example for Syntactic String Transformations 2016 VLDB 0.00011883163
1,165 Foofah: Transforming Data By Example 2017 SIGMOD 0.00011860616
1,323 Data Cleaning: Overview and Emerging Challenges 2016 SIGMOD 0.00011152602
1,431 Towards Scalable Dataframe Systems 2020 VLDB 0.00010807221
1,756 SystemDS: A Declarative Machine Learning System for the End-to-End Data Science Lifecycle 2020 CIDR 9.8172465e-05
1,866 Predictive Interaction for Data Transformation 2015 CIDR 9.5914583e-05
1,913 Information-Theoretic Tools for Mining Database Structure from Large Data Sets 2004 SIGMOD 9.4928569e-05
2,223 Sato: Contextual Semantic Type Detection in Tables 2020 VLDB 8.9189986e-05
2,531 DogmatiX Tracks down Duplicates in XML 2005 SIGMOD 8.4574631e-05
2,570 Query-Oriented Data Cleaning with Oracles 2015 SIGMOD 8.4061164e-05
2,663 Partial Results in Database Systems 2014 SIGMOD 8.2818137e-05
2,728 Uni-Detect: A Unified Approach to Automated Error Detection in Tables 2019 SIGMOD 8.1995954e-05
2,759 Data X-Ray: A Diagnostic Tool for Data Errors 2015 SIGMOD 8.1577506e-05
2,981 Towards Dependable Data Repairing with Fixing Rules 2014 SIGMOD 7.8960114e-05
3,147 Auto-Detect: Data-Driven Error Detection in Tables 2018 SIGMOD 7.7077175e-05
3,387 Data Profiling – A Tutorial 2017 SIGMOD 7.4534663e-05
3,568 MOMA - A Mapping-based Object Matching System 2007 CIDR 7.3021209e-05
3,894 Navigating the Data Lake with DATAMARAN: Automatically Extracting Structure from Log Datasets 2018 SIGMOD 7.0417782e-05
4,059 GDR: A System for Guided Data Repair 2010 SIGMOD 6.9330647e-05
4,412 Auto-Transform: Learning-to-Transform by Patterns 2020 VLDB 6.7168614e-05
4,515 ArcheType: A Novel Framework for Open-Source Column Type Annotation using Large Language Models 2024 VLDB 6.6492389e-05
4,642 Data Auditor: Exploring Data Quality and Semantics using Pattern Tableaux 2010 VLDB 6.5908277e-05
4,904 Mining Precision Interfaces From Query Logs 2019 SIGMOD 6.4503063e-05
4,909 QueryBooster: Improving SQL Performance Using Middleware Services for Human-Centered Query Rewriting 2023 VLDB 6.4486671e-05
4,959 QFix: Diagnosing Errors through Query Histories 2017 SIGMOD 6.4283324e-05
5,620 DataPrep.EDA: Task-Centric Exploratory Data Analysis for Statistical Modeling in Python 2021 SIGMOD 6.1482864e-05
5,651 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 6.1336568e-05
6,013 Semandaq: A Data Quality System Based on Conditional Functional Dependencies 2008 VLDB 6.0094519e-05
6,050 NADEEF: A Generalized Data Cleaning System 2013 VLDB 5.9945626e-05
6,392 Qualitative Data Cleaning 2016 VLDB 5.8883971e-05
6,436 Synthesizing Type-Detection Logic for Rich Semantic Data Types using Open-source Code 2018 SIGMOD 5.8793793e-05
6,499 A Demonstration of DBWipes: Clean as You Query 2012 VLDB 5.8609765e-05
6,523 Combining Design and Performance in a Data Visualization Management System 2017 CIDR 5.8518572e-05
6,794 Error Diagnosis and Data Profiling with Data X-Ray 2015 VLDB 5.7712588e-05
7,019 Just-in-time Data Integration in Action 2010 VLDB 5.7247411e-05
7,179 CleanM: An Optimizable Query Language for Unified Scale-Out Data Cleaning 2017 VLDB 5.6802479e-05
7,232 Saga: A Scalable Framework for Optimizing Data Cleaning Pipelines for Machine Learning Applications 2023 SIGMOD 5.6659017e-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
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
Previous Page 1 / 1 Next

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