Incremental data query performance feedback model
AssigneeIntenational Business Machines Corporation
InventorsRichard D. Dettinger, Frederick A. Kulack, Richard J. Stevens, Eric W. Will
Life of this patent
Estimating the term…
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.
Claims22
A 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.
A method of providing real time query analysis feedback to a user, comprising:
- incrementally receiving inputs for the construction of a query;
- 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.
A computer readable medium containing a program which, when executed, performs an automatic operation upon receiving each incremental input for the construction of a query and prior to receiving a request to execute the query, the operation comprising:
- 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.
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.
Dependencies are inferred from the claim text.