DYNAMICALLY SUBSTITUTING A MODIFIED QUERY BASED ON PERFORMANCE ANALYSIS
The disclosure herein describes analyzing queries and dynamically modifying those queries based on the analysis. An indication that a query is to be executed by a first process is detected. It is determined that an analysis results data store does not include an active analysis result for the query using a query identifier of the query and, as a result, a modified instance of the query is generated using a modification pattern. The query and the modified instance of the query are analyzed based on a performance metric using a second process that is independent of the first process. An active analysis result of the query is recorded based on the analysis, wherein the analysis result indicates whether future executions of the query should be modified using the modification pattern. Further, in some examples, analysis results expire, such that associated queries are reanalyzed to generate active analysis results periodically.
1 . (canceled)
2 . A system comprising:
one or more computing devices designed to store Structured Query Language (SQL) queries, the one or more computing devices being independent from a kernel for executing the SQL queries, wherein the one or more computing devices are configured to perform the following operations:
determining an execution performance of the SQL query associated with an initial execution of the SQL query by the kernel during a primary process;
generating a modified instance of the SQL query using a modification pattern;
executing the modified instance of the SQL query during a background process that is independent from the primary process, wherein execution of the modified instance of the SQL query during the background process does not interrupt the primary process;
comparing the execution performance of the SQL query with an execution performance of the modified instance of the SQL query to obtain an active analysis result for the SQL query, wherein the active analysis result for the SQL query indicates that future executions of the SQL query during the primary process should be modified using the modification pattern; and
recording the active analysis result for the SQL query in an analysis results data store, wherein recording the active analysis result in the analysis results data store prompts the kernel to modify the SQL query using the modification pattern when performing a future execution of the SQL query during the primary process.
3 . The system of claim 2 , wherein the active analysis result recorded in the analysis results data store includes an expiration time.
4 . The system of claim 3 , wherein the expiration time is defined based at least in part on an active result time interval, and wherein the active analysis result becomes inactive at the expiration time.
5 . The system of claim 2 , wherein the analysis results data store is associated with a customer entity associated with the SQL query to be executed, such that all analysis results in the analysis results data store are associated with the customer entity.
6 . The system of claim 2 , wherein the execution performance of the SQL query corresponds to a quantity of time taken to complete execution of the SQL query by the primary process.
7 . The system of claim 6 , wherein the execution performance of the modified instance of the SQL query corresponds to a quantity of time taken to complete execution of the modified instance of the SQL query by the background process.
8 . The system of claim 2 , wherein the modification pattern includes adding a statement to the SQL query to limit a quantity of results generated by the SQL query.
9 . A method comprising:
determining, by one or more computing devices designed to store structured Query Language (SQL) queries, an execution performance of an SQL query by a kernel during a primary process, the kernel configured to execute the SQL queries stored by the one or more computing devices, wherein the one or more computing devices are independent from the kernel;
generating, by the one or more computing devices, a modified instance of the SQL query using a modification pattern;
executing, by the one or more computing devices, the modified instance of the SQL query during a background process that is independent from the primary process, wherein execution of the modified instance of the SQL query during the background process does not interrupt the primary process;
comparing, by the one or more computing devices, the execution performance of the SQL query with an execution performance of the modified instance of the SQL query to obtain an active analysis result for the SQL query, wherein the active analysis result for the SQL query indicates that future executions of the SQL query during the primary process should be modified using the modification pattern; and
recording, by the one or more computing devices, the active analysis result for the SQL query in an analysis results data store, wherein recording the active analysis result in the analysis results data store prompts the kernel to modify the SQL query using the modification pattern when performing a future execution of the SQL query during the primary process.
10 . The method of claim 9 , wherein the active analysis result recorded in the analysis results data store includes an expiration time.
11 . The method of claim 10 , wherein the expiration time is defined based at least in part on an active result time interval, and wherein the active analysis result becomes inactive at the expiration time.
12 . The method of claim 9 , wherein the analysis results data store is associated with a customer entity associated with the SQL query to be executed, such that all analysis results in the analysis results data store are associated with the customer entity.
13 . The method of claim 9 , wherein the execution performance of the SQL query corresponds to a quantity of time taken to complete execution of the SQL query by the primary process.
14 . The method of claim 13 , wherein the execution performance of the modified instance of the SQL query corresponds to a quantity of time taken to complete execution of the modified instance of the SQL query by the background process.
15 . The method of claim 9 , wherein the modification pattern includes adding a statement to the SQL query to limit a quantity of results generated by the SQL query.
16 . A computer program product storing programming instructions for execution by a processor of a system, the programming instructions, upon execution by the processor, causing the system to perform the following operations:
determining, by one or more computing devices designed to store structured Query Language (SQL) queries, an execution performance of an SQL query by a kernel during a primary process, the kernel configured to execute the SQL queries stored by the one or more computing devices, wherein the one or more computing devices are independent from the kernel;
generating, by the one or more computing devices, a modified instance of the SQL query using a modification pattern;
executing, by the one or more computing devices, the modified instance of the SQL query during a background process that is independent from the primary process, wherein execution of the modified instance of the SQL query during the background process does not interrupt the primary process;
comparing, by the one or more computing devices, the execution performance of the SQL query with an execution performance of the modified instance of the SQL query to obtain an active analysis result for the SQL query, wherein the active analysis result for the SQL query indicates that future executions of the SQL query during the primary process should be modified using the modification pattern; and
recording, by the one or more computing devices, the active analysis result for the SQL query in an analysis results data store, wherein recording the active analysis result in the analysis results data store prompts the kernel to modify the SQL query using the modification pattern when performing a future execution of the SQL query during the primary process.
17 . The computer program product of claim 16 , wherein the active analysis result recorded in the analysis results data store includes an expiration time.
18 . The computer program product of claim 17 , wherein the expiration time is defined based at least in part on an active result time interval, and wherein the active analysis result becomes inactive at the expiration time.
19 . The computer program product of claim 16 , wherein the analysis results data store is associated with a customer entity associated with the SQL query to be executed, such that all analysis results in the analysis results data store are associated with the customer entity.
20 . The computer program product of claim 16 , wherein the execution performance of the SQL query corresponds to a quantity of time taken to complete execution of the SQL query by the primary process.
21 . The computer program product of claim 16 , wherein the execution performance of the modified instance of the SQL query corresponds to a quantity of time taken to complete execution of the modified instance of the SQL query by the background process.