QUERY PLAN MANAGEMENT ASSOCIATED WITH A SHARED POOL OF CONFIGURABLE COMPUTING RESOURCES

• US 20170199910A1
• Filed: 01/12/2016
• Published: 07/13/2017
• 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.
• Granted Patent: US 10,242,054 B2
• Time in Patent Office: 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;

determining, with respect to the virtual machine, a set of burden values of performing a set of asset actions;

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 a query optimizer, a current state of the virtual machine which indicates an error event to run the query; and

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 5, wherein a second resource performance capacity of the second physical compute node exceeds a first resource performance capacity of the first physical compute node.

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

8. The method of claim 7, wherein the associated physical disk is located on a storage area network (SAN).

9. 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 by generating a light virtual machine to access the set of data.

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

11. The method of claim 1, further comprising:

comparing a first burden value to perform a first asset action with a second burden value to perform the second asset action.

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

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

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

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

15. The method of claim 1, wherein a query optimizer determines the set of burden values.

16. The method of claim 1, further comprising:

metering use of the query plan management; and

generating an invoice based on the metered use.

17. 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;

determining, with respect to the virtual machine, a set of burden values of performing a set of asset actions;

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.

18. 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;

determining, with respect to the virtual machine, a set of burden values of performing a set of asset actions;

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.

19. The computer program product of claim 18, 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.

20. The computer program product of claim 18, 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.