US 11,675,760 B2
Detection of duplicate values during index generation
Arup Kumar Dutta, San Ramon, CA (US); and Jesse Collins, Oakland, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by salesforce.com, inc., San Francisco, CA (US)
Filed on Jan. 30, 2017, as Appl. No. 15/419,358.
Prior Publication US 2018/0218020 A1, Aug. 2, 2018
Int. Cl. G06F 16/22 (2019.01)
CPC G06F 16/22 (2019.01) 15 Claims
OG exemplary drawing
 
1. A non-transitory, computer-readable medium having program instructions stored thereon that are capable of causing a database system to perform operations comprising:
storing data for a plurality of fields in a data table, wherein a subset of the data is associated with a particular one of the plurality of fields;
receiving, from a user of the database system, a request to index the data table based on the particular field;
analyzing the subset of the data to create, for the data table, an index that indexes the subset of the data, wherein the data of the data table can be accessed via a set of pointers of the index, and wherein the index is separate from the data table; and
in response to determining, based on the analyzing, that one or more duplicates of a particular value are present in the subset of the data:
storing the subset of the data, including the one or more duplicates of the particular value, in the index;
setting, in the index for a particular duplicate of the one or more duplicates, a flag to indicate that the particular duplicate is a duplicate value for the particular field; and
returning a response to the request to index that includes a user interface that is operable to display the one or more duplicates and enable the user associated with the request to make the one or more duplicates unique after having been stored in the index;
receiving a record request to retrieve a record from the data table based on a first lookup value;
in response to determining that the first lookup value corresponds to the one or more duplicates stored in the index, providing a notification that the record request cannot be serviced; and
providing, via the user interface, a suggestion of a modification to at least one of the one or more duplicates to cause the at least one duplicate to have a unique value.