Execution of query plans
AssigneeHewlett Packard Enterprise Development LP
InventorsKrishnamoorthy BALARAMAN, Abhijeet WALIMBE, Suresh SOUNDARARAJAN
Life of this patent
Estimating the term…
Abstract
Example techniques for execution of query plans are described. In an example, a query plan may include a first sub-plan and a second sub-plan that are to provide the same output. One among the first sub-plan and the second sub-plan may be selected during execution of the query plan based on a runtime performance parameter of a component to be involved in execution of the first sub-plan and a runtime performance parameter of a component to be involved in execution of the second sub-plan.
Claims20
A system comprising:
- a processor;
- and
- a memory comprising instructions executable by the processor to:
- select, during execution of a query plan comprising a first sub-plan and a second sub-plan, the first sub-plan for execution, wherein the query plan is executable to provide a result for a database query, wherein the first sub-plan and the second sub-plan are to provide the same output, wherein a first component is to be involved in execution of the first sub-plan and a second component is to be involved in execution of the second sub-plan, wherein the selection is based on a runtime performance parameter of the first component and a runtime performance parameter of the second component;
- and
- cause execution of the first sub-plan.
A method comprising:
- receiving a query plan for execution of a database query, the query plan comprising:
- a first plurality of equivalent sub-plans that are to provide the same first output;
- and
- a first sub-plan selection operator indicating components to be involved in execution of each of the first plurality of equivalent sub-plans;
- selecting, in response to executing the first sub-plan selection operator during execution of the query plan;
- a first sub-plan from amongst the first plurality of equivalent sub-plans based on runtime performance parameters of components to be involved in execution of each of the first plurality of equivalent sub-plans;
- and
- executing the first sub-plan for execution of the query plan.
A non-transitory computer-readable medium comprising instructions, the instructions being executable by a processing resource to:
- receive a database query in response to which a result is to be provided;
- generate a first preliminary query plan that is executable to provide the result and a second preliminary query plan that is executable to provide the result, wherein the first preliminary query plan comprises a first sub-plan, wherein the second preliminary query plan comprises a second sub-plan, wherein the first sub-plan and the second sub-plan are to provide the same output, wherein a first plurality of components is to be involved in execution of the first sub-plan, and wherein a second plurality of components is to be involved in execution of the second sub-plan;
- and
- generate, based on the first preliminary query plan and the second preliminary query plan, a query plan to be executed to output the result for the database query, the query plan comprising:
- the first sub-plan;
- the second sub-plan;
- and
- a sub-plan selection operator indicating the first plurality of components and the second plurality of components, wherein the sub-plan selection operator is executable during execution of the query plan to select one among the first sub-plan and the second sub-plan based on runtime performance parameters of the first plurality of components and runtime performance parameters of the second plurality of components.
Dependencies are inferred from the claim text.