METHODS AND SYSTEMS FOR POLLING AN ON DEMAND SERVICE

• US 20100205243A1
• Filed: 09/14/2009
• Published: 08/12/2010
• Est. Priority Date: 09/12/2008
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Brady, David
• Granted Patent: US 8,407,338 B2
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: H04L 2209/043 of tables, e.g. lookup, substitution or mapping
• CPC Class Codes: H04L 9/3213 using tickets or tokens, e.g. Kerberos network architectures or network communication protocols for entities authentication using tickets in a packet data network H04L63/0807
• CPC Class Codes: H04L 9/3271 using challenge-response
• CPC Class Codes: H04L 9/3297 involving time stamps, e.g. generation of time stamps

Abstract

Systems and methods for automatically polling for data changes in an on-demand database service environment. A polling server communicates with application servers and client systems. Application servers send update messages to the polling server identifying which database objects have been updated, and client systems communicate with the polling server on a regular basis, rather than with the application server, to determine whether updates to a data object may have been made. When it has been determined that an update may have been made, the client system then sends a refresh request to the application server to request an update to the data object, thereby controlling (e.g., reducing) the number of refresh requests sent to the application server.

Claims

1. A method of controlling a number of object update requests sent from a client system to an application server, the method comprising the steps of:

receiving a request in a polling server from a client system, the request including data identifying a first user and an object provided to the client system by an application server;

determining in the polling server whether an update message related to the object has been received by the polling server from the application server; and

if so

sending a response from the polling server to the client system, the response including information usable by the client system to determine if new or updated information related to the object is available on the application server.

2. The method of claim 1, wherein the request further includes authentication information associated with the object, and wherein the method further includes determining whether the request is authentic based on the authentication information before sending the response.

3. The method of claim 2, further including sending an authentication request, including the authentication information, from the polling server to the application server, and receiving an authentication response from the application server, the authentication response identifying whether the authentication information is authenticated.

4. The method of claim 3, further including storing to cache in the polling server whether the authentication information is authenticated.

5. The method of claim 2, wherein determining whether the request is authentic includes authenticating the request based on information stored in cache on the polling server.

6. The method of claim 1, further including receiving at the application server an update request from the client system responsive to the client system processing the response to determine that new or updated information related to the object is available on the application server.

7. The method of claim 1, wherein the object is a web page provided by the application server.

8. The method of claim 1, wherein the response sent to the client system includes timestamp information for the object.

9. The method of claim 1, wherein the client system is communicably coupled with the application server and the polling server over the internet.

10. The method of claim 1, wherein the application server is communicably coupled with the polling server over the internet or a direct network connection.

11. The method of claim 1, wherein determining includes accessing an update table stored on the polling server, the update table including objects and related update information received from the application server in update messages.

12. A database system configured to control a number of object update requests sent from client systems to an application server, the system comprising:

an application server communicably coupled with a database that stores data objects, the application server being configured to provide data objects to client systems and to update data objects responsive to requests from client systems; and

a polling server communicably coupled with the application server, the polling server configured to receive polling requests from client systems and to receive update messages from the application server; and

a client system executing code that causes the client system to periodically send polling requests to the polling server,

wherein upon updating an object, the application server sends an update message to the polling server identifying the object updated;

wherein upon receiving a request from the client system identifying a specific object, the polling server sends a response to the client system including an indication of whether the specific object has been updated, and

wherein upon receipt of the response, the client system sends an update request message to the application server requesting updated data for the specific object.

13. The system of claim 12, wherein the request from the client includes information identifying a user and information identifying an object.

14. The system of claim 13, wherein the request from the client further includes session identification information, wherein the polling server upon receipt of the request authenticates whether the request is valid based on the session id information.

15. The system of claim 14, wherein the polling server authenticates the request by sending an authentication message to the application server.

16. The system of claim 14, wherein the polling server authenticates the request by checking a cache that stores authentication information by session id.

17. The system of claim 12, wherein an update message includes timestamp information, and wherein the response sent to the client system by the polling server includes the timestamp information for the specific object, wherein upon receipt of the request, the client system determines whether the specific object has been updated based on the timestamp information.

18. The system of claim 12, wherein the application server responds to the update request with updated data for the specific object.

19. The system of claim 12, wherein the code executing on the client system is part of the specific object provided to the client system by the application server.

20. The system of claim 12, wherein the code executing on the client system is received with the specific object provided to the client system by the application server.

21. A tangible computer readable medium that stores code for controlling one or more processors to enable controlling a number of object update requests sent from a client system to an application server, the code including instructions to:

receive a request in a polling server from a client system, the request including data identifying a first user and an object provided to the client system by an application server;

determine in the polling server whether an update message related to the object has been received by the polling server from the application server; and

if so

send a response from the polling server to the client system, the response including information usable by the client system to determine if new or updated information related to the object is available on the application server.