Managing the execution of a query
OwnerLouis Burger, Thomas Julieninventors
Life of this patent
Estimating the term…
Abstract
A method and system for managing execution of a query that provides an avenue for runtime optimization, or more specifically runtime re-optimization. This allows for more efficient execution plans to be generated, and reduces the risk of major complications due to inadvertently poor estimates. In other cases such a query management system is used for alternate purposes, such as throttling system resource consumption for demanding queries.
Claims17
A system for managing execution of a query, the query being executable in a form including a step that provides an intermediate result for use by a subsequent step, the system including:
- an interface for monitoring execution of the query to obtain data associated with the intermediate result;
- and
- a processor responsive to the intermediate result for selectively allowing further execution of the query.
A system according to claim 6 wherein the re-written query is released for execution in the database in accordance with the execution plan.
A method for managing execution of a query, the query being executable in a form including a step that provides an intermediate result for use by a subsequent step, the method including the steps of:
- monitoring execution of the query to obtain data associated with the intermediate result;
- and
- being responsive to the intermediate result for selectively allowing further execution of the query.
A method for re-optimizing a query at runtime including the steps of:
- determining at runtime whether an existing execution plan for the query meets predefined criteria;
- being responsive to the determination for selectively re-writing the query by reference to one or more known intermediate results;
- and
- optimizing the re-written query.
Dependencies are inferred from the claim text.