Query plan management associated with a shared pool of configurable computing resources
AssigneeInternational Business Machines Corporation
InventorsRafal P. Konik, Roger A. Mittelstadt, Brian R. Muras
Life of this patent
Estimating the term…
Abstract
Disclosed aspects relate to query plan management associated with a shared pool of configurable computing resources. A query, which relates to a set of data located on the shared pool of configurable computing resources, is detected. A virtual machine includes the set of data. With respect to the virtual machine, a set of burden values of performing a set of asset actions is determined. Based on the set of burden values, a query plan to access the set of data is established. Using at least one asset action of the set of asset actions, the query plan is processed.
Claims19
A computer-implemented method for query plan management associated with a shared pool of configurable computing resources, the method comprising:
- detecting a query which relates to a set of data located on the shared pool of configurable computing resources, wherein a virtual machine includes the set of data;
- identifying, by a query optimizer, a current state of the virtual machine;
- determining the virtual machine is unable to execute the query based on the identified state;
- determining, with respect to the virtual machine and responsive to determining the virtual machine is unable to execute the query, a set of burden values of performing a set of asset actions,
- wherein the set of asset actions includes circumvention of the virtual machine by generating a light virtual machine to access the set of data, wherein the light virtual machine includes a smaller set of functionality compared to the virtual machine;
- establishing, based on the set of burden values, a query plan to access the set of data;
- and
- processing, using at least one asset action of the set of asset actions, the query plan.
A system for query plan management associated with a shared pool of configurable computing resources, the system comprising:
- a memory having a set of computer readable computer instructions, and
- a processor for executing the set of computer readable instructions, the set of computer readable instructions including:
- detecting a query which relates to a set of data located on the shared pool of configurable computing resources, wherein a virtual machine includes the set of data;
- identifying, by a query optimizer, a current state of the virtual machine;
- determining that the virtual machine is in a state that does not allow execution of the query;
- determining, with respect to the virtual machine and responsive to determining the virtual machine is unable to execute the query, a set of burden values of performing a set of asset actions,
- wherein the set of asset actions includes circumvention of the virtual machine by generating a light virtual machine to access the set of data, wherein the light virtual machine includes a smaller set of functionality compared to the virtual machine;
- establishing, based on the set of burden values, a query plan to access the set of data;
- and
- processing, using at least one asset action of the set of asset actions, the query plan.
A computer program product for query plan management associated with a shared pool of configurable computing resources, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:
- detecting a query which relates to a set of data located on the shared pool of configurable computing resources, wherein a virtual machine includes the set of data;
- identifying, by a query optimizer, a current state of the virtual machine;
- determining the virtual machine is unable to execute the query based on the identified state;
- determining, with respect to the virtual machine and responsive to determining the virtual machine is unable to execute the query, a set of burden values of performing a set of asset actions,
- wherein the set of asset actions includes circumvention of the virtual machine by generating a light virtual machine to access the set of data, wherein the light virtual machine includes a smaller set of functionality compared to the virtual machine;
- generating a query plan to access the set of data based on the set of burden values;
- and
- executing, using at least one asset action of the set of asset actions, the query plan.
Dependencies are inferred from the claim text.