Maintaining applications that are occasionally connected to an online services system

• US 8,407,184 B2
• Filed: 07/16/2010
• Issued: 03/26/2013
• Est. Priority Date: 06/07/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Prophete, Didier, Fischer, Ronald, Movida, Mark, Kesel, Artur, Hardikar, Amol, Pathak, Madhav, Spohn, Markus, Gasn, Marni, Agarwal, Anshu, Rohde, Snke, Oblucki, Krzysztof
• Primary Examiner(s): Reyes, Mariela
• Assistant Examiner(s): ALLEN, NICHOLAS E
• Application Number:
  US12/838,388
• Publication Number:
  US 20110302135A1
• Time in Patent Office: 984 Days
• Field of Search: 707/600, 707/602, 707/610, 707/615, 707/619, 707/626, 707/634
• US Class Current: 707/634
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

In a method for maintaining applications that are occasionally connected to an online services system, metadata describing at least a portion of an online services database is retrieved and the portion of the online services database is authorized for replication at a software application, information for an entity for an application database in accordance with metadata is determined, information is sent for the entity to an application data management service, data for the software application is retrieved from the online services database in accordance with metadata, at least a portion of the data for the software application is sent to the application data management service and the portion of the data for the software application should be synchronized with the online services database, a request for information is received for rendering a component of a user interface, and information is provided for rendering the component of the user interface for the software application.

Claims

1. A method for maintaining applications that are occasionally connected to an online services system, the method comprising:

retrieving metadata describing at least a portion of an online services database, wherein the at least a portion of the online services database is authorized for replication at a software application;

determining information for an entity for an application database in accordance with metadata;

sending information for the entity to an application data management service;

retrieving data for the software application from the online services database in accordance with metadata;

sending at least a portion of the data for the software application to the application data management service, wherein the at least a portion of the data for the software application should be synchronized with the online services database;

receiving a request for information for rendering a component of a user interface;

providing information for rendering the component of the user interface for the software application;

receiving an indication that an online services system is available over a network;

detecting a change of at least one of data for the application database and metadata; and

replicating the entity at the application database in accordance with the detected change.

2. The method of claim 1, further comprising:

synchronizing data at the application database with data at the online services database in accordance with the detected change.

3. The method of claim 1, further comprising:

translating a command for an operation executed at the application database into a command for an online services database; and

resolving any conflicts with operations executed against software application database and data retrieved.

4. The method of claim 1, further comprising:

translating a command for an operation executed at the application database on a bug management entity into a command for an operation on the online services database; and

sending the command for the operation on the online services database.

5. The method of claim 1, further comprising:

detecting software application not connected to the online services system;

receiving a request to perform an operation; and

performing operation on data at application database.

6. The method of claim 1, further comprising:

determining information for at least a portion of the schema for an application database in accordance with metadata; and

sending information to an application data management service to replicate online services database.

7. The method of claim 1, further comprising:

receiving information authenticating a user.

8. A computer-readable storage medium having one or more instructions thereon for maintaining applications that are occasionally connected to an online services system, the instructions when executed by one or more processors causing the one or more processors to carry out:

retrieving metadata describing at least a portion of an online services system database, wherein the at least a portion of the online services system database is authorized for replication at a software application;

determining information for an entity for an application database in accordance with metadata;

sending information for the entity to an application data management service;

retrieving data for the software application from the online services database in accordance with metadata;

sending at least a portion of the data for the software application to the application data management service, wherein the at least a portion of the data for the software application should be synchronized with the online services system database;

receiving a request for information for rendering a component of a user interface;

providing information for rendering the component of the user interface for the software application;

receiving an indication that an online services system is available over a network;

detecting a change of at least one of data for the application database and metadata; and

replicating of the entity at the application database in accordance with the detected change.

9. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

synchronizing data at the application database with data at the online services database in accordance with the detected change.

10. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

translating a command for an operation executed at the application database into a command for an online services database.

11. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

resolving any conflicts with operations executed against software application database and data retrieved.

12. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

translating a command for an operation executed at the application database on a bug management entity into a command for an operation on the online services database; and

sending the command for the operation on the online services database.

13. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

detecting software application not connected to the online services system;

receiving a request to perform an operation; and

performing operation on data at application database.

14. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

determining information for at least a portion of the schema for an application database in accordance with metadata; and

sending information to an application data management service to replicate online services database.

15. The computer-readable storage medium of claim 8, further comprising one or more instructions when executed by one or more processors causing the one or more processors to carry out:

receiving information authenticating a user.

16. An apparatus for maintaining applications that are occasionally connected to an online services system in a multi-tenant database system, the apparatus comprising:

a processor; and

a non-transitory computer readable storage medium storing one or more sequences of instructions which, when executed by the processor, cause the processor to carry out;

retrieving metadata describing at least a portion of an online services system database, wherein the at least a portion of the online services system database is authorized for replication at a software application;

determining information for an entity for an application database in accordance with metadata;

sending information for the entity to an application data management service;

retrieving data for the software application from the online services database in accordance with metadata;

sending at least a portion of the data for the software application to the application data management service, wherein the at least a portion of the data for the software application should be synchronized with the online services system database;

receiving a request for information for rendering a component of a user interface; and

providing information for rendering the component of the user interface for the software application;

receiving an indication that an online services system is available over a network;

detecting a change of at least one of data for the application database and metadata; and

performing replication of the entity at the application database in accordance with the detected change.

17. The apparatus of claim 16, further comprising one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out:

synchronizing data at the application database with data at the online services database in accordance with the detected change.

18. The apparatus of claim 16, further comprising one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out:

translating a command for an operation executed at the application database into a command for an online services database.

19. The apparatus of claim 16, further comprising one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out:

resolving any conflicts with operations executed against software application database and data retrieved.

20. The apparatus of claim 16, further comprising one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out:

translating a command for an operation executed at the application database on a bug management entity into a command for an operation on the online services database; and

sending the command for the operation on the online services database.