Query plan management associated with a shared pool of configurable computing resources

• US 10,242,054 B2
• Filed: 01/12/2016
• Issued: 03/26/2019
• Est. Priority Date: 01/12/2016
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Konik, Rafal P., Mittelstadt, Roger A., Muras, Brian R.
• Primary Examiner(s): Khong, Alexander
• Application Number:
  US14/994,125
• Publication Number:
  US 20170199910A1
• Time in Patent Office: 1,169 Days
• CPC Class Codes: G06F 16/196 Specific adaptations of the file system to access devices and non-file objects via standard file system access operations, e.g. pseudo file systems dedicated interfaces to storage systems G06F3/0601
• CPC Class Codes: G06F 16/24542 Plan optimisation
• CPC Class Codes: G06F 2009/4557 Distribution of virtual machine instances; Migration and load balancing
• CPC Class Codes: G06F 2009/45575 Starting, stopping, suspending or resuming virtual machine instances
• CPC Class Codes: G06F 9/45558 Hypervisor-specific management and integration aspects

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.

Claims

1. 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.

2. The method of claim 1, further comprising:

identifying, by the query optimizer, a target state of the virtual machine to run the query.

3. The method of claim 1, wherein:

the virtual machine indicates a hibernated state, and

the set of asset actions includes activation of the virtual machine.

4. The method of claim 1, wherein:

the virtual machine indicates a deactivated state, and

the set of asset actions includes deployment of the virtual machine.

5. The method of claim 1, wherein:

the virtual machine runs on a first physical compute node of the shared pool of configurable computing resources, and

the set of asset actions includes migration of the virtual machine to a second physical compute node of the shared pool of configurable computing resources.

6. The method of claim 1, wherein:

the virtual machine indicates an offline state, and

the set of asset actions includes circumvention of the virtual machine using an associated physical disk to access the set of data.

7. The method of claim 6, wherein the circumvention of the virtual machine is performed without instantiating any virtual machines.

8. The method of claim 1, wherein:

the virtual machine indicates an offline state.

9. The method of claim 1, wherein the set of asset actions includes activating the virtual machine in response to reducing a resource burden of a separate virtual machine.

10. The method of claim 8, wherein the light virtual machine is saved into a template such that it can be redeployed to retrieve data from a set of tables that includes the set of data when the virtual machine is offline.

11. The method of claim 1, wherein the set of burden values is based on a resource configuration of the virtual machine.

12. The method of claim 1, wherein the set of burden values is based on a set of historical data for performing the set of asset actions.

13. The method of claim 1, wherein a shared pool manager determines the set of burden values, further comprising:

receiving, by the query optimizer, the set of burden values.

14. The method of claim 1, further comprising:

metering use of the query plan management; and

generating an invoice based on the metered use.

19. The method of claim 1, wherein the at least one asset action includes circumventing the virtual machine to access the data, and wherein processing the query plan comprises:

determining location and format information for a physical disk associated with the virtual machine;

directly attaching to the physical disk without changing a state of the virtual machine and without communicating with the virtual machine;

copying a set of tables associated with the set of data; and

executing the query on the copied set of tables.

15. 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.

16. 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.

17. The computer program product of claim 16, wherein the program instructions are stored in a computer readable storage medium in a data processing system, and wherein the program instructions were downloaded over a network from a remote data processing system.

18. The computer program product of claim 16, wherein the program instructions are stored in a computer readable storage medium in a server data processing system, and wherein the program instructions are downloaded over a network to a remote data processing system for use in a computer readable storage medium with the remote data processing system.