Lazo: A Cardinality-Based Method for Coupled Estimation of Jaccard Similarity and Containment

© 2019 IEEE. Data analysts often need to find datasets that are similar (i.e., have high overlap) or that are subsets of one another (i.e., one contains the other). Exactly computing such relationships is expensive because it entails an all-pairs comparison between all values in all datasets, an O(n...

Full description

Bibliographic Details
Main Authors: Castro Fernandez, Raul (Author), Min, Jisoo (Author), Nava, Demitri (Author), Madden, Samuel (Author)
Format: Article
Language:English
Published: Institute of Electrical and Electronics Engineers (IEEE), 2022-07-15T15:54:09Z.
Subjects:
Online Access:Get fulltext
LEADER 02275 am a22001933u 4500
001 143769
042 |a dc 
100 1 0 |a Castro Fernandez, Raul  |e author 
700 1 0 |a Min, Jisoo  |e author 
700 1 0 |a Nava, Demitri  |e author 
700 1 0 |a Madden, Samuel  |e author 
245 0 0 |a Lazo: A Cardinality-Based Method for Coupled Estimation of Jaccard Similarity and Containment 
260 |b Institute of Electrical and Electronics Engineers (IEEE),   |c 2022-07-15T15:54:09Z. 
856 |z Get fulltext  |u https://hdl.handle.net/1721.1/143769 
520 |a © 2019 IEEE. Data analysts often need to find datasets that are similar (i.e., have high overlap) or that are subsets of one another (i.e., one contains the other). Exactly computing such relationships is expensive because it entails an all-pairs comparison between all values in all datasets, an O(n2) operation. Fortunately, it is possible to obtain approximate solutions much faster, using locality sensitive hashing (LSH). Unfortunately, LSH does not lend itself naturally to compute containment, and only returns results with a similarity beyond a pre-defined threshold; we want to know the specific similarity and containment score. The main contribution of this paper is LAZO, a method to simultaneously estimate both the similarity and containment of datasets, based on a redefinition of Jaccard similarity which takes into account the cardinality of each set. In addition, we show how to use the method to improve the quality of the original JS and JC estimates. Last, we implement LAZO as a new indexing structure that has these additional properties: i) it returns numerical scores to indicate the degree of similarity and containment between each candidate and the query - instead of only returning the candidate set; ii) it permits to query for a specific threshold on-the-fly, as opposed to LSH indexes that need to be configured with a pre-defined threshold a priori; iii) it works in a data-oblivious way, so it can be incrementally maintained. We evaluate LAZO on real-world datasets and show its ability to estimate containment and similarity better and faster than existing methods. 
546 |a en 
655 7 |a Article 
773 |t 10.1109/ICDE.2019.00109 
773 |t Proceedings - International Conference on Data Engineering