Methods and apparatus for data and data request management

Patent metadata

Field	Value
Publication number	US-2023418804-A1
Application number	US-202217815683-A
Country	US
Kind code	A1
Filing date	Jul 28, 2022
Priority date	Jun 22, 2022
Publication date	Dec 28, 2023
Grant date	—

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.

First claim

1 . 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.

2 . The system of claim 1 , wherein the processor is configured to:
receive a data request comprising a key; retrieve at least one entry from the table using the key; and transmit, in response to the data request, at least a portion of the at least one entry.

3 . (canceled)

4 . The system of claim 2 wherein the processor is configured to:
when the key is the first super surrogate key, retrieve a first entry associated with the first surrogate key and a second entry associated with the second surrogate key from the fact table, wherein the first entry and the second entry are retrieved based on the first super surrogate key; and
transmit, in response to the data request, at least a portion of each of the first entry and the second entry.

5 . The system of claim 2 wherein the processor is configured to:
when the key is the first surrogate key, retrieve a first entry associated with the first surrogate key from the fact table; and
transmit, in response to the data request, at least a portion of the first entry.

6 . The system of claim 5 wherein the processor is configured to:
when the key is the second surrogate key, retrieve a second entry associated with the second surrogate key from the fact table; and
transmit, in response to the data request, at least a portion of the second entry.

7 . The system of claim 1 , wherein the processor is configured to adjust the first super surrogate key value of the first record to a default value.

8 . The system of claim 1 , wherein the processor is configured to:
adjust a current indicator value of the first record to indicate the first record is not a current record; and adjust a current indicator value of the second record to indicate the second record is the current record.

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.

10 . The computer-implemented method of claim 9 , comprising:
receiving a data request comprising a key; retrieving at least one entry from the second table using the key; and transmitting in response to the data request, at least a portion of the at least one entry.

11 . (canceled)

12 . The method of claim 10 , comprising:
when the key is the first super surrogate key, retrieving a first entry associated with the first surrogate key and a second entry associated with the second surrogate key from the second table, wherein the first entry and the second entry are retrieved based on the first super surrogate key; and transmitting, in response to the data request, at least a portion of each of the first entry and the second entry.

13 . The method of claim 10 , comprising:
when the key is the first surrogate key, retrieving a first entry associated with the first surrogate key from the second table; and transmitting, in response to the data request, at least a portion of the first entry.

14 . The method of claim 13 , comprising:
when the key is the second surrogate key, retrieving a second entry associated with the second surrogate key from the second table; and transmitting, in response to the data request, at least a portion of the second entry.

15 . The method of claim 9 , comprising adjusting the first super surrogate key value of the first record to a default value.

16 . The method of claim 9 , comprising:
adjusting a current indicator value of the first record to indicate the first record is not a current record; and adjusting a current indicator value of the second record to indicate the second record is the current record.

17 . 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 concat

Assignees

• Walmart Apollo Llc

Inventors

• Subramanian Sivakumar
• Kannan Deekkan
• Sai Gangadhar V Hari
• Sil Joyan

Classifications

• G06F16/235 Primary

  Update request formulation · CPC title

• G06F16/2456

  Join operations · CPC title

• G06F16/2282 Primary

  Tablespace storage structures; Management thereof · CPC title