Incremental data query performance feedback model

Abstract

Methods, systems and articles of manufacture are provided for query evaluation. The query is evaluated upon inputting each incremental query element (or combination of element). Generally, for each incremental query element added, a query performance analysis is performed with respect to one or more runtime metrics such as total execution time and runtime resource consumption. The results of the analysis are provided as feedback to the user constructing the query.

1 . A computer-implemented method of providing one or more query runtime metrics to a user, comprising: 
 receiving incremental inputs for the construction of a query;    determining whether a query runtime threshold has been exceeded upon receiving each incremental input and prior to receiving a request to execute the query; and    if the query runtime threshold has been exceeded, notifying the user.    
   
   
       2 . The method of  claim 1 , wherein determining whether the query runtime threshold has been exceeded comprises invoking a query governor.  
   
   
       3 . The method of  claim 1 , wherein receiving inputs comprises receiving query conditions.  
   
   
       4 . A computer-implemented method of providing real time query analysis feedback to a user, comprising: 
 incrementally receiving inputs for the construction of a query; and    upon receiving each incremental input, and prior to receiving a request to execute the query: 
 automatically performing a query runtime analysis with respect to one or more runtime metrics; and  
 providing feedback of the query runtime analysis to the user.  
   
   
   
       5 . The method of  claim 4 , wherein providing feedback comprises indicating an estimated cost of executing the query.  
   
   
       6 . The method of  claim 4 , wherein providing feedback comprises indicating at least one of a total execution time for the query and a resource consumption indication for the query.  
   
   
       7 . The method of  claim 4 , wherein providing feedback comprises displaying the feedback in a graphical user interface.  
   
   
       8 . A computer readable storage medium containing a program which, when executed, performs an automatic operation, comprising: 
 upon receiving each incremental input for the construction of a query and prior to receiving a request to execute the query: 
 performing a query runtime analysis with respect to one or more runtime metrics; and  
 providing feedback of the query runtime analysis to the user; wherein the feedback indicates the runtime effect of the input.  
   
   
   
       9 . The computer readable storage medium of  claim 8 , wherein the feedback comprises at least one of a total execution time for the query and a resource consumption indication for the query.  
   
   
       10 . The computer readable storage medium of  claim 8 , wherein the feedback comprises an estimated cost of executing the query.  
   
   
       11 . The computer readable storage medium of  claim 8 , wherein providing feedback comprises displaying the feedback in a graphical user interface.  
   
   
       12 . A computer comprising a processing unit, an input device, and an output device, the computer further comprising: 
 a user interface for inputting query elements for the construction of a query; wherein the query elements are received from a user via the input device and the user interface is rendered on the output device; and    a query evaluator for iteratively performing a runtime analysis upon receiving each query element and providing feedback to the user via the output device after each interactive performance of the runtime analysis, wherein the feedback comprises one or more metrics calculated by the runtime analysis.    
   
   
       13 . The computer of  claim 12 , wherein the one or more metrics are query execution cost metrics.  
   
   
       14 . The computer of  claim 12 , wherein the one or metrics comprise at least one of a total query execution time and a query execution resource consumption indication.  
   
   
       15 . The computer of  claim 12 , wherein the user interface is a graphical user interface.