Techniques for utilizing computational resources in a multi-tenant on-demand database system

• US 8,776,067 B1
• Filed: 12/11/2009
• Issued: 07/08/2014
• Est. Priority Date: 12/11/2009
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc., Second Sight Medical Products, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Yancey, Scott
• Primary Examiner(s): Puente, Emerson
• Assistant Examiner(s): KIM, DONG U
• Application Number:
  US12/636,658
• Time in Patent Office: 1,670 Days
• Field of Search: None
• US Class Current: 718/102
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/815 Virtual middleware or OS functionality using virtual machines to implement generic software techniques for error detection or fault masking G06F11/1484
• CPC Class Codes: G06Q 30/00 Commerce

Abstract

In accordance with embodiments, there are provided techniques for utilizing computational resources of a multi-tenant on-demand database system. These techniques for utilizing computational resources of a multi-tenant on-demand database system may enable embodiments to provide great flexibility to a tenant of the architecture to perform desired functions on content of the database without unduly consuming the resources of the system.

Claims

1. A method of utilizing computational resources in a multi-tenant on-demand database system, the method comprising:

processing computational jobs in the multi-tenant on-demand database system, the multi-tenant on-demand database system provides access to multiple tenants each having one or more associated users, the multi-tenant on-demand database system to provide access to tenant information only to users associated with the tenant corresponding to the tenant information;

monitoring said processing to ascertain resource utilization of said multi-tenant on-demand database system;

storing data related to said computational jobs in a queue table;

systematically varying computational resources allocated to process said computational jobs in response to said resource utilization ascertained by said monitoring wherein said systematically varying computational resources allocated to process said computational jobs comprises enqueuing/dequeuing said computational jobs and further includes executing a plurality of said enqueue/dequeue processes and a plurality of job handlers configured to operate upon a type of said computational jobs that is different than the type of said computational jobs upon which a remaining job handlers of said plurality of job handlers are configured to operate upon, each of which is in data communication with one of said plurality of enqueue/dequeue processes, each of said plurality of job handlers including methods to process said computational jobs; and

varying a number of said plurality of job handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria including a tenant-level information related to historical information comprising at least job type and historical information related to time required to complete computational tasks for one or more job types.

2. The method as recited in claim 1 wherein said systematically varying computational resources allocated to process said computational jobs comprises enqueuing/dequeuing said computational jobs and further includes executing a job handler in data communication with said enqueue/dequeue process, said job handler including methods to process said computational jobs.

3. The method as recited in claim 1 wherein each of said a plurality of enqueue/dequeue processes is in a data communication with one of said plurality of job handlers that is different than the job handlers in data communication with the remaining enqueue/dequeue processes of said plurality of enqueue/dequeue processes.

4. The method as recited in claim 1 further including varying a number of said plurality of job handlers in response to the resource utilization.

5. The method as recited in claim 1 further including varying a number of said plurality of enqueue/dequeue processes and said plurality of job handlers in response to the resource utilization.

6. The method as recited in claim 1 further including varying a number of said plurality of job handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria comprising information related to real-time measurements of computational demand on said system.

7. A method of utilizing computational resources in a multi-tenant on-demand database system, the method comprising:

executing a plurality of enqueue/dequeue processes and a plurality of job handlers to process computational jobs;

processing said computational jobs in the multi-tenant on-demand database system, the multi-tenant on-demand database system provides access to multiple tenants each having one or more associated users, the multi-tenant on-demand database system to provide access to tenant information only to users associated with the tenant corresponding to the tenant information;

monitoring said processing to ascertain resource utilization of said multi-tenant on-demand database system; and

varying a number of said plurality of enqueue/dequeue processes and said plurality of job handlers in response to said resource utilization ascertained by said monitoring wherein said systematically varying computational resources allocated to process said computational jobs comprises enqueuing/dequeuing said computational jobs and further includes executing a plurality of said enqueue/dequeue processes and a plurality of jobs handlers configured to operate upon a type of said computational jobs that is different than the type of said computational jobs upon which a remaining job handlers of said plurality of job handlers are configured to operate upon, each of which is in data communication with one of said plurality of enqueue/dequeue processes, each of said plurality of jobs handlers including methods to process said computational jobs; and

varying a number of said plurality of jobs handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria including a tenant-level information related to historical information comprising at least job type and historical information related to time required to complete computational tasks for one or more job types.

8. The method as recited in claim 7 wherein executing further includes executing said plurality of job handlers, with each of said plurality of job handlers including methods to process said computational jobs.

9. The method as recited in claim 7 wherein executing further includes placing one of said plurality of enqueue/dequeue processes is in data communication with one of said plurality of job handlers that is different than the job handlers in data communication with the remaining enqueue/dequeue processes of said plurality of enqueue/dequeue processes.

10. The method as recited in claim 7 wherein said varying further includes varying a number of said plurality of job handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria comprising information related to real-time measurements of computational demand on said system.

11. A multi-tenant database system comprising:

a processor; and

a memory having a sequence of instructions which, when executed by the processor, cause the processor to carry out the steps of;

executing a plurality of enqueue/dequeue processes and a plurality of job handlers to process computational jobs in the multi-tenant database system, the multi-tenant on-demand database system provides access to multiple tenants each having one or more associated users, the multi-tenant on-demand database system to provide access to tenant information only to users associated with the tenant corresponding to the tenant information;

processing said computational jobs in the multi-tenant database system;

monitoring said processing to ascertain resource utilization of said system; and

varying a number of said plurality of enqueue/dequeue processes and said plurality of job handlers in response to said resource utilization ascertained by said monitoring wherein said systematically varying computational resources allocated to process said computational jobs comprises enqueuing/dequeuing said computational jobs and further includes executing a plurality of said enqueue/dequeue processes and a plurality of job handlers configured to operate upon a type of said computational jobs that is different than the type of said computational jobs upon which a remaining job handlers of said plurality of job handlers are configured to operate upon, each of which is in data communication with one of said plurality of enqueue/dequeue processes, each of said plurality of job handlers including methods to process said computational jobs; and

varying a number of said plurality of job handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria including a tenant-level information related to historical information comprising at least job type and historical information related to time required to complete computational tasks for one or more job types.

12. The system as recited in claim 11 wherein said instructions for carrying out the step of executing further includes computer-readable code for carrying out the step of executing said plurality of job handlers, with each of said plurality of job handlers including methods to process said computational jobs.

13. The system as recited in claim 11 wherein said instructions for carrying out the step of executing further includes computer-readable code for carrying out the step of placing one of said plurality of enqueue/dequeue processes is in the data communication with one of said plurality of job handlers that is different than the job handlers in the data communication with the remaining enqueue/dequeue processes of said plurality of enqueue/dequeue processes.

14. The system as recited in claim 11 wherein said instructions for carrying out the step of varying further includes computer-readable code of carrying out the step of varying a number of said plurality of job handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria comprising information related to real-time measurements of computational demand on said system.

15. A non-transitory machine-readable medium carrying out one of more sequences of instructions for establishing utilization of computational resources in a multi-tenant on-demand database system, the instructions when executed by one or more processors and cause said one or more processors to carry out the steps of:

executing a plurality of enqueue/dequeue processes and a plurality of job handlers to process computational jobs, the multi-tenant on-demand database system provides access to multiple tenants each having one or more associated users, the multi-tenant on-demand database system to provide access to tenant information only to users associated with the tenant corresponding to the tenant information;

processing said computational jobs;

monitoring said processing to ascertain resource utilization of said system; and

varying a number of said plurality of enqueue/dequeue processes and said plurality of job handlers in response to said resource utilization ascertained by said monitoring for said processing wherein said systematically varying computational resources allocated to process said computational jobs comprises enqueuing/dequeuing said computational jobs and further includes executing a plurality of said enqueue/dequeue processes and a plurality of job handlers configured to operate upon a type of said computational jobs that is different than the type of said computational jobs upon which a remaining job handlers of said plurality of job handlers are configured to operate upon, each of which is in data communication with one of said plurality of enqueue/dequeue processes, each of said plurality of job handlers including methods to process said computational jobs; and

varying a number of said plurality of job handlers in response to said monitoring determining said resource utilization satisfies a predetermined criteria, with said predetermined criteria including a tenant-level information related to historical information comprising at least job type and historical information related to time required to complete computational tasks for one or more job types.