Methods and apparatus for data and data request management
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.
1. A system comprising:
a database;
a processor; and
a non-transitory memory storing instructions that, when executed, cause the processor to:
receive a first set of attributes for an item;
generate a first surrogate key by concatenating a first plurality of the first set of attributes and a first non-attribute value;
generate a first super surrogate key by concatenating a second plurality of the first set of attributes and a current indicator;
generate a first record in the database comprising the first surrogate key and the first super surrogate key;
receive a second set of attributes for the item;
generate a second surrogate key by concatenating a first plurality of the second set of attributes and a second non-attribute value;
generate a second record in the database comprising the second surrogate key and the first super surrogate key;
in response to generating the second record, overwrite the first super surrogate key of the first record with a value other than the first super surrogate key, wherein the first super surrogate key is overwritten by setting the first super surrogate key to a different value; and
receive a data request comprising a key;
wherein when the key is the first super surrogate key, retrieve either the first record or the second record based on when the data request is received, wherein:
the first record is retrieved when the data request is received before the second record is generated and when a current indicator value of the first record indicates the first record is a current record; and
the second record is retrieved when the data request is received after the second record is generated, and after the first super surrogate key is overwritten, and when a current indicator value of the second record indicates the second record is a current record.
2. The system of claim 1 , wherein the instructions cause the processor to:
when the key is the first surrogate key, retrieve the first record from the database; and
transmit, in response to the data request, at least a portion of the first record.
3. The system of claim 2 , wherein the instructions cause the processor to:
when the key is the second surrogate key, retrieve the second record from the database; and
transmit, in response to the data request, at least a portion of the second entry.
4. The system of claim 1 , wherein the instructions cause the processor to adjust the first super surrogate key value of the first record to a default value.
5. A computer-implemented method, comprising:
receiving a first set of attributes for an item;
generating a first surrogate key by concatenating a first plurality of the first set of attributes and a first non-attribute value;
generating a first super surrogate key by concatenating a second plurality of the first set of attributes and a current indicator;
generating a first record in a database comprising the first surrogate key and the first super surrogate key;
receiving second set of attributes for the item;
generating a second surrogate key by concatenating a first plurality of the second set of attributes and a second non-attribute value;
generating a second record in the database comprising the second surrogate key and the first super surrogate key;
in response to generating the second record, overwriting the first super surrogate key of the first record with a value other than the first super surrogate key, wherein the first super surrogate key is overwritten by setting the first super surrogate key to a different value; and
receiving a data request comprising a key;
wherein when the key is the first super surrogate key, retrieve either the first record or the second record based on when the data request is received, wherein:
the first record is retrieved when the data request is received before the second record is generated and when a current indicator value of the first record indicates the first record is a current record; and
the second record is retrieved when the data request is received after the second record is generated, and after the first super surrogate key is overwritten, and when a current indicator value of the second record indicates the second record is a current record.
6. The computer-implemented method of claim 5 , comprising:
when the key is the first surrogate key, retrieving a first entry associated with the first record from the database; and
transmitting, in response to the data request, at least a portion of the first record.
7. The computer-implemented method of claim 6 , comprising:
when the key is the second surrogate key, retrieving the second record from the database; and
transmitting, in response to the data request, at least a portion of the second record.
8. The computer-implemented method of claim 5 , comprising adjusting the first super surrogate key value of the first record to a default value.
9. A non-transitory computer readable medium having instructions stored thereon that, when executed by at least one processor, cause at least one device to perform operations comprising:
receiving a first set of attributes for an item;
generating a first surrogate key by concatenating a first plurality of the first set of attributes and a first non-attribute value;
generating a first super surrogate key by concatenating a second plurality of the first set of attributes and a current indicator;
generating a first record in a database comprising the first surrogate key and the first super surrogate key;
receiving second set of attributes for the item;
generating a second surrogate key by concatenating a first plurality of the second set of attributes and a second non-attribute value;
generating a second record in the database comprising the second surrogate key and the first super surrogate key;
in response to generating the second record, overwriting the first super surrogate key of the first record with a value other than the first super surrogate key, wherein the first super surrogate key is overwritten by setting the first super surrogate key to a different value; and
receiving a data request comprising a key;
wherein when the key is the first super surrogate key, retrieve either the first record or the second record based on when the data request is received, wherein:
the first record is retrieved when the data request is received before the second record is generated and when a current indicator value of the first record indicates the first record is a current record; and
the second record is retrieved when the data request is received after the second record is generated, and after the first super surrogate key is overwritten, and when a current indicator value of the second record indicates the second record is a current record.
10. The non-transitory computer readable medium of claim 9 , wherein the instructions cause the device to perform operations comprising:
when the key is the first surrogate key:
retrieving the first record from the database; and
transmitting, in response to the data request, at least a portion of the first record; and
when the key is the second surrogate key:
retrieving the second record from the database; and
transmitting, in response to the data request, at least a portion of the second record.
11. The non-transitory computer readable medium of claim 9 , wherein the instructions cause the device to perform operations comprising adjusting the first super surrogate key value of the first record to a default value.