Patent ID: 11960466
Assignee: WALMART APOLLO, LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 8:
9. A computer-implemented method comprising:
receiving a first set of attributes for an item;
in response to receiving the first set of attributes, generating a first surrogate key and a first super surrogate key based on the first attributes, wherein the first surrogate key is generated by concatenating a first subset of the first attributes and a first value of a first non-attribute feature, wherein the first super surrogate key is generated by concatenating a second subset of the first attributes and a current indicator;
generating a first record within a first table comprising a surrogate key value equal to the first surrogate key and a super surrogate key value equal to the first super surrogate key;
joining the first table to a second table based on at least one natural key;
receiving a second set of attributes for the item, wherein at least one attribute of the second set of attributes is different than the first set of attributes;
in response to receiving the second set of attributes, generating a second surrogate key for the item based on the second attributes, wherein the second surrogate key is generated by concatenating a first subset of the second set of attributes and a second non-attribute value, wherein the first non-attribute value and the second non-attribute value are different;
generating a second record within the first table comprising a surrogate key value equal to the second surrogate key and a super surrogate key value equal to the first super surrogate key; and
in response to generating the second record, adjusting the first super surrogate key value of the first record to a value other than the first super surrogate key.