Bitmap filter: Speeding up exact set similarity joins with bitwise operations

被引:2
作者
Sandes, Edans F. O. [1 ]
Teodoro, George L. M. [1 ,2 ]
Melo, Alba C. M. A. [1 ]
机构
[1] Univ Brasilia, Comp Sci Dept, BR-70910900 Brasilia, DF, Brazil
[2] Univ Fed Minas Gerais, Comp Sci Dept, BR-31270901 Belo Horizonte, MG, Brazil
关键词
Set similarity join; Query processing; Data mining;
D O I
10.1016/j.is.2019.101449
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
The Exact Set Similarity Join problem aims to find all similar sets between two collections of sets, with respect to a threshold and a similarity function such as Overlap, Jaccard, Dice or Cosine. The naive approach verifies all pairs of sets and it is often considered impractical due the high number of combinations. So, Exact Set Similarity Join algorithms are usually based on the Filter-Verification Framework, that applies a series of filters to reduce the number of verified pairs. This paper presents a new filtering technique called Bitmap Filter, which is able to accelerate state-of-the-art algorithms for the exact Set Similarity Join problem. The Bitmap Filter uses hash functions to create bitmaps of fixed b bits, representing characteristics of the sets. Then, it applies bitwise operations (such as xor and population count) on the bitmaps in order to infer a similarity upper bound for each pair of sets. If the upper bound is below a given similarity threshold, the pair of sets is pruned. The Bitmap Filter benefits from the fact that bitwise operations are efficiently implemented by many modern general-purpose processors and it was easily applied to four state-of-the-art algorithms implemented in CPU: AllPairs, PPJoin, AdaptJoin and GroupJoin. Furthermore, we propose a Graphic Processor Unit (GPU) algorithm based on the naive approach but using the Bitmap Filter to speedup the computation. The experiments considered 12 collections containing from 100 thousands up to 10 million sets and the joins were made using Jaccard thresholds from 0.50 to 0.95. The Bitmap Filter was able to improve 85% of the experiments in CPU, with speedups of up to 4.50x and 1.35x on average. Using the GPU algorithm, the experiments were able to speedup the original CPU algorithms by up to 577x using an Nvidia Geforce GTX 980 Ti. (C) 2019 Elsevier Ltd. All rights reserved.
引用
收藏
页数:14
相关论文
共 29 条
  • [1] [Anonymous], 2011, P 2011 ACM SIGMOD IN, DOI DOI 10.1145/1989323.1989428
  • [2] [Anonymous], 2006, Proceedings of the 32Nd International Conference on Very Large Data Bases
  • [3] Augsten N., 2013, SIMILARITY JOINS REL
  • [4] Bayardo R.J., 2007, Proceedings of the 16th international conference on World Wide Web, P131, DOI [10.1145/1242572.1242591, DOI 10.1145/1242572.1242591]
  • [5] Bouros P, 2012, PROC VLDB ENDOW, V6, P1
  • [6] Syntactic clustering of the Web
    Broder, AZ
    Glassman, SC
    Manasse, MS
    Zweig, G
    [J]. COMPUTER NETWORKS AND ISDN SYSTEMS, 1997, 29 (8-13): : 1157 - 1166
  • [7] Sequential Hypothesis Tests for Adaptive Locality Sensitive Hashing
    Chakrabarti, Aniket
    Parthasarathy, Srinivasan
    [J]. PROCEEDINGS OF THE 24TH INTERNATIONAL CONFERENCE ON WORLD WIDE WEB (WWW 2015), 2015, : 162 - 172
  • [8] Chaudhuri S., 2006, ICDE, P5, DOI [10.1109/ICDE.2006.9, DOI 10.1109/ICDE.2006.9]
  • [9] Data integration using similarity joins and a word-based information representation language
    Cohen, WW
    [J]. ACM TRANSACTIONS ON INFORMATION SYSTEMS, 2000, 18 (03) : 288 - 321
  • [10] Deng D, 2015, PROC VLDB ENDOW, V9, P360