SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCT FOR DYNAMICALLY INCREASING RESOURCES UTILIZED FOR PROCESSING TASKS

• US 20110265088A1
• Filed: 04/21/2011
• Published: 10/27/2011
• Est. Priority Date: 04/22/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Oliver, Kevin, Devadhar, Vijayanth
• Granted Patent: US 8,875,152 B2
• Time in Patent Office: Days
• US Class Current: 718/102
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 9/5027 the resource being a machine, e.g. CPUs, Servers, Terminals
• CPC Class Codes: G06F 9/505 considering the load
• CPC Class Codes: G06F 9/5083 Techniques for rebalancing the load in a distributed system
• CPC Class Codes: H04L 41/5003 Managing SLA; Interaction between SLA and QoS
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]
• CPC Class Codes: H04L 67/1017 based on a round robin mechanism

Abstract

Mechanisms and methods are provided for dynamically increasing resources utilized for processing tasks. These mechanisms and methods for dynamically increasing resources utilized for processing tasks can enable embodiments to adjust processing power utilized for task processing. Further, adjusting processing power can ensure that quality of service goals set for processing tasks are achieved.

Claims

1. A computer program product embodied on a tangible computer readable medium, comprising:

computer code for identifying an unprocessed task in a queue of a multi-tenant on-demand database system, the unprocessed task stored in the queue for processing by a server;

computer code for determining whether a quality of service policy associated with processing the unprocessed task has been violated; and

computer code for adding an additional server for processing the unprocessed task, based on the determination.

2. The computer program product of claim 1, wherein the queue includes a table and the computer program product is operable such that the unprocessed task is stored in a row of the table such that the unprocessed task is identified by reading a row of the table.

3. The computer program product of claim 1, wherein identifying the unprocessed task includes identifying a type of the unprocessed task.

4. The computer program product of claim 3, wherein the computer program product is operable such that the quality of service policy is predetermined for the type of the unprocessed task.

5. The computer program product of claim 1, wherein the quality of service policy indicates an amount of time, upon storage in the queue, in which the unprocessed task is to be processed.

6. The computer program product of claim 5, wherein the computer program product is operable such that it is determined that the quality of service policy has been violated in response to a determination that the unprocessed task has been stored in the queue for more than the amount of time indicated by the quality of service policy.

7. The computer program product of claim 5, wherein the computer program product is operable such that it is determined that the quality of service policy has not been violated in response to a determination that the unprocessed task has been stored in the queue for less than the amount of time indicated by the quality of service policy.

8. The computer program product of claim 1, wherein adding the additional server includes registering the additional server as a server allowed to process the unprocessed task.

9. The computer program product of claim 1, wherein the computer program product is operable such that the additional server is added in response to a determination that the quality of service goal has been violated.

10. The computer program product of claim 9, wherein the computer program product is operable such that after the additional server is added in response to the determination that the quality of service policy has been violated, the additional server is removed in response to a determination that the quality of service policy is no longer being violated.

11. The computer program product of claim 1, wherein the computer program product is operable such that the additional server is added by requesting that the additional server be added.

12. The computer program product of claim 1, further comprising computer code for releasing a permit to add the additional server, in response to a determination that the quality of service policy has been violated.

13. The computer program product of claim 12, wherein the computer program product is operable such that the permit is released to a table of released permits.

14. The computer program product of claim 12, wherein the computer program product is operable such that the additional server is added by the additional server acquiring the permit from the table.

15. The computer program product of claim 1, wherein the computer program product is operable such that upon addition of the additional server, the additional server creates a listen list for dequeuing the unprocessed task from the queue.

16. The computer program product of claim 1, wherein the computer program product is operable such that the additional server processes the unprocessed task based on utilization of resources of the additional server and utilization of resources remote to the additional server.

17. The computer program product of claim 16, wherein the computer program product is operable such that the additional server processes the unprocessed task in response to a determination that the utilization of the resources of the additional server is below a first predetermined threshold and the utilization of the resources remote to the additional server is below a second predetermined threshold.

18. The computer program product of claim 16, wherein the resources of the additional server include memory of the additional server and the resources remote to the additional server include a central processing unit of a database that provides the queue.

19. A method, comprising:

identifying an unprocessed task in a queue of a multi-tenant on-demand database system, the unprocessed task stored in the queue for processing by a server;

determining whether a quality of service policy associated with processing the unprocessed task has been violated; and

adding an additional server for processing the unprocessed task, based on the determination.

20. An apparatus, comprising:

a processor for;

identifying an unprocessed task in a queue of a multi-tenant on-demand database system, the unprocessed task stored in the queue for processing by a server;

determining whether a quality of service policy associated with processing the unprocessed task has been violated; and

adding an additional server for processing the unprocessed task, based on the determination.

21. A method for transmitting code, comprising:

transmitting code to identify an unprocessed task in a queue of a multi-tenant on-demand database system, the unprocessed task stored in the queue for processing by a server;

transmitting code to determine whether a quality of service policy associated with processing the unprocessed task has been violated; and

transmitting code to add an additional server for processing the unprocessed task, based on the determination.