Extensible and generic framework for managing resources for data warehousing loads

• US 9,229,949 B2
• Filed: 10/07/2011
• Issued: 01/05/2016
• Est. Priority Date: 10/07/2011
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Noureddine, Sadek
• Primary Examiner(s): Boccio, Vincent F
• Application Number:
  US13/268,644
• Publication Number:
  US 20130091089A1
• Time in Patent Office: 1,551 Days
• Field of Search: 707/607, 707/608, 707/703, 707/704
• US Class Current: 1/1
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/24532 of parallel queries
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 9/5011 the resources being hardware resources other than CPUs, Servers and Terminals

Abstract

Methods, systems, and computer program products are provided for managing resources. A request is received for a plurality of resources from a requester. A ticket is generated for the request that indicates the resources. For each resource, a resource provider for the resource is queried to determine whether the resource can be acquired. The ticket is queued if any of the resources cannot be acquired. The ticket is granted if all of the resources can be acquired.

Claims

1. A method for managing resources implemented in at least one computing device, comprising:

receiving a request for a plurality of resources from a requester;

generating a ticket for the request that indicates the plurality of resources;

assigning a default priority for the ticket based on a determination that the request does not include a priority indication, the default priority being a priority that is greater than a low priority and less than a high priority;

for at least one resource of the plurality of resources, querying a resource provider of a plurality of resource providers for the at least one resource to determine whether the at least one resource can be acquired;

queuing the ticket in a queue if any of the resources cannot be acquired;

instructing each resource provider to release any resources that were locked during said querying if a resource provider indicates that a resource cannot be acquired during said querying; and

granting the ticket if all of the resources can be acquired.

2. The method of claim 1, wherein if a resource provider indicates that a resource can be acquired during said querying, the resource provider locks the resource from being acquired by others than the requester.

3. The method of claim 1, wherein the ticket is granted because all of the resources can be acquired, said granting comprising:

providing an indication to the requester that the request is granted to enable the requester to acquire the resources at the plurality of resource providers.

4. The method of claim 3, further comprising:

receiving an indication from the requester that the resources have been acquired; and

releasing the ticket.

5. The method of claim 4, wherein said releasing the ticket comprises:

instructing each resource provider for a corresponding resource of the plurality of resources to release the corresponding resource.

6. The method of claim 4, further comprising:

receiving a second request after the first ticket was granted and before the first ticket is released;

generating a second ticket based on the second request; and

queuing the second ticket in the queue because a resource indicated in the second ticket is included in the first ticket, is determined to be acquirable for the first ticket, and is locked by a corresponding resource provider due to the first ticket being granted.

7. The method of claim 6, further comprising:

retrieving the second ticket from the queue after the first ticket is released;

querying the resource providers for the resources of the second ticket to determine whether each of the resources of the second ticket can be acquired;

queuing the second ticket in the queue and retrieving a next ticket from the queue if any of the resources of the second ticket cannot be acquired; and

granting the second ticket if all of the resources of the second ticket can be acquired.

8. The method of claim 1, wherein the ticket is queued because at least one of the resources cannot be acquired, said queuing comprising:

prioritizing the ticket in the queue based on a priority indication received in the request.

9. A system for managing resources, comprising:

at least one processing device;

a resource request interface that receives a request for a plurality of resources from a requester, and generates a ticket for the request that indicates the plurality of resources;

a resource provider interface communicatively coupled with a plurality of resource providers; and

a resource manager implemented using the at least one processing device that, for at least one resource of the plurality of resources, queries a resource provider for the at least one resource through the resource provider interface to determine whether the at least one resource can be acquired;

the resource manager configured to assign a default priority for the ticket based on a determination that the request does not include a priority indication, the default priority being a priority that is greater than a low priority and less than a high priority;

the resource manager configured to queue the ticket in a queue if any of the resources cannot be acquired, and to instruct each resource provider through the resource provider interface to release any resources of the plurality of resource that were locked if a resource provider indicates that a resource of the plurality of resources cannot be acquired; and

the resource manager configured to grant the ticket if all of the resources can be acquired.

10. The system of claim 9, wherein if in response to the query a resource provider indicates that a resource can be acquired, the resource provider locks the resource from being acquired by others than the requester.

11. The system of claim 9, wherein, if the ticket is granted, the resource manager provides an indication to the requester that the request is granted to enable the requester to acquire the resources at the plurality of resource providers.

12. The system of claim 11, wherein, in response to providing the indication to the requester that the request is granted, the resource manager receives an indication from the requester that the resources have been acquired and the resource manager releases the ticket.

13. The system of claim 12, wherein the resource manager releases the ticket at least by instructing each resource provider for a resource of the plurality of resources to release the resource.

14. The system of claim 12, wherein the resource request interface receives a second request after the first ticket was granted and before the first ticket is released, and generates a second ticket based on the second request;

and

the resource manager queues the second ticket in the queue because a resource indicated in the second ticket is included in the first ticket, is determined to be acquirable for the first ticket, and is locked by a corresponding resource provider due to the first ticket being granted.

15. The system of claim 14, wherein after the first ticket is released, the resource manager is configured to retrieve a second ticket from the queue, to query the resource providers for the resources of the second ticket to determine whether each of the resources of the second ticket can be acquired, to queue the second ticket in the queue and retrieve a next ticket from the queue if any of the resources of the second ticket cannot be acquired, and to grant the second ticket if all of the resources of the second ticket can be acquired.

16. The system of claim 9, wherein the resource manager comprises:

a queue manager configured to prioritize the ticket in the queue based on a priority indication received in the request.

17. A computer program product comprising a computer usable storage medium having computer readable logic embodied in said storage medium for enabling a processor to manage resources, comprising:

first computer readable logic that enables the processor to generate a ticket for a received request that indicates a plurality of resources indicated in the request and a priority indication included in the request, the request received from a requester;

second computer readable logic that enables the processor to query a plurality of resource providers for the resources indicated in the ticket to determine whether all resources indicated in the ticket can be acquired;

third computer readable logic that enables the processor to queue the ticket in a queue according to the priority indication if any of the resources cannot be acquired, and to instruct each resource provider through the resource provider interface to release any resources of the plurality of resource that were locked if a resource provider indicates that a resource of the plurality of resources cannot be acquired;

fourth computer readable logic that enables the processor to grant the ticket if all of the resources can be acquired; and

fifth computer readable logic that enables the processor to assign a default priority for the ticket based on a determination that the request does not include a priority indication, the default priority being a priority that is greater than a low priority and less than a high priority.

18. The computer program product of claim 17, wherein said fourth computer readable logic comprises:

computer readable logic that enables the processor to provide an indication to the requester that the request is granted to enable the requester to acquire the resources at the plurality of resource providers;

computer readable logic that enables the processor to receive an indication from the requester that the resources have been acquired; and

computer readable logic that enables the processor to release the ticket.

19. The computer program product of claim 18, wherein said computer readable logic for enabling the processor to release the ticket comprises:

computer readable logic that enables the processor to instruct each resource provider for a corresponding resource of the plurality of resources to release the corresponding resource.

20. The computer program product of claim 17, wherein said third computer readable logic comprises:

computer readable logic that enables the processor to prioritize the ticket in the queue based on a priority indication received in the request.