Global query optimization
AssigneeInternational Business Machines Corporation
InventorsAlexandar Mihaylov, Vincent Corvinelli, Calisto Zuzarte, Mohammed Fahd Alhamid, Brandon Lewis Frendo, Ian Richard Finlay
Life of this patent
Estimating the term…
Abstract
Techniques are provided for global query optimization. In one embodiment, the techniques involve receiving an input query, generating query candidates based on the input query, determining ratings of the query candidates, selecting a primary query of the query candidates based on the ratings of the query candidates, comparing a rating of the primary query to a query threshold, and generating a recommended query based on the rating.
Claims25
A method comprising:
- receiving an input query;
- generating query candidates based on the input query;
- determining ratings of the query candidates;
- selecting a primary query of the query candidates based on the ratings of the query candidates;
- comparing a rating of the primary query to a query threshold;
- and
- generating a recommended query based on the rating.
A system, comprising:
- a processor;
- and
- memory or storage comprising an algorithm or computer instructions, which when executed by the processor, performs an operation comprising:
- receiving an input query;
- generating query candidates based on the input query;
- determining ratings of the query candidates;
- selecting a primary query of the query candidates based on the ratings of the query candidates;
- comparing a rating of the primary query to a query threshold;
- and
- generating a recommended query based on the rating.
A computer-readable storage medium having a computer-readable program code embodied therewith, the computer-readable program code executable by one or more computer processors to perform an operation comprising:
- receiving an input query;
- generating query candidates based on the input query;
- determining ratings of the query candidates;
- selecting a primary query of the query candidates based on the ratings of the query candidates;
- comparing a rating of the primary query to a query threshold;
- and
- generating a recommended query based on the rating.
A system, comprising:
- a processor;
- and
- memory or storage comprising an algorithm or computer instructions, which when executed by the processor, performs an operation comprising:
- generating query execution plan candidates based on a recommended query;
- rating the query execution plan candidates;
- selecting a primary query execution plan of the query execution plan candidates based on the ratings of the query execution plan candidates;
- comparing a rating of the primary query execution plan to a plan threshold;
- and
- generating a runtime query execution plan based on the rating.
A computer-readable storage medium having a computer-readable program code embodied therewith, the computer-readable program code executable by one or more computer processors to perform an operation comprising:
- generating query execution plan candidates based on a recommended query;
- rating the query execution plan candidates;
- selecting a primary query execution plan of the query execution plan candidates based on the ratings of the query execution plan candidates;
- comparing a rating of the primary query execution plan to a plan threshold;
- and
- generating a runtime query execution plan based on the rating.
Dependencies are inferred from the claim text.