US 11,960,466 B2Granted

Methods and apparatus for data and data request management

AssigneeWalmart Apollo, LLC

InventorsSivakumar Subramanian, Deekkan Kannan, Hari Sai Gangadhar V, Joyan Sil

Life of this patent

Estimating the term…

Loading patent…

Abstract

This application relates to automatic processes that service data requests for information related to an item during varying temporal periods. For example, a computing device receives first attributes for an item, and generates a first surrogate key and a first super surrogate key based on the first attributes. Further, the computing device generates a first entry within a first table that includes the first surrogate key and the first super surrogate key. The computing device joins the first table to a second table based on natural keys. The computing device also receives second attributes for the item, and generates a second surrogate key for the item based on the second attributes. Further, the computing device generates a second entry within the first table that includes the second surrogate key and the first super surrogate key. The computing device also adjusts the first super surrogate key within the first entry.

Claims20

Dependent claims

A system comprising:

a database comprising a dimension table and a fact table, wherein the dimension table includes records having one or more attributes, a surrogate key, and a super surrogate key;
a processor configured to:
receive first set of attributes for an item;
in response to receiving the first set of attributes, generate 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;
generate a first record within the dimension 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;
join the dimension table to the fact table based on at least one natural key;
receive 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, generate 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;
generate a second record within the dimension 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, adjust the first super surrogate key value of the first record to a value other than the first super surrogate key.

8 more elements

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.

6 more elements

A non-transitory computer readable medium having instructions stored thereon, wherein the instructions, when executed by at least one processor, cause a device to perform operations 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.

6 more elements

Dependencies are inferred from the claim text.