Batch job processing using a database system

• US 10,402,367 B2
• Filed: 01/13/2016
• Issued: 09/03/2019
• Est. Priority Date: 01/13/2016
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Gupta, Saurabh, Thirumalai, Srinivasan, Rengan, Suchindra, Lugina, Indra
• Primary Examiner(s): Lewis, Cheryl
• Application Number:
  US14/994,890
• Publication Number:
  US 20170199787A1
• Time in Patent Office: 1,329 Days
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 9/4843 by program, e.g. task dispatcher, supervisor, operating system

Abstract

Disclosed are examples of systems, apparatus, methods and computer program products for batch job processing using a database system. In some implementations, a data object relationship structure of a first record can be identified. Based on a type of data dependency of the data object relationship structure, a first record and a second record can be determined to be associated. A first batch number can be assigned to the first record and the second record. A first batch job can be defined. It can be determined that a third record is not associated with the first record. A second batch number can be assigned to the third record and a second batch job can be defined.

Claims

1. A database system comprising:

a server system comprising one or more processors, the server system configurable to;

maintain at least one database storing a plurality of records;

receive a request to process a group of the records;

identify a first one of the group of records;

identify a data object relationship structure of the first record, the data object relationship structure indicating a type of data dependency between the first record and at least one other record of the group of records;

determine, based on the type of data dependency, that the first record has a parent-child relationship with a second record, the first record having a parent role according to the data object relationship structure, the second record having a child role according to the data object relationship structure;

responsive to determining that the first record has the parent-child relationship with the second record, assign a first batch number to the first record and to the second record;

define a first batch job associated with the first batch number, the first batch job configured for processing of records associated with the first batch number;

determine that the first record is not associated with a third record;

responsive to determining that the first record is not associated with the third record, assign a second batch number to the third record, the second batch number being different than the first batch number; and

define a second batch job associated with the second batch number, the second batch job configured for processing of records associated with the second batch number.

2. The database system of claim 1, the server system further configurable to:

process the first batch job and the second batch job, the processing of the first batch job and the second batch job capable of being performed concurrently by one or more processors.

3. The database system of claim 2, the server system further configurable to:

determine that the first batch job was processed successfully; and

generate, based on the determination, a batch log capable of being displayed on a display device of a user system.

4. The database system of claim 1, the server system further configurable to:

determine that the first record is associated with a fourth record, the determination based on an inherited data dependency through the second record.

5. The database system of claim 4, the server system further configurable to:

responsive to determining that the first record is associated with the fourth record, assign the first batch number to the fourth record.

6. The database system of claim 1, wherein the first record is a customer relationship management record comprising one of:

an account, an opportunity, a lead, a case, a contact, a contract, a campaign, a solution or a quote.

7. The database system of claim 1, the server system further configurable to:

define a scheduling data object;

assign, based on the scheduling data object, a first scheduling priority to the first batch job; and

assign, based on the scheduling data object, a second scheduling priority to the second batch job.

8. A method comprising:

maintaining, using a database system implemented with a server system comprising one or more processors, at least one database storing a plurality of records;

receiving a request to process a group of the records;

identifying, using the database system, a first one of the group of records;

identifying, using the database system, a data object relationship structure of the first record, the data object relationship structure indicating a type of data dependency between the first record and at least one other record of the group of records;

determining, using the database system, based on the type of data dependency, that the first record has a parent-child relationship with a second record, the first record having a parent role according to the data object relationship structure, the second record having a child role according to the data object relationship structure;

responsive to determining that the first record has the parent-child relationship with the second record, assigning a first batch number to the first record and to the second record;

defining a first batch job associated with the first batch number, the first batch job configured for processing of records associated with the first batch number;

determining, using the database system, that the first record is not associated with a third record;

responsive to determining that the first record is not associated with the third record, assigning a second batch number to the third record, the second batch number being different than the first batch number; and

defining a second batch job associated with the second batch number, the second batch job configured for processing of records associated with the second batch number.

9. The method of claim 8, the method further comprising:

processing the first batch job and the second batch job, the processing of the first batch job and the second batch job capable of being performed concurrently by one or more processors.

10. The method of claim 9, the method further comprising:

determining that the first batch job was processed successfully; and

generating, based on the determination, a batch log capable of being displayed on a display device of a user system.

11. The method of claim 8, the method further comprising:

determining, using the database system, that the first record is associated with a fourth record, the determination based on an inherited data dependency through the second record.

12. The method of claim 11, the method further comprising:

responsive to determining that the first record is associated with the fourth record, assigning the first batch number to the fourth record.

13. The method of claim 8, wherein the first record is a customer relationship management record comprising one of:

an account, an opportunity, a lead, a case, a contact, a contract, a campaign, a solution or a quote.

14. A computer program product comprising computer-readable program code to be executed by one or more processors when retrieved from a non-transitory computer-readable medium, the program code comprising instructions configurable to cause:

maintaining at least one database in a database system storing a plurality of records;

identifying, using the database system, a first one of a group of records;

identifying, using the database system, a data object relationship structure of the first record, the data object relationship structure indicating a type of data dependency between the first record and at least one other record of the group of records;

determining, using the database system, based on the type of data dependency, that the first record has a parent-child relationship with a second record, the first record having a parent role according to the data object relationship structure, the second record having a child role according to the data object relationship structure;

responsive to determining that the first record has the parent-child relationship with the second record, assigning a first batch number to the first record and to the second record;

defining a first batch job associated with the first batch number, the first batch job configured for processing of records associated with the first batch number;

determining, using the database system, that the first record is not associated with a third record;

responsive to determining that the first record is not associated with the third record, assigning a second batch number to the third record, the second batch number being different than the first batch number; and

defining a second batch job associated with the second batch number, the second batch job configured for processing of records associated with the second batch number.

15. The computer program product of claim 14, the instructions further configurable to cause:

processing the first batch job and the second batch job, the processing of the first batch job and the second batch job capable of being performed concurrently by one or more processors.

16. The computer program product of claim 15, the instructions further configurable to cause:

determining that the first batch job was processed successfully; and

generating, based on the determination, a batch log capable of being displayed on a display device of a user system.

17. The computer program product of claim 14, the instructions further configurable to cause:

determining, using the database system, that the first record is associated with a fourth record, the determination based on an inherited data dependency through the second record.

18. The computer program product of claim 17, the instructions further configurable to cause:

responsive to determining that the first record is associated with the fourth record, assigning the first batch number to the fourth record.

19. The computer program product of claim 14, wherein the first record is a customer relationship management record comprising one of:

an account, an opportunity, a lead, a case, a contact, a contract, a campaign, a solution or a quote.

20. The computer program product of claim 14, the instructions further configurable to cause:

defining a scheduling data object;

assigning, based on the scheduling data object, a first scheduling priority to the first batch job; and

assigning, based on the scheduling data object, a second scheduling priority to the second batch job.