Ed-Join
Authors:
Open Access
- 1 August 2008
- journal article
- Published by Association for Computing Machinery (ACM) in Proceedings of the VLDB Endowment
- Vol. 1 (1) , 933-944
Abstract
There has been considerable interest in similarity join in the research community recently. Similarity join is a fundamental operation in many application areas, such as data integration and cleaning, bioinformatics, and pattern recognition. We focus on efficient algorithms for similarity join with edit distance constraints. Existing approaches are mainly based on converting the edit distance constraint to a weaker constraint on the number of matching q -grams between pair of strings. In this paper, we propose the novel perspective of investigating mismatching q -grams. Technically, we derive two new edit distance lower bounds by analyzing the locations and contents of mismatching q -grams. A new algorithm, Ed-Join, is proposed that exploits the new mismatch-based filtering methods; it achieves substantial reduction of the candidate sizes and hence saves computation time. We demonstrate experimentally that the new algorithm outperforms alternative methods on large-scale real datasets under a wide range of parameter settings.Keywords
This publication has 19 references indexed in Scilit:
- Efficient similarity joins for near duplicate detection2008
- Inverted files for text search enginesACM Computing Surveys, 2006
- Adaptive name matching in information integrationIEEE Intelligent Systems, 2003
- Adaptive algorithms for set containment joinsACM Transactions on Database Systems, 2003
- Similarity estimation techniques from rounding algorithms2002
- A guided tour to approximate string matchingACM Computing Surveys, 2001
- A fast bit-vector algorithm for approximate string matching based on dynamic programmingJournal of the ACM, 1999
- Syntactic clustering of the WebComputer Networks and ISDN Systems, 1997
- A faster algorithm computing string edit distancesJournal of Computer and System Sciences, 1980
- The String-to-String Correction ProblemJournal of the ACM, 1974