Anticipatory pre-execution of data queries
Embodiments of the invention provide for anticipatory pre-execution of queries. In an embodiment of the invention, a method for anticipatory pre-execution of queries includes the computation of an execution cost of each of a multiplicity of different queries to a data source scheduled at a specified time on a specified date. The method also includes monitoring a querying processing schedule and detecting from the monitoring, unscheduled time on a particular date prior to the specified time on the specified date. Finally, the method includes responding to the detection by first selecting a most expensive one of the different queries in terms of execution cost, for instance an amount of computing resources consumed in executing a corresponding one of the different queries, and then executing the selected most expensive one of the different queries during the unscheduled time on the particular date prior to the specified time on the specified date.
1. A method for anticipatory pre-execution of queries comprising:
computing an execution cost of each of a multiplicity of different queries to a data source scheduled at a specified time on a specified date;
monitoring a querying processing schedule;
detecting from the monitoring, unscheduled time on a particular date prior to the specified time on the specified date; and,
responding to the detection by selecting a most expensive one of the different queries in terms of execution cost and executing the selected most expensive one of the different queries during the unscheduled time on the particular date prior to the specified time on the specified date.
2. The method of claim 1 , further comprising:
filtering the different queries to include only queries not reliant upon underlying data anticipated to be updated after the unscheduled time on the particular date and before the specified time on the specified date.
3. The method of claim 1 , wherein the selecting comprising selecting not only a most expensive one of the different queries, but also one of the different queries least reliant upon a freshness of underlying data.
4. The method of claim 1 , wherein the monitoring detects repeated instances at the unscheduled time over several dates when no queries are scheduled, so as to detect the unscheduled time on the particular date prior to the specified time on the specified date.
5. The method of claim 1 , wherein the execution cost is an amount of computing resources consumed in executing a corresponding one of the different queries.
6. The method of claim 1 , further comprising selecting a manually specified one of the different queries in lieu of the most expensive one of the different queries for execution during the unscheduled time on the particular date prior to the specified time on the specified date.
7. A query scheduling data processing system configured for anticipatory pre-execution of queries comprising:
a host computing platform comprising one or more computers, each with memory and at least one processor;
a data source coupled to the host computing platform;
a query processor executing queries based upon data disposed in the data source; and
an anticipatory query pre-execution module comprising computer program instructions executing in the memory of the host computing platform, the instructions performing:
computing an execution cost of each of a multiplicity of different queries to the data source scheduled at a specified time on a specified date;
monitoring a querying processing schedule;
detecting from the monitoring, unscheduled time on a particular date prior to the specified time on the specified date; and,
responding to the detection by selecting a most expensive one of the different queries in terms of execution cost and directing the query processor to execute the selected most expensive one of the different queries during the unscheduled time on the particular date prior to the specified time on the specified date.
8. The system of claim 7 , wherein the program instructions further perform:
filtering the different queries to include only queries not reliant upon underlying data anticipated to be updated after the unscheduled time on the particular date and before the specified time on the specified date.
9. The system of claim 7 , wherein the selecting comprising selecting not only a most expensive one of the different queries, but also one of the different queries least reliant upon a freshness of underlying data.
10. The system of claim 7 , wherein the monitoring detects repeated instances at the unscheduled time over several dates when no queries are scheduled, so as to detect the unscheduled time on the particular date prior to the specified time on the specified date.
11. The system of claim 7 , wherein the execution cost is an amount of computing resources consumed in executing a corresponding one of the different queries.
12. The system of claim 7 , wherein the program instructions further perform selecting a manually specified one of the different queries in lieu of the most expensive one of the different queries for execution during the unscheduled time on the particular date prior to the specified time on the specified date.
13. A computer program product for anticipatory pre-execution of queries, the computer program product including a non-transitory computer readable storage medium having program instructions embodied therewith, the program instructions executable by a device to cause the device to perform a method including:
computing an execution cost of each of a multiplicity of different queries to a data source scheduled at a specified time on a specified date;
monitoring a querying processing schedule;
detecting from the monitoring, unscheduled time on a particular date prior to the specified time on the specified date; and,
responding to the detection by selecting a most expensive one of the different queries in terms of execution cost and executing the selected most expensive one of the different queries during the unscheduled time on the particular date prior to the specified time on the specified date.
14. The computer program product of claim 13 , wherein the method further includes:
filtering the different queries to include only queries not reliant upon underlying data anticipated to be updated after the unscheduled time on the particular date and before the specified time on the specified date.
15. The computer program product of claim 13 , wherein the selecting comprising selecting not only a most expensive one of the different queries, but also one of the different queries least reliant upon a freshness of underlying data.
16. The computer program product of claim 13 , wherein the monitoring detects repeated instances at the unscheduled time over several dates when no queries are scheduled, so as to detect the unscheduled time on the particular date prior to the specified time on the specified date.
17. The computer program product of claim 13 , wherein the execution cost is an amount of computing resources consumed in executing a corresponding one of the different queries.
18. The computer program product of claim 13 , wherein the method further includes selecting a manually specified one of the different queries in lieu of the most expensive one of the different queries for execution during the unscheduled time on the particular date prior to the specified time on the specified date.