METHOD AND SYSTEM FOR SELECTING AMONGST A PLURALITY OF PROCESSES TO SEND A MESSAGE

• US 20080082586A1
• Filed: 08/31/2007
• Published: 04/03/2008
• Est. Priority Date: 10/02/2006
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Jasik, Benji, Fell, Simon
• Granted Patent: US 8,255,374 B2
• Time in Patent Office: Days
• US Class Current: 707/200
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2358 Change logging, detection, and notification replication G06F16/27
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: H04L 51/02 using automatic reactions or user delegation, e.g. automatic replies or chatbot-generated messages
• CPC Class Codes: H04L 51/42 Mailbox-related aspects, e.g. synchronisation of mailboxes
• CPC Class Codes: H04L 67/55 Push-based network services

Abstract

In accordance with embodiments, there are provided mechanisms and methods for selecting amongst a plurality of processes to send a message (e.g. a message for updating an endpoint system, etc.). These mechanisms and methods for selecting amongst a plurality of processes to send a message can enable embodiments to utilize more than one queue for sending such message. The ability of embodiments to provide such multi-process feature can, in turn, prevent latency that typically accompanies a mounting number of messages.

Claims

1. A method, comprising:

detecting a trigger for automatically sending a message in association with a subscriber of an on-demand database service;

retrieving message information from a portion of a database being managed by the on-demand database service; and

selecting at least one of a plurality of processes for sending the message and the message information.

2. The method of claim 1, wherein the message reflects at least one change made to the database.

3. The method of claim 2, and further comprising determining a type of the at least one change made to the database.

4. The method of claim 3, wherein the message information is conditionally retrieved, based on the determined type of the at least one change made to the database.

5. The method of claim 1, wherein the message is initiated utilizing a workflow rule.

6. The method of claim 1, wherein a plurality of the triggers are different for a plurality of different subscribers of the on-demand database service.

7. The method of claim 1, wherein a plurality of the messages are stored in a queue before being processed.

8. The method of claim 7, wherein a plurality of the messages are retrieved from the queue for processing.

9. The method of claim 7, wherein the messages are grouped according to an associated subscriber of the on-demand database service.

10. The method of claim 9, wherein the messages are grouped utilizing a subscriber identifier.

11. The method of claim 1, wherein a first one of the processes is capable of processing die message faster than a second one of the processes.

12. The method of claim 1, wherein the at least one process is selected based on a subscriber of the on-demand database service associated with the message.

13. The method of claim 12, wherein the at least one process is selected based on a past behavior of the subscriber of the on-demand database service associated with the message.

14. The method of claim 13, wherein the at least one process is selected based on a response time of the subscriber of the on-demand database service associated with the message.

15. The method of claim 1, wherein, in response to the selection of the at least one process, each of a plurality of the messages associated with a subscriber of the on-demand database service is sent utilizing the at least one process.

16. The method of claim 1, wherein, in response to the selection of the at least one process, each of a plurality of messages are stored in a queue associated with the at least one process.

17. The method of claim 16, wherein the at least one process retrieves the message information from the portion of the database for each of the plurality of messages, and sends the message information.

18. The method of claim 1, wherein the at least one process further collects data on responses to the sent message and message information.

19. The method of claim 18, and further comprising reporting the data.

20. The method of claim 1, wherein the trigger is rule-based.

21. The method of claim 1, wherein the message is generated utilizing a web service definition language (WSDL).

22. The method of claim 1, wherein the retrieving includes adding a session identifier to the message information.

23. The method of claim 1, wherein the on-demand database service includes a multi-tenant database system.

24. A machine-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, cause the one or more processors to carry out the steps of:

detecting a trigger for automatically sending a message in association with a subscriber of an on-demand database service;

retrieving message information from a portion of a database being managed by the on-demand database service; and

selecting at least one of a plurality of processes for sending the message and the message information.

25. An apparatus, comprising:

a processor; and

one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of;

detecting a trigger for automatically sending a message in association with a subscriber of an on-demand database service;

retrieving message information from a portion of a database being managed by the on-demand database service; and

selecting at least one of a plurality of processes for sending the message and the message information.

26. A method for transmitting code for use in a multi-tenant database system on a transmission medium, the method comprising:

transmitting code to detect a trigger for automatically sending a message in association with a subscriber of an on-demand database service;

transmitting code to retrieve message information from a portion of a database being managed by the on-demand database service; and

transmitting code to select at least one of a plurality of processes for sending the message and the message information.