System and method for updating a remote database in a network

• US 6,131,096 A
• Filed: 10/05/1998
• Issued: 10/10/2000
• Est. Priority Date: 10/05/1998
• Status: Expired due to Term

• Current Assignee: Blackberry Limited
• Original Assignee: Visto Corporation (Blackberry Limited)
• Inventors: Zhu, Jing, Ng, Mason, Williams, Matt, Cheng, Martin Jr., Ruan, Tom, Quinlan, Sean Michael, Mendez, Daniel J., Riggins, Mark D.
• Primary Examiner(s): Breene, John
• Assistant Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US09/167,044
• Time in Patent Office: 736 Days
• Field of Search: 707/10, 707/3, 707/1, 707/200, 707/203, 709/206, 395/200.33
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A system updates a remote (server) database in a network. The network comprises a global server coupled to a local client and to a remote client. The local client includes a browser for establishing a communications link with a web server on the global server. The global server has server database memory for storing independently modifiable copies of workspace data maintained by personal information managers (PIMS) or other data stores on the local client and has PIM Downloadables for interfacing with these PIMs. The local client requests synchronization capability for a particular PIM. The global server sends a PIM Downloadable corresponding to the particular PIM to the local client, which installs and initiates execution of the PIM Downloadable. Accordingly, a user interface receives information designating a database containing the workspace data to be synchronized and information selecting a synchronization mode such as one-way replace, one-way merge or two-way synchronize. A PIM interface instructs the particular PIM to retrieve the workspace data to be synchronized. A synchronization module determines update data based on the synchronization mode selected and possibly based on a comparison with the contents of the server database. A communications engine delivers the first update data to the global server, which updates the server database accordingly.

Claims

1. A computer-based method, comprising the steps of:

using a browser to receive identification of a downloadable from a computer network;

initiating execution of the downloadable;

receiving information designating workspace data to be synchronized and designating a synchronization mode;

using the Downloadable to instruct a personal information manager (PIM) to retrieve the workspace data to be synchronized;

using the Downloadable to determine first update data based on the workspace data to be synchronized and on the synchronization mode; and

using the Downloadable to deliver the first update data to a server database connected to the computer network.

2. The method of claim 1, wherein the synchronization mode is one of one-way replace, one-way merge and two-way synchronization.

3. The method of claim 1, further comprising the steps of communicating with the server database to learn the server database contents associated with the workspace data to be synchronized, and comparing the server database contents and the workspace data to be synchronized.

4. The method of claim 3, wherein the step of determining first update data is based on the comparison.

5. The method of claim 4, further comprising the steps of determining second update data based on the comparison, and instructing the PIM to modify the workspace data to be synchronized by the second update data.

6. The method of claim 1, further comprising the step of downloading the downloadable from the server database.

7. A system, comprising:

means for using a browser to receive identification of a downloadable from a computer network;

means for initiating execution of the downloadable;

means for receiving information designating workspace data to be synchronized and designating a synchronization mode;

means for using the Downloadable to instruct a personal information manager (PIM) to retrieve the workspace data to be synchronized;

means for using the Downloadable to determine first update data based on the workspace data to be synchronized and on the synchronization mode; and

means for using the Downloadable to deliver the first update data to a server database connected to the computer network.

8. A computer-readable storage medium storing program code for causing a computer to perform the steps of:

using a browser to receive identification of a downloadable from a computer network;

initiating execution of the downloadable;

receiving information designating workspace data to be synchronized and designating a synchronization mode;

using the Downloadable to instruct a personal information manager (PIM) to retrieve the workspace data to be synchronized;

using the Downloadable to determine first update data based on the workspace data to be synchronized and on the synchronization mode; and

using the Downloadable to deliver the first update data to a server database connected to the computer network.

9. A system, comprising:

a downloadable including

a user interface for receiving information designating workspace data to be synchronized and designating a synchronization mode;

a PIM interface for instructing a personal information manager (PIM) to retrieve the workspace data to be synchronized;

a synchronization module coupled to the user interface and the PIM interface for determining first update data based on the workspace data to be synchronized and on the synchronization mode; and

a communications engine coupled to the synchronization module for delivering the first update data to a server database; and

a browser for receiving identification of the downloadable from a computer network, and for initiating execution of the downloadable.

10. The system of claim 9, wherein the synchronization mode is one of one-way replace, one-way merge and two-way synchronization.

11. The system of claim 9, wherein the synchronization module learns the server database contents corresponding to the workspace data to be synchronized, and compares the server database contents and the workspace data to be synchronized.

12. The system of claim 11, wherein the synchronization module determines the first update data based on the comparison.

13. The system of claim 12, wherein the synchronization module determines second update data based on the comparison, and instructs the PIM to modify the workspace data to be synchronized by the second update data.

14. The system of claim 9, wherein the Downloadable is downloaded from the server database.

15. Program code embodied in a carrier wave for controlling a computer to perform the steps of:

receiving information designating workspace data to be synchronized and a synchronization mode;

instructing a personal information manager (PIM) to retrieve the workspace data to be synchronized;

determining first update data based on the workspace data to be synchronized and on the synchronization mode; and

delivering the first update data to a server database.

16. A computer-based method, comprising the steps of:

storing workspace data and a Downloadable;

establishing a communications link with a client;

receiving a request for synchronization capability from a client;

forwarding the Downloadable which includes the synchronization capability to the client for installation;

receiving update data from the Downloadable; and

updating the workspace data based on the update data received.

17. The method of claim 16, wherein the method is performed by a server coupled via a network to the client.

18. The method of claim 16, wherein the workspace data is contained in a user data store.

19. The method of claim 16, wherein the step of establishing a communications link with a client includes using URL technology.

20. The method of claim 16, wherein the request for synchronization capability includes information identifying a particular PIM for which synchronization is desired.

21. The method of claim 20, wherein the information includes identification of a service, and wherein the particular PIM corresponding to the service is known.

22. The method of claim 21, further comprising the step of retrieving a Downloadable corresponding to the particular PIM.

23. The method of claim 22, wherein the Downloadable retrieved includes an interface to the particular PIM.

24. The method of claim 16, wherein the Downloadable includes a user interface for enabling a user to select a synchronization mode and to designate a database containing workspace data to be synchronized.

25. The method of claim 16, wherein the Downloadable includes a synchronization module for computing the update data.

26. The method of claim 25, wherein the synchronization module computes the update data based on one of one-way replace, one-way merge and two-way synchronization.

27. A system, comprising:

means storing workspace data and a Downloadable;

means for establishing a communications link with a client;

means for receiving a request for synchronization capability from the client;

means for forwarding a Downloadable which includes the synchronization capability to the client for installation;

means for receiving update data from the Downloadable; and

means for updating the workspace data based on the update data received.

28. A system, comprising:

memory storing workspace data and a PIM Downloadable;

a web server for establishing a communications link with a client;

a personal information manager (PIM) Downloadable retrieval engine coupled to the memory for receiving a request for synchronization capability from the client, and for forwarding the PIM Downloadable which includes the synchronization capability to the client for installation; and

a user data store manager coupled to the memory for receiving update data from the Downloadable, and for updating the workspace data based on the update data received.

29. The system of claim 28, wherein the workspace data is contained in a user data store.

30. The system of claim 28, wherein the web server establishes a communications link with a client using URL technology.

31. The system of claim 28, wherein the request for synchronization capability includes information identifying a particular PIM for which synchronization is desired.

32. The system of claim 31, wherein the information includes identification of a service, and wherein the particular PIM corresponding to the service is known.

33. The system of claim 32, wherein the memory stores a plurality of PIM Downloadables and wherein the PIM Downloadable retrieval engine retrieves a Downloadable corresponding to the particular PIM.

34. The system of claim 33, wherein the PIM Downloadable retrieved includes an interface to the particular PIM.

35. The system of claim 28, wherein the PIM Downloadable includes a user interface for enabling a user to select a synchronization mode and to designate a database containing the workspace data to be synchronized.

36. The system of claim 28, wherein the Downloadable includes a synchronization module for computing the update data.

37. The system of claim 36, wherein the synchronization module computes the update data based on one of one-way replace, one-way merge and two-way synchronization.

38. A computer-based method, comprising the steps of:

establishing a communications link with a server storing workspace data;

receiving identification of a PIM Downloadable;

executing the PIM Downloadable to instruct a personal information manager (PIM) to retrieve PIM data; and

executing the PIM Downloadable to update the workspace data stored on the server based on the retrieved PIM data.

39. The method of claim 38, further comprising the step of requesting synchronization capability for a particular PIM.

40. The method of claim 39, further comprising the steps of receiving and installing the PIM Downloadable from the server.

41. The method of claim 38, wherein the PIM Downloadable has already been installed.

42. The method of claim 39, wherein the step of requesting synchronization capability includes information identifying a particular PIM for which synchronization is desired.

43. The method of claim 42, wherein the information includes identification of a service, and wherein the particular PIM corresponding to the service is known.

44. The method of claim 38, wherein the PIM Downloadable includes an interface to the PIM.

45. The method of claim 38, wherein the PIM Downloadable includes a user interface for enabling a user to select a synchronization mode and to designate a database containing the workspace data to be synchronized.

46. The method of claim 38, wherein the Downloadable includes a synchronization module for computing the update data.

47. The method of claim 46, wherein the synchronization module computes the update data based on one of one-way replace, one-way merge and two-way synchronization.

48. A system, comprising:

an installed PIM interface downloadable associated with the identification for instructing a PIM to retrieve PIM data;

an installed synchronization module downloadable coupled to the PIM interface for determining update data based on the PIM data retrieved, and for forwarding the update data to the server to update the workspace data; and

a browser for establishing a communications link with a server storing workspace data, for receiving identification of the PIM interface downloadable and the synchronization module downloadable, and for initiating execution of the downloadables.

49. A method, comprising the steps of:

using a browser to receive identification of a downloadable from a computer network;

initiating execution of the downloadable;

receiving information designating workspace data to be synchronized and designating a synchronization mode;

using the Downloadable to retrieve the workspace data to be synchronized;

using the Downloadable to determine first update data based on the workspace data to be synchronized and on the synchronization mode; and

using the Downloadable to deliver the first update data to a server database connected to the computer network.