DBScholar

Back to papers

Robust and Efficient Fuzzy Match for Online Data Cleaning

Summary: Proposes a novel similarity function addressing limitations of fuzzy-match metrics for data cleaning. Develops an efficient fuzzy-match algorithm for real-time validation/cleansing of incoming tuples against reference tables; demonstrated on real datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3504
Venue
SIGMOD
Year
2003
Pagerank
0.00028199923
Overall Rank
158 | 98.92%
DOI
10.1145/872757.872796

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{chaudhuri_sigmod03,
        title = {{Robust and Efficient Fuzzy Match for Online Data Cleaning}},
        author = {Chaudhuri, Surajit and Ganjam, Kris and Ganti, Venkatesh and Motwani, Rajeev},
        series = {{SIGMOD} '03},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/872757.872796},
        url = {https://dl.acm.org/doi/10.1145/872757.872796},
        year = {2003}
}

Incoming Citations (Sorted by Pagerank)

Showing 50 of 57 citing papers.

Rank Citing Paper Year Venue Pagerank
125 Trio: A System for Integrated Management of Data, Accuracy, and Lineage 2005 CIDR 0.00030932014
169 Efficient Exact Set-Similarity Joins 2006 VLDB 0.0002743469
200 Efficient set joins on similarity predicates 2004 SIGMOD 0.00025597287
228 Reference Reconciliation in Complex Information Spaces 2005 SIGMOD 0.00023941271
367 InfoGather: Entity Augmentation and Attribute Discovery By Holistic Matching with Web Tables 2012 SIGMOD 0.00019979463
574 Management of Probabilistic Data: Foundations and Challenges 2007 PODS 0.00016278855
626 Entity Resolution: Theory, Practice & Open Challenges 2012 VLDB 0.00015656958
974 To Search or to Crawl? Towards a Query Optimizer for Text-Centric Tasks 2006 SIGMOD 0.00012870746
975 Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search 2012 SIGMOD 0.00012870645
998 Towards Certain Fixes with Editing Rules and Master Data 2010 VLDB 0.0001275238
1,040 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012466499
1,394 Neighborhood Based Fast Graph Search in Large Networks 2011 SIGMOD 0.0001093153
1,560 Example-driven Design of Efficient Record Matching Queries 2007 VLDB 0.00010361222
1,684 Answering Table Augmentation Queries from Unstructured Lists on the Web [Extended Abstract] 2009 VLDB 0.0001001843
1,886 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB 9.5358137e-05
2,036 Bed-Tree: An All-Purpose Index Structure for String Similarity Search Based on Edit Distance 2010 SIGMOD 9.2782094e-05
2,103 Cost-Based Variable-Length-Gram Selection for String Collections to Support Approximate Queries Efficiently 2008 SIGMOD 9.1621686e-05
2,236 A Platform for Personal Information Management and Integration 2005 CIDR 8.8902064e-05
2,410 Leveraging Aggregate Constraints For Deduplication 2007 SIGMOD 8.6126774e-05
2,782 Interaction between Record Matching and Data Repairing 2011 SIGMOD 8.1280264e-05
2,899 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.97814e-05
3,294 Multi-column Substring Matching for Database Schema Translation 2006 VLDB 7.5491351e-05
3,356 Benchmarking Declarative Approximate Selection Predicates 2007 SIGMOD 7.490881e-05
3,568 MOMA - A Mapping-based Object Matching System 2007 CIDR 7.3021209e-05
3,610 Merging the Results of Approximate Match Operations 2004 VLDB 7.2593873e-05
3,731 Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints 2010 VLDB 7.1663952e-05
3,943 Exploiting Content Redundancy for Web Information Extraction 2010 VLDB 7.0063237e-05
4,009 Flexible String Matching Against Large Databases in Practice 2004 VLDB 6.9612537e-05
4,035 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.9439151e-05
4,707 SILKMOTH: An Efficient Method for Finding Related Sets with Maximum Matching Constraints 2017 VLDB 6.552423e-05
4,743 Probabilistic String Similarity Joins 2010 SIGMOD 6.5268783e-05
5,099 Fast Foreign-Key Detection in Microsoft SQL Server PowerPivot for Excel 2014 VLDB 6.3646928e-05
5,134 Auto-FuzzyJoin: Auto-Program Fuzzy Similarity Joins Without Labeled Examples 2021 SIGMOD 6.3532024e-05
5,344 Discovering Related Data At Scale 2021 VLDB 6.2591104e-05
5,412 Faerie: Efficient Filtering Algorithms for Approximate Dictionary-based Entity Extraction 2011 SIGMOD 6.2272563e-05
5,651 Sampling Cube: A Framework for Statistical OLAP Over Sampling Data 2008 SIGMOD 6.1336568e-05
5,726 Pigeonring: A Principle for Faster Thresholded Similarity Search 2019 VLDB 6.1079184e-05
6,041 Demonstration of Panda: A Weakly Supervised Entity Matching System 2021 VLDB 5.9976574e-05
6,120 Finding Frequent Items in Probabilistic Data 2008 SIGMOD 5.9693818e-05
6,167 Sparkly: A Simple yet Surprisingly Strong TF/IDF Blocker for Entity Matching 2023 VLDB 5.9524736e-05
6,343 A Deferred Cleansing Method for RFID Data Analytics 2006 VLDB 5.9063839e-05
6,484 A Pivotal Prefix Based Filtering Algorithm for String Similarity Search 2014 SIGMOD 5.8665833e-05
7,575 Scalable Column Concept Determination for Web Tables Using Large Knowledge Bases 2013 VLDB 5.5937684e-05
7,719 Data Cleaning in Microsoft SQL Server 2005 2005 SIGMOD 5.55926e-05
7,894 A Grammar-based Entity Representation Framework for Data Cleaning 2009 SIGMOD 5.5204248e-05
8,078 Indexing Mixed Types for Approximate Retrieval 2005 VLDB 5.492543e-05
8,088 Customizable and Scalable Fuzzy Join for Big Data 2019 VLDB 5.4900832e-05
9,425 Ranking Distributed Probabilistic Data 2009 SIGMOD 5.2711481e-05
9,705 META: An Efficient Matching-Based Method for Error-Tolerant Autocompletion 2016 VLDB 5.2351259e-05
9,979 Balance-Aware Distributed String Similarity-Based Query Processing System 2019 VLDB 5.1845938e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
56 M-tree: An Efficient Access Method for Similarity Search in Metric Spaces 1997 VLDB 0.00040719947
58 The Merge/Purge Problem for Large Databases 1995 SIGMOD 0.00040116748
107 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00033511706
160 Integration of Heterogeneous Databases Without Common Domains Using Queries Based on Textual Similarity 1998 SIGMOD 0.0002802209
306 Eliminating Fuzzy Duplicates in Data Warehouses 2002 VLDB 0.00021839661
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 975 Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search 2012 SIGMOD
2 1,560 Example-driven Design of Efficient Record Matching Queries 2007 VLDB
3 11,504 TokenJoin: Efficient Filtering for Set Similarity Join with Maximum Weighted Bipartite Matching 2023 VLDB
4 7,719 Data Cleaning in Microsoft SQL Server 2005 2005 SIGMOD
5 5,134 Auto-FuzzyJoin: Auto-Program Fuzzy Similarity Joins Without Labeled Examples 2021 SIGMOD
6 6,827 Sampling Dirty Data for Matching Attributes 2010 SIGMOD
7 1,248 Entity Matching: How Similar Is Similar 2011 VLDB
8 3,610 Merging the Results of Approximate Match Operations 2004 VLDB
9 4,009 Flexible String Matching Against Large Databases in Practice 2004 VLDB
10 306 Eliminating Fuzzy Duplicates in Data Warehouses 2002 VLDB