MAINTAINING APPLICATIONS THAT ARE OCCASIONALLY CONNECTED TO AN ONLINE SERVICES SYSTEM

• US 20110302135A1
• Filed: 07/16/2010
• Published: 12/08/2011
• Est. Priority Date: 06/07/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Prophete, Didier, Gasn, Marni, Agarwal, Anshu, Fischer, Ronald, Movida, Mark, Kesel, Artur, Hardikar, Amol, Pathak, Madhav, Rohde, S+e,uml o+ee nke, Spohn, Markus, Oblucki, Krystof
• Granted Patent: US 8,407,184 B2
• Time in Patent Office: Days
• 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

2-1. 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.

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; and

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

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:

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 at least one of replication of an entity at a database and 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; and

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 the user to be replicated at the software application.

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

one or more stored 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.

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

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 at least one of replication of an entity at a database and synchronizing data at the application database with data at the online services database in accordance with the detected change.

18. The computer-readable storage medium 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 computer-readable storage medium 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 computer-readable storage medium 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.