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

摘要

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.

主权项

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.