Annotated query generator
AssigneeEntit Software LLC
InventorsAlper Okcan, Thao Nguyen PHAM, Nga TRAN, Chuck Edward BEAR
Life of this patent
Estimating the term…
Abstract
Examples herein involve providing a first query to an optimizer; identifying a first execution plan selected by the optimizer based on the first query; generating an annotated query based on the selected first execution plan, the annotated query comprising hints for executing the selected first execution plan; and storing the annotated query in a database, the annotated query to cause the optimizer to generate a second execution plan corresponding to the first execution plan based on the hints.
Claims15
A method comprising:
- providing a first query to an optimizer;
- identifying a first execution plan selected by the optimizer based on the first query;
- generating an annotated query based on the selected first execution plan, the annotated query comprising hints for executing the selected first execution plan;
- and
- storing the annotated query in a database, the annotated query to cause the optimizer to generate a second execution plan corresponding to the first execution plan based on the hints.
A non-transitory machine readable storage medium comprising instructions that, when executed, cause a machine to at least:
- calculate a hash of a received query;
- determine that an annotated query associated with the received query is stored in a database based on the hash;
- and
- provide the annotated query to an optimizer, the optimizer to select an execution p for the received query based on hints stored in the annotated query.
An apparatus comprising:
- a query mapper to generate a hash of a received query;
- an annotated query generator to generate an annotated query based on an execution plan selected for the query by an optimizer, the annotated query comprising hints for executing the execution plan;
- and
- an optimizer interface to:
- provide the query to the optimizer when the hash of the received query does not match a hash in an index of a database;
- and
- provide the annotated query to the optimizer when the hash of the received query matches a hash in an index of a database that maps the query to the annotated query,
Dependencies are inferred from the claim text.