Methods and systems for bulk uploading of data in an on-demand service environment

• US 10,216,821 B2
• Filed: 02/24/2015
• Issued: 02/26/2019
• Est. Priority Date: 04/01/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Cheenath, Manoj, Fell, Simon Z., Joergensen, Jesper
• Primary Examiner(s): Featherstone, Mark D
• Assistant Examiner(s): Gmahl, Navneet
• Application Number:
  US14/630,567
• Publication Number:
  US 20150242479A1
• Time in Patent Office: 1,463 Days
• Field of Search: None
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/2386 Bulk updating operations data conversion details G06F16/258
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]

Abstract

Methods and systems for bulk uploading of data in an on-demand service environment are described. In one embodiment, such a method includes retrieving a bulk transaction request from a transaction queue within a host organization, where the bulk transaction request specifies a plurality of database transactions to be processed against a multi-tenant database system of the host organization. Such a method further includes determining a current computational load of the multi-tenant database system, processing a subset of the plurality of database transactions specified by the bulk transaction request against the multi-tenant database system when the current computational load is below a threshold, and updating a bulk transaction results log based on the subset of the plurality of database transactions processed. Remaining database transactions specified by the bulk transaction request may then be re-queued for later processing.

Claims

1. A method in a host organization having at least a processor and a memory therein, wherein the method comprises:

receiving a bulk transaction request from a client device communicatively interfaced to the host organization at a web-server interface of the host organization executing via the processor and memory of the host organization, wherein the bulk transaction request specifies a plurality of database transactions to be processed against a database system of the host organization;

sending a response to the client device having submitted the bulk transaction request from the web-server interface of the host organization, wherein the response provides at least;

(a) an indication of successful receipt of the bulk transaction request and (b) an acknowledgement that the bulk transaction request is queued for processing or queued for asynchronous processing;

determining a current computational load of the database system based on a plurality of real-time transaction requests and a plurality of bulk transaction requests awaiting processing via the database system; and

processing a subset of the plurality of database transactions specified by the bulk transaction request against the database system when the current computational load is below a threshold, wherein the plurality of real-time transaction requests are assigned a higher priority than the plurality of bulk transaction requests and are selected for processing against the database system based on the higher priority and further wherein the plurality of bulk transaction requests are assigned a lower priority than the plurality of real-time transaction requests and are selected for processing against the database system based on the lower priority and based further on the determined current computational load of the database system.

2. The method of claim 1, further comprising:

inserting the bulk transaction request into a transaction queue among a plurality of bulk transaction requests and a plurality of real-time transaction requests in the transaction queue.

3. The method of claim 2, wherein:

processing the subset of the plurality of database transactions leaves a remaining portion of the plurality of database transactions unprocessed; and

wherein the method further comprises;

updating a bulk transaction results log based on the subset of the plurality of database transactions processed and the remaining portion of the plurality of database transactions unprocessed;

re-queuing the bulk transaction request specifying the remaining portion of the plurality of database transactions unprocessed in the transaction queue for later processing.

4. The method of claim 1, further comprising:

sending a response to a client device having submitted the bulk transaction request, wherein the response specifies a session identifier assigned to the bulk transaction request, and further wherein the response acknowledges the bulk transaction request is queued for asynchronous processing.

5. The method of claim 1, further comprising:

receiving a real-time transaction request at the host organization subsequent to receiving the bulk transaction request;

processing the real-time transaction request against the database system before processing any part of the bulk transaction request based on the higher priority of the real-time transaction request; and

sending a response to a client device having submitted the real-time transaction request, wherein the response specifies a result for the real-time transaction request and further wherein the response indicates synchronous processing of the real-time transaction request is complete.

6. The method of claim 1, further comprising:

validating the bulk transaction request at the host organization against one or more specifications.

7. The method of claim 6, wherein:

validating the bulk transaction request comprises;

verifying the bulk transaction request complies with a maximum record count threshold,

verifying the bulk transaction request complies with a maximum size threshold,

verifying the bulk transaction request complies with an accepted request format; and

wherein the method further comprises;

submitting the bulk transaction request to the transaction queue when the bulk transaction request is successfully validated.

8. The method of claim 1:

wherein the bulk transaction request comprises a bulk record upload request; and

wherein each of the plurality of database transactions specified by the bulk transaction request comprises a record and/or row to be uploaded to a table within the database system.

9. The method of claim 1, wherein each of the plurality of database transactions specified by the bulk transaction request comprises:

a transaction type selected from add, update, or delete;

a named table within the database system against which to process the respective database transaction based on the transaction type; and

transaction data to be added, updated, or selected for deletion based on the transaction type during the respective database transaction.

10. The method of claim 1, wherein determining the current computational load of the database system comprises:

retrieving one or more operational statistics from the database system, each operating statistic describing Input/Output utilization of the database system;

CPU utilization of the database system;

number of free server nodes available for processing database transactions within a pool of server nodes;

number of active threads currently processing database transactions against the database system;

current queue time of real-time database transactions to be processed against the database system; and

number of queued real-time database transactions to be processed against the database system.

11. Non-transitory computer readable storage media having instructions stored thereupon that, when executed by a processor and a memory of a host organization, the instructions cause the host organization to perform operations comprising:

receiving a bulk transaction request from a client device communicatively interfaced to the host organization at a web-server interface of the host organization executing via the processor and memory of the host organization, wherein the bulk transaction request specifies a plurality of database transactions to be processed against a database system of the host organization;

sending a response to the client device having submitted the bulk transaction request from the web-server interface of the host organization, wherein the response provides at least;

(a) an indication of successful receipt of the bulk transaction request and (b) an acknowledgement that the bulk transaction request is queued for processing or queued for asynchronous processing;

determining a current computational load of the database system based on a plurality of real-time transaction requests and a plurality of bulk transaction requests awaiting processing via the database system; and

processing a subset of the plurality of database transactions specified by the bulk transaction request against the database system when the current computational load is below a threshold, wherein the plurality of real-time transaction requests are assigned a higher priority than the plurality of bulk transaction requests and are selected for processing against the database system based on the higher priority and further wherein the plurality of bulk transaction requests are assigned a lower priority than the plurality of real-time transaction requests and are selected for processing against the database system based on the lower priority and based further on the determined current computational load of the database system.

12. The non-transitory computer readable storage media of claim 11, further comprising:

inserting the bulk transaction request into a transaction queue among a plurality of bulk transaction requests and a plurality of real-time transaction requests in the transaction queue.

13. The non-transitory computer readable storage media of claim 12, wherein:

processing the subset of the plurality of database transactions leaves a remaining portion of the plurality of database transactions unprocessed; and

wherein the method further comprises;

updating a bulk transaction results log based on the subset of the plurality of database transactions processed and the remaining portion of the plurality of database transactions unprocessed;

re-queuing the bulk transaction request specifying the remaining portion of the plurality of database transactions unprocessed in the transaction queue for later processing.

14. The non-transitory computer readable storage media of claim 11, further comprising:

sending a response to a client device having submitted the bulk transaction request, wherein the response specifies a session identifier assigned to the bulk transaction request, and further wherein the response acknowledges the bulk transaction request is queued for asynchronous processing.

15. The non-transitory computer readable storage media of claim 11, further comprising:

receiving a real-time transaction request at the host organization subsequent to receiving the bulk transaction request;

processing the real-time transaction request against the database system before processing any part of the bulk transaction request based on the higher priority of the real-time transaction request; and

sending a response to a client device having submitted the real-time transaction request, wherein the response specifies a result for the real-time transaction request and further wherein the response indicates synchronous processing of the real-time transaction request is complete.

16. A host organization comprising:

a processor and a memory;

a web-server to execute via the processor and the memory of the host organization;

wherein the web-server is to receive a bulk transaction request from a client communicatively interfaced to the host organization, wherein the bulk transaction request specifies a plurality of database transactions to be processed against a database system of the host organization;

the web-server to send a response from the web-server interface of the host organization to the client device having submitted the bulk transaction request, wherein the response provides at least;

(a) an indication of successful receipt of the bulk transaction request and (b) an acknowledgement that the bulk transaction request is queued for processing or queued for asynchronous processing;

a load analyzer to determine a current computational load of the database system based on a plurality of real-time transaction requests and a plurality of bulk transaction requests awaiting processing via the database system;

a distribution module to distribute for processing via the database system of the host organization, a subset of the plurality of database transactions specified by the bulk transaction request when the current computational load is below a threshold, wherein the plurality of real-time transaction requests are assigned a higher priority than the plurality of bulk transaction requests and are selected for processing against the database system based on the higher priority and further wherein the plurality of bulk transaction requests are assigned a lower priority than the plurality of real-time transaction requests and are selected for processing against the database system based on the lower priority and based further on the determined current computational load of the database system.

17. The host organization of claim 16, further comprising:

a transaction queue to enqueue the bulk transaction request into among a plurality of bulk transaction requests and a plurality of real-time transaction requests in the transaction queue.

18. The host organization of claim 17:

wherein a remaining portion of the plurality of database transactions remain unprocessed; and

wherein the distribution module is to update a bulk transaction results log based on the subset of the plurality of database transactions processed and the remaining portion of the plurality of database transactions unprocessed; and

wherein the distribution module re-queues the bulk transaction request specifying the remaining portion of the plurality of database transactions unprocessed in the transaction queue for later processing.

19. The host organization of claim 16, further comprising:

a results module to send a response to the client device having submitted the bulk transaction request, wherein the response specifies a session identifier assigned to the bulk transaction request, and further wherein the response acknowledges the bulk transaction request is queued for asynchronous processing.

20. The host organization of claim 16:

wherein the web-server to receive a real-time transaction request at the host organization subsequent to receiving the bulk transaction request;

wherein the distribution module to distribute the real-time transaction request for processing against the database system before processing any part of the bulk transaction request based on the higher priority of the real-time transaction request; and

wherein the host organization further comprises a results module to send a response to a client device having submitted the real-time transaction request, wherein the response specifies a result for the real-time transaction request and further wherein the response indicates synchronous processing of the real-time transaction request is complete.