Pattern recognition in application database queries with scheduled pre-cached data retrieval

A computing system comprising:

• one or more processors;
• and
• one or more memories storing instructions that, when executed by the one or more processors, causes the one or more processors to perform operations comprising:
• receiving a plurality of data queries from one or more query sources directed to a target database, wherein each data query of the plurality of data queries comprises a plurality of parameters, wherein at least one parameter of the plurality of parameters comprises a temporal range to retrieve data corresponding to a specific period;
• in response to the receiving of the plurality of data queries:
• storing a copy of each data query of the plurality of data queries in a data store of the computing system;
• identifying, using pattern recognition logic executed on the computing system and the plurality of parameters, a query pattern in the copies of the plurality of data queries in the data store;
• creating a scheduled task for the query pattern to retrieve pre-retrieved data from the target database;
• retrieving, using the scheduled task, the pre-retrieved data from the target database and storing the pre-retrieved data in a cache;
• receiving a subsequent data query from a query source after the retrieving the pre-retrieved data;
• determining that the subsequent data query matches the query pattern;
• retrieving the pre-retrieved data corresponding to the subsequent data query from the cache;
• and
• sending the pre-retrieved data corresponding to the subsequent data query to the query source.

A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, cause the one or more processors to perform operations comprising:

• receiving a plurality of data queries from one or more query sources directed to a target database, wherein each data query of the plurality of data queries comprises a plurality of parameters, wherein at least one parameter of the plurality of parameters comprises a temporal range to retrieve data corresponding to a specific period;
• in response to the receiving of the plurality of data queries:
• storing a copy of each data query of the plurality of data queries in a data store;
• identifying, using pattern recognition logic and the plurality of parameters, a query pattern in the copies of the plurality of data queries in the data store;
• creating a scheduled task for the query pattern to retrieve pre-retrieved data from the target database;
• retrieving, using the scheduled task, the pre-retrieved data from the target database and storing the pre-retrieved data in a cache;
• receiving a subsequent data query from a query source after the retrieving the pre-retrieved data;
• determining that the subsequent data query matches the query pattern;
• retrieving the pre-retrieved data corresponding to the subsequent data query from the cache;
• and
• sending the pre-retrieved data corresponding to the subsequent data query to the query source.