US 11,748,320 B2
Detect duplicates with exact and fuzzy matching on encrypted match indexes
Alexandre Hersans, Walnut Creek, CA (US); Swaroop Shere, San Francisco, CA (US); Chenghung Ker, Burlingame, CA (US); Parth Vijay Vaishnav, Cupertion, CA (US); Assaf Ben-Gur, Livermore, CA (US); Victor Weilin Liu, San Francisco, CA (US); Daniel McGarry, San Francisco, CA (US); and Samatha Sanikommu, Dublin, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by salesforce.com, inc., San Francisco, CA (US)
Filed on Feb. 25, 2021, as Appl. No. 17/184,697.
Application 17/184,697 is a continuation of application No. 16/026,819, filed on Jul. 3, 2018, granted, now 10,942,906.
Claims priority of provisional application 62/678,812, filed on May 31, 2018.
Prior Publication US 2021/0182255 A1, Jun. 17, 2021
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/215 (2019.01); G06F 21/60 (2013.01); G06Q 30/01 (2023.01); G06F 16/22 (2019.01); G06F 16/23 (2019.01); G06F 16/2458 (2019.01)
CPC G06F 16/215 (2019.01) [G06F 16/2237 (2019.01); G06F 16/2365 (2019.01); G06F 16/2468 (2019.01); G06F 21/602 (2013.01); G06Q 30/01 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method, comprising:
receiving, by one more processors, a match rule from a user of a customer relationship management tool, wherein the match rule comprises a unique identifier, a table in the customer relationship management tool, and one or more fields of applicability; and
creating, by the one or more processors, a match index column in the table comprising encrypted match indexes using the unique identifier as an initialization vector in an encryption scheme, wherein the match index column is used when performing duplicate detection to determine if a new record duplicates an encrypted match index in the encrypted match indexes.