DBScholar

Back to papers

Eliminating Fuzzy Duplicates in Data Warehouses

Summary: Eliminating fuzzy duplicates in data-warehouse dimensional tables by leveraging hierarchies to resolve domain-specific abbreviations. A scalable, high-quality duplicate-elimination algorithm that outperforms generic text-similarity, validated on real operational DW datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
hb775d0ded3a6ba48
Venue
VLDB
Year
2002
Pagerank
0.00021489374
Overall Rank
307 | 97.94%
DOI
10.1016/B978-155860869-6/50058-5

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{ananthakrishna_vldb02,
        title = {{Eliminating Fuzzy Duplicates in Data Warehouses}},
        author = {Ananthakrishna, Rohit and Chaudhuri, Surajit and Ganti, Venkatesh},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50058-5},
        url = {https://doi.org/10.1016/B978-155860869-6/50058-5},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 37 of 37 citing papers.

Rank Citing Paper Year Venue Pagerank
161 Robust and Efficient Fuzzy Match for Online Data Cleaning 2003 SIGMOD 0.00027705594
168 Efficient Exact Set-Similarity Joins 2006 VLDB 0.00027151132
201 Efficient set joins on similarity predicates 2004 SIGMOD 0.00025319937
230 Reference Reconciliation in Complex Information Spaces 2005 SIGMOD 0.00023861741
244 Evaluation of entity resolution approaches on real-world match problems 2010 VLDB 0.00023307564
534 On Active Learning of Record Matching Packages 2010 SIGMOD 0.00016799
587 Management of Probabilistic Data: Foundations and Challenges 2007 PODS 0.00015927027
618 Reasoning about Record Matching Rules 2009 VLDB 0.0001553004
1,044 Data Cleaning: Overview and Emerging Challenges 2016 SIGMOD 0.00012329478
1,785 Approximate Lineage for Probabilistic Databases 2008 VLDB 9.6438009e-05
1,919 A Web of Concepts 2009 PODS 9.3747487e-05
1,970 Information-Theoretic Tools for Mining Database Structure from Large Data Sets 2004 SIGMOD 9.2892451e-05
2,461 Leveraging Aggregate Constraints For Deduplication 2007 SIGMOD 8.4279724e-05
2,555 DogmatiX Tracks down Duplicates in XML 2005 SIGMOD 8.3009957e-05
2,645 Progressive Approach to Relational Entity Resolution 2014 VLDB 8.173459e-05
2,895 Linking Temporal Records 2011 VLDB 7.8958597e-05
2,949 Distributed Data Deduplication 2016 VLDB 7.8193962e-05
3,240 Evaluating Entity Resolution Results 2010 VLDB 7.4979039e-05
3,274 Large-Scale Collective Entity Matching 2011 VLDB 7.4675244e-05
3,403 Benchmarking Declarative Approximate Selection Predicates 2007 SIGMOD 7.3266624e-05
3,547 Approximately Detecting Duplicates for Streaming Data using Stable Bloom Filters 2006 SIGMOD 7.2088273e-05
3,580 On-the-Fly Entity-Aware Query Processing in the Presence of Linkage 2010 VLDB 7.1897827e-05
3,622 MOMA - A Mapping-based Object Matching System 2007 CIDR 7.1507704e-05
4,118 Selectivity Estimation for Fuzzy String Predicates in Large Data Sets 2005 VLDB 6.7927394e-05
5,199 QuERy: A Framework for Integrating Entity Resolution with Query Processing 2016 VLDB 6.2309669e-05
5,852 Industry-Scale Duplicate Detection 2008 VLDB 5.9691287e-05
6,014 Query-Driven Approach to Entity Resolution 2013 VLDB 5.9112242e-05
6,384 Qualitative Data Cleaning 2016 VLDB 5.8039496e-05
6,528 Parallel Discrepancy Detection and Incremental Detection 2021 VLDB 5.7540798e-05
6,844 Serving Deep Learning Models with Deduplication from Relational Databases 2022 VLDB 5.6647722e-05
8,251 Indexing Mixed Types for Approximate Retrieval 2005 VLDB 5.3669582e-05
9,080 Privacy and Accuracy-Aware AI/ML Model Deduplication 2025 SIGMOD 5.2258409e-05
9,885 Towards a Unified Framework for String Similarity Joins 2019 VLDB 5.115241e-05
11,596 Enriching Relations with Additional Attributes for ER 2024 VLDB 4.9769913e-05
11,690 Towards Better Bounds for Finding Quasi-Identifiers * 2023 PODS 4.9769913e-05
12,543 GRDB: A System for Declarative and Interactive Analysis of Noisy Information Networks 2013 SIGMOD 4.9769913e-05
12,686 Web Scale Taxonomy Cleansing 2011 VLDB 4.9769913e-05
Previous Page 1 / 1 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
60 The Merge/Purge Problem for Large Databases 1995 SIGMOD 0.00039440583
95 Potter's Wheel: An Interactive Data Cleaning System 2001 VLDB 0.00034367518
108 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00033040246
162 Integration of Heterogeneous Databases Without Common Domains Using Queries Based on Textual Similarity 1998 SIGMOD 0.00027524669
204 Declarative Data Cleaning: Language, Model, and Algorithms 2001 VLDB 0.00025179068
296 Generic Schema Matching with Cupid 2001 VLDB 0.00021857869
736 Automatic segmentation of text into structured records 2001 SIGMOD 0.0001436639
1,750 Clustering Categorical Data: An Approach Based on Dynamical Systems 1998 VLDB 9.7283911e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,089 Flexible String Matching Against Large Databases in Practice 2004 VLDB
2 1,249 Entity Matching: How Similar Is Similar 2011 VLDB
3 4,053 Crowd-Based Deduplication: An Adaptive Approach 2015 SIGMOD
4 2,949 Distributed Data Deduplication 2016 VLDB
5 5,852 Industry-Scale Duplicate Detection 2008 VLDB
6 5,525 MDedup: Duplicate Detection with Matching Dependencies 2020 VLDB
7 7,883 Data Cleaning in Microsoft SQL Server 2005 2005 SIGMOD
8 885 Framework for Evaluating Clustering Algorithms in Duplicate Detection 2009 VLDB
9 3,426 Modeling and Querying Possible Repairs in Duplicate Detection 2009 VLDB
10 161 Robust and Efficient Fuzzy Match for Online Data Cleaning 2003 SIGMOD