System and Method for Resolving Conflicts Between an Offline Web-Based Application and an Online Web-Based Application

• US 20090070388A1
• Filed: 04/14/2008
• Published: 03/12/2009
• Est. Priority Date: 07/31/2007
• Status: Abandoned Application

• Current Assignee: Etelos, Incorporated
• Original Assignee: Etelos, Incorporated
• Inventors: Collette, Jon K., Kolke, Daniel J., Baitalmal, Ahmad
• Application Number:
  US12/102,854
• Publication Number:
  US 20090070388A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/954 Navigation, e.g. using categorised browsing
• CPC Class Codes: H04L 67/1095 Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes

Abstract

A system and a method for executing a web-based application on a client computer system without a network connection to an application server that hosts the web-based application is presented. In these embodiments, the web-based application can provide functionality substantially similar to the functionality of the web-based application when the client computer system has a network connection to the application server. A system and method for synchronizing and resolving conflicts between an online and an offline web-based application is also presented.

Claims

1. A method, comprising:

on a first computer system that is disconnected from an application server,

using a web-based application that is configured to interact over a network connection with the application server to provide specified functionality;

when the network connection is reestablished, synchronizing changes made to the web-based application while the first computer system was disconnected from the application server; and

if a conflict between the first computer system and the application server exists, resolving the conflict so that both the first computer system and the application server are synchronized with each other.

2. The method of claim 1, wherein a conflict exists if the first computer system includes a first set of records that are not included on the application server, and wherein resolving the conflict so that both the first computer system and the application server are synchronized with each other involves:

sending the first set of records to the application server;

receiving new identifiers for the first set of records, wherein the new identifiers are assigned by the application server when the first set of records are added to the application server; and

updating all references to the old identifiers for the first set of records with the new identifiers for the first set of records.

3. The method of claim 1, wherein a conflict exists if the application server includes a second set of records that are not included on the first computer system, and wherein resolving the conflict so that both the first computer system and the application server are synchronized with each other involves:

receiving the second set of records from the application server;

determining whether identifiers for the second set of records are already being used by the first computer system; and

if the identifiers for the second set of records are not being used by the first computer system, inserting the second set of records.

4. The method of claim 3, wherein if the identifiers for the second set of records are already being used by the first computer system, the method further comprises:

determining a third set of records which include identifiers which conflict with the identifiers for the second set of records;

sending the third set of records to the application server;

receiving new identifiers for the third set of records, wherein the new identifiers are assigned by the application server when the third set of records are added to the application server;

updating all references to the old identifiers for the third set of records with the new identifiers for the third set of records; and

inserting the second set of records.

5. The method of claim 1, wherein if a conflict between the first computer system and the application server does not exist, the method further comprises updating records on the first computer system so that the first computer system is synchronized with the application server.

6. A system, comprising:

one or more processors;

memory; and

one or more programs stored in the memory, the one or more programs comprising instructions to;

on a first computer system that is disconnected from an application server,

use a web-based application that is configured to interact over a network connection with the application server to provide specified functionality;

when the network connection is reestablished, synchronize changes made to the web-based application while the first computer system was disconnected from the application server; and

if a conflict between the first computer system and the application server exists, resolve the conflict so that both the first computer system and the application server are synchronized with each other.

7. A computer readable storage medium storing one or more programs for execution by a computer, the one or more programs comprising instructions to:

on a first computer system that is disconnected from an application server,

use a web-based application that is configured to interact over a network connection with the application server to provide specified functionality;

when the network connection is reestablished, synchronize changes made to the web-based application while the first computer system was disconnected from the application server; and

if a conflict between the first computer system and the application server exists, resolve the conflict so that both the first computer system and the application server are synchronized with each other.

8. A method, comprising:

creating a first set of records with a corresponding first set of identifiers in a first database;

synchronizing the first database with a second database;

if the corresponding first set of identifiers already exists in the second database,

receiving a new set of identifiers for the first set of records from the second database, wherein the new set of identifiers is assigned to the first set of records when the first set of records is added to the second database; and

updating all references to the corresponding first set of identifiers for the first set of records with the new set of identifiers for the first set of records.

9. The method of claim 8, wherein if the corresponding first set of identifiers does not exist in the second database, the first set of records is inserted into the second database using the corresponding first set of identifiers.

10. The method of claim 8, wherein if the second database includes a second set of records that does not exist in the first database, the method further comprises:

receiving the second set of records from the second database;

sending the first set of records to the second database;

receiving new identifiers for the first set of records, wherein the new identifiers are assigned by the second database when the first set of records are added to the second database;

updating all references to the old identifiers for the first set of records with the new identifiers for the first set of records; and

inserting the second set of records.

11. The method of claim 8, wherein the first database and the second database are used for a web-based application that requires a network connection with an application server to provide specified functionality.

12. The method of claim 8, wherein the web-based application was not designed to be used without a network connection to the application server.

13. The method of claim 8, wherein the first database is on a client computer system.

14. The method of claim 8, wherein the second database is on an application server.

15. A system, comprising:

one or more processors;

memory; and

one or more programs stored in the memory, the one or more programs comprising instructions to;

create a first set of records with a corresponding first set of identifiers in a first database;

synchronize the first database with a second database;

if the corresponding first set of identifiers already exists in the second database,

receive a new set of identifiers for the first set of records from the second database, wherein the new set of identifiers is assigned to the first set of records when the first set of records is added to the second database; and

update all references to the corresponding first set of identifiers for the first set of records with the new set of identifiers for the first set of records.

16. A computer readable storage medium storing one or more programs for execution by a computer, the one or more programs comprising instructions to:

create a first set of records with a corresponding first set of identifiers in a first database;

synchronize the first database with a second database;

if the corresponding first set of identifiers already exists in the second database,

receive anew set of identifiers for the first set of records from the second database, wherein the new set of identifiers is assigned to the first set of records when the first set of records is added to the second database; and

update all references to the corresponding first set of identifiers for the first set of records with the new set of identifiers for the first set of records.