ApproxJoin: Approximate Matching for Efficient Verification in Fuzzy Set Similarity Join

Fuente: arXiv
Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Mandulak, Michael, Ferdous, S M, Ghosh, Sayan, Halappanavar, Mahantesh, Slota, George
Format: Preprint
Veröffentlicht: 2025
Schlagworte:
Online-Zugang:
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
_version_ 1866915408915726336
author Mandulak, Michael
Ferdous, S M
Ghosh, Sayan
Halappanavar, Mahantesh
Slota, George
author_facet Mandulak, Michael
Ferdous, S M
Ghosh, Sayan
Halappanavar, Mahantesh
Slota, George
contents The set similarity join problem is a fundamental problem in data processing and discovery, relying on exact similarity measures between sets. In the presence of alterations, such as misspellings on string data, the fuzzy set similarity join problem instead approximately matches pairs of elements based on the maximum weighted matching of the bipartite graph representation of sets. State-of-the-art methods within this domain improve performance through efficient filtering methods within the filter-verify framework, primarily to offset high verification costs induced by the usage of the Hungarian algorithm - an optimal matching method. Instead, we directly target the verification process to assess the efficacy of more efficient matching methods within candidate pair pruning. We present ApproxJoin, the first work of its kind in applying approximate maximum weight matching algorithms for computationally expensive fuzzy set similarity join verification. We comprehensively test the performance of three approximate matching methods: the Greedy, Locally Dominant and Paz Schwartzman methods, and compare with the state-of-the-art approach using exact matching. Our experimental results show that ApproxJoin yields performance improvements of 2-19x the state-of-the-art with high accuracy (99% recall).
format Preprint
id arxiv_https___arxiv_org_abs_2507_18891
institution arXiv
publishDate 2025
record_format arxiv
spellingShingle ApproxJoin: Approximate Matching for Efficient Verification in Fuzzy Set Similarity Join
Mandulak, Michael
Ferdous, S M
Ghosh, Sayan
Halappanavar, Mahantesh
Slota, George
Databases
The set similarity join problem is a fundamental problem in data processing and discovery, relying on exact similarity measures between sets. In the presence of alterations, such as misspellings on string data, the fuzzy set similarity join problem instead approximately matches pairs of elements based on the maximum weighted matching of the bipartite graph representation of sets. State-of-the-art methods within this domain improve performance through efficient filtering methods within the filter-verify framework, primarily to offset high verification costs induced by the usage of the Hungarian algorithm - an optimal matching method. Instead, we directly target the verification process to assess the efficacy of more efficient matching methods within candidate pair pruning. We present ApproxJoin, the first work of its kind in applying approximate maximum weight matching algorithms for computationally expensive fuzzy set similarity join verification. We comprehensively test the performance of three approximate matching methods: the Greedy, Locally Dominant and Paz Schwartzman methods, and compare with the state-of-the-art approach using exact matching. Our experimental results show that ApproxJoin yields performance improvements of 2-19x the state-of-the-art with high accuracy (99% recall).
title ApproxJoin: Approximate Matching for Efficient Verification in Fuzzy Set Similarity Join
topic Databases
url https://arxiv.org/abs/2507.18891