Systems and methods for generating dynamic instructions for database querying and data retrieval

Patent metadata

Field	Value
Publication number	US-11868342-B2
Application number	US-202117362573-A
Country	US
Kind code	B2
Filing date	Jun 29, 2021
Priority date	Jun 29, 2021
Publication date	Jan 9, 2024
Grant date	Jan 9, 2024

Abstract

A data retrieval system can include a computing device that is configured to, in response to receiving a uniform resource locator from a user device, parse the uniform resource locator to identify a dynamic path variable. The computing device can be configured to generate a set of execution steps based on the received uniform resource locator. The computing device can also be configured to execute the set of execution steps to retrieve a set of data, the set of execution steps being executed based on the dynamic path variable in response to the dynamic path variable being identified. The computing device can further be configured to transform a user interface of the user device based on the set of data.

First claim

What is claimed is:

1. A system, comprising:
a database comprising at least one data retrieval model; and
a computing device configured to:
receive a request to generate a uniform resource locator, wherein the request identifies the at least one data retrieval model;
obtain a set of instructions for generating a set of execution steps including implementation of the at least one data retrieval model;
store the set of instructions in a database;
associate a first uniform resource locator with the set of instructions;
receive a second uniform resource locator from a user device, wherein the second uniform resource locator includes at least a portion of the first uniform resource locator and a dynamic path variable;
parse the second uniform resource locator to identify the dynamic path variable;
obtain the set of instructions from the database based on the first uniform resource locator;
generate the set of execution steps based on the set of instructions, wherein the set of execution steps is modified based on the dynamic path variable;
execute the set of execution steps to retrieve a set of data; and
transmit the set of data to the user device, wherein the user device is configured, in response to receiving the set of data, to store the set of data in local memory and transform a user interface of the user device based on the set of data.

2. The system of claim 1 , wherein the at least one data retrieval model comprises a first data retrieval model and a second data retrieval model, and wherein the computing device is configured to:
determine the first data retrieval model is independent of the second data retrieval model; and
generate a first set of execution steps corresponding to the first data retrieval model and a second set of execution steps corresponding to the second data retrieval model, wherein the first set of execution steps and the second set of execution steps are executed in parallel.

3. The system of claim 1 , wherein the set of instructions includes input from the user device indicating: at least one database, a query string variable, a header value variable, or a request payload variable.

4. The system of claim 1 , wherein:
the set of instructions indicate data to retrieve from at least one database, and
the at least one data retrieval model indicates a location of the set of data to retrieve.

5. The system of claim 1 , wherein the set of instructions include a predetermined set of instructions stored in the database.

6. The system of claim 1 , wherein the user device is configured to store the set of data for a threshold period.

7. A method comprising:
receiving a request to generate a uniform resource locator, wherein the request identifies at least one data retrieval model;
obtaining a set of instructions for generating a set of execution steps including implementation of the at least one data retrieval model;
storing the set of instructions in a database;
associating a first uniform resource locator with the set of instructions;
receiving a second uniform resource locator from a user device, wherein the second uniform resource locator includes at least a portion of the first uniform resource locator and a dynamic path variable;
parsing the second uniform resource locator to identify the dynamic path variable;
obtaining the set of instructions from the database based on the first uniform resource locator;
generating the set of execution steps based on the set of instructions, wherein the set of execution steps is modified based on the dynamic path variable;
executing the set of execution steps to retrieve a set of data; and
transmitting the set of data to the user device, wherein the user device is configured, in response to receiving the set of data, to store the set of data in local memory and transform a user interface of the user device based on the set of data.

8. The method of claim 7 , wherein the at least one data retrieval model comprises a first data retrieval model and a second data retrieval model, the method further comprising:
determining the first data retrieval model is independent of the second data retrieval model; and
generating a first set of execution steps corresponding to the first data retrieval model and a second set of execution steps corresponding to the second data retrieval model, wherein the first set of execution steps and the second set of execution steps are executed in parallel.

9. The method of claim 7 , wherein the set of instructions includes input from the user device indicating: at least one database, a query string variable, a header value variable, or a request payload variable.

10. The method of claim 7 , wherein:
the set of instructions indicate data to retrieve from at least one database, and
the at least one data retrieval model indicates a location of the set of data to retrieve.

11. The method of claim 7 , wherein the set of instructions include a predetermined set of instructions stored in the database.

12. The method of claim 7 , wherein the user device stores the set of data for a threshold period.

13. 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 request to generate a uniform resource locator, wherein the request identifies at least one data retrieval model;
obtaining a set of instructions for generating a set of execution steps including implementation of the at least one data retrieval model;
storing the set of instructions in a database;
associating a first uniform resource locator with the set of instructions;
receiving second uniform resource locator from a user device, wherein the second uniform resource locator includes at least a portion of the first uniform resource locator and a dynamic path variable;
parsing the second uniform resource locator to identify the dynamic path variable;
obtaining the set of instructions from the database based on the first uniform resource locator;
generating the set of execution steps based on the set of instructions, wherein the set of execution steps is modified based on the dynamic path variable;
executing the set of execution steps to retrieve a set of data; and
transmitting the set of data to the user device, wherein the user device is configured, in response to receiving the set of data, to store the set of data in local memory and transform a user interface of the user device based on the set of data.

14. The non-transitory computer readable medium of claim 13 , wherein the at least one data retrieval model comprises a first data retrieval model and a second data retrieval model, and wherein the instructions cause the device to perform operations comprising:
determining the first data retrieval model is independent of the second data retrieval model; and
generating a first set of execution steps corresponding to the first data retrieval model and a second set of execution steps corresponding to the second data retrieval model, wherein the first set of execution steps and the second set of execution steps are executed in parallel.

15. The non-transitory computer readable medium of claim 13 , wherein the set of instructions includes input from the user device indicating: at least one database, a query string variable, a header value variable, or a request payload variable.

16. The non-transitory computer readable medium of claim 13 , wherein:
the set of instructions indicate data to retrieve from at least one database, and
the at least one data retrieval model

Assignees

• Walmart Apollo Llc

Inventors

• Vanderpool Clifford Virgil
• Ponnusamy Aroon
• Lane Bryant Matthew

Classifications

• G06F16/245 Primary

  Query processing · CPC title

• G06F16/248

  Presentation of query results · CPC title

• G06F16/955

  using information identifiers, e.g. uniform resource locators [URL] · CPC title