METHODS AND SYSTEMS FOR BATCH PROCESSING IN AN ON-DEMAND SERVICE ENVIRONMENT

• US 20140282556A1
• Filed: 05/27/2014
• Published: 09/18/2014
• Est. Priority Date: 04/20/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Fee, Gregory D., Gallager, William J.
• Granted Patent: US 10,013,278 B2
• Time in Patent Office: Days
• US Class Current: 718/101
• CPC Class Codes: G06F 2209/5013 Request control
• CPC Class Codes: G06F 9/466 Transaction processing
• CPC Class Codes: G06F 9/4843 by program, e.g. task dispatcher, supervisor, operating system

Abstract

In accordance with embodiments disclosed herein, there are provided mechanisms and methods for batch processing in an on-demand service environment. For example, in one embodiment, mechanisms include receiving a processing request for a multi-tenant database, in which the processing request specifies processing logic and a processing target group within the multi-tenant database. Such an embodiment further includes dividing or chunking the processing target group into a plurality of processing target sub-groups, queuing the processing request with a batch processing queue for the multi-tenant database among a plurality of previously queued processing requests, and releasing each of the plurality of processing target sub-groups for processing in the multi-tenant database via the processing logic at one or more times specified by the batch processing queue.

Claims

1. A non-transitory computer readable storage medium having computer instructions stored thereon causing a computer to implement a method comprising:

receiving a batch request for a database service, wherein the batch request specifies;

processing logic including instructions for performing at least one operation, and

a processing group to be processed by the processing logic, wherein the processing group includes data within the database service;

dividing the processing group into a plurality of processing sub-groups;

queuing the batch request to a batch processing queue of the database service; and

based on when the batch request in the queue is processed, individually processing each of the plurality of processing sub-groups via the processing logic.

2. The non-transitory computer readable storage medium of claim 1, wherein the batch request specifies batch processing;

wherein the processing logic comprises customer logic to be applied to the processing group in the database service; and

wherein the customer logic is applied to each of the plurality of processing sub-groups in the database service when released by the batch processing queue.

3. The non-transitory computer readable storage medium of claim 1, further comprising:

sending a completion notification to an originator of the processing request.

4. The non-transitory computer readable storage medium of claim 3, wherein the completion notification comprises a completion report specifying:

each of the plurality of processing sub-groups released for processing in the database service; and

a completion status for each of the plurality of processing sub-groups indicating a successful or unsuccessful completion for each processing sub-group.

5. The non-transitory computer readable storage medium of claim 1, wherein receiving the processing request comprises receiving the processing request at a host organization having the database service operating therein;

and wherein the processing request is one of a plurality of requests received from a plurality of customer organizations, wherein each customer organization is one of;

a separate and distinct remote organization, an organizational group within the host organization, a business partner of the host organization, or a customer organization that subscribes to cloud computing services provided by the host organization.

6. The non-transitory computer readable storage medium of claim 1, wherein the database service comprises elements of hardware and software that are shared by a plurality of separate and distinct customer organizations, each of the separate and distinct customer organizations being remotely located from the host organization having the database service operating therein.

7. The non-transitory computer readable storage medium of claim 1, wherein the processing group within the database service specified by the processing request comprises at least one of a plurality of rows within one or more tables of a relational data store in the database service and a plurality of objects in a non-relational data store in the database service.

8. The non-transitory computer readable storage medium of claim 1, wherein the database service comprises elements of hardware and software that are shared by a plurality of separate and distinct customer organizations, each of the separate and distinct customer organizations being remotely located from the host organization having the database service operating therein;

and wherein the processing group within database service specified by the processing request comprises at least one of a plurality of rows within one or more tables of a relational data store in the database service and a plurality of objects in a non-relational data store in the database service.

9. A system comprising:

a processor for;

receiving a batch request for a database service, wherein the batch request specifies;

processing logic including instructions for performing at least one operation, and

a processing group to be processed by the processing logic, wherein the processing group includes data within the database service;

dividing the processing group into a plurality of processing sub-groups;

queuing the batch request to a batch processing queue of the database service; and

based on when the batch request in the queue is processed, individually processing each of the plurality of processing sub-groups via the processing logic.

10. A method comprising:

receiving a batch request for a database service, wherein the batch request specifies;

processing logic including instructions for performing at least one operation, and

a processing group to be processed by the processing logic, wherein the processing group includes data within the database service;

dividing the processing group into a plurality of processing sub-groups;

queuing the batch request to a batch processing queue of the database service; and

based on when the batch request in the queue is processed, individually processing each of the plurality of processing sub-groups via the processing logic.