IssueRaiser

You're indeed correct as this is built upon bloom filters and standard bloom filters don't support deletion[1].

You're indeed correct as this is built upon bloom filters and standard bloom filters don't support deletion[1]. You could reconstruct the bloom filter minus the deleted element from each of the individual relations but then you'd need the relation table. The other substantial issue with the proposed scheme is false positives. In this situation, you have no way to ensure that a given relation is not an accidental match. For that you would again need the relations table. What's fun about this story is that the author has inadvertently re-discovered the bloom join[2] - he's just missing one of the important steps. Traditionally bloom filters are used for a fast, initial check which is then followed by a full check to remove false positives. [1]: There are some modifications to bloom filters that support deletion but they're all more complex than bitstrings. [2]: http://www.databasejournal.com/features/oracle/oracle-bloom-...

Posted by Smerity on May 2, 2015, 1:49 AM

Tags

Related issues

Raise real-world problems, find people facing the same issue, and discuss solutions.7,000 issues0 comments

support (Other)

You're indeed correct as this is built upon bloom filters and standard bloom filters don't support deletion[1].

SmerityMay 2, 2015, 1:49 AM

You're indeed correct as this is built upon bloom filters and standard bloom filters don't support deletion[1]. You could reconstruct the bloom filter minus the deleted element from each of the individual relations but then you'd need the relation table. The other substantial issue with the proposed scheme is false positives. In this situation, you have no way to ensure that a given relation is not an accidental match. For that you would again need the relations table. What's fun about this story is that the author has inadvertently re-discovered the bloom join[2] - he's just missing one of the important steps. Traditionally bloom filters are used for a fast, initial check which is then followed by a full check to remove false positives. [1]: There are some modifications to bloom filters that support deletion but they're all more complex than bitstrings. [2]: http://www.databasejournal.com/features/oracle/oracle-bloom-...

Comments (0)

No comments yet. Start the discussion.

Comment on this issue