Extensible remote data synchronization

• US 7,487,189 B2
• Filed: 12/19/2003
• Issued: 02/03/2009
• Est. Priority Date: 12/19/2003
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Dournov, Pavel, Whitlock, Donna, Yeates, Anthony J., La Blanc, Sylvester, Hawthorne, Eric
• Primary Examiner(s): Nguyen; Cam-Linh
• Application Number:
  US10/742,463
• Publication Number:
  US 20050137895A1
• Time in Patent Office: 1,873 Days
• Field of Search: 707201-204, 707/10, 714/12, 713/375, 713/400
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

Data replication between a headquarters application and one or more client applications is provided. The client applications are generally located remote from the headquarters application and communicate therewith via known methods. A pair of classes is used to generically transfer data selected for replication. New entity types and/or data types can be synchronized without having to rewrite the synchronization application by simply deploying an appropriate data class and manager class for the new entity. Moreover, the prior art worksheet is abstracted, in some aspects, to a simpler form that is more user friendly.

Claims

1. A retail management system for extensibly replicating information, the retail management system comprising:

a headquarters server application embodied upon a computer storage medium in a computer at a headquarters location, the headquarters server application having a worksheet service that uses a database access layer to read and write data;

at least one remote application embodied upon a computer storage medium in a computer remote from the headquarters location;

a communication link between the headquarters server application and at least one remote application;

a data class, supported by the headquarters server application and the at least one remote application, that encapsulates data about a new entity;

a manager class, supported by the headquarters server application and the at least one remote application, that manages persistence of the data class;

wherein the data class and manager class are implemented to replicate the new entity;

wherein metadata describing the data class is consumed during replication to instantiate a manager class object relative to the new entity; and

wherein the new entity is replicated over the communication link.

2. The system of claim 1, wherein the headquarters server application is coupled to a service that periodically checks for modification to the new entity.

3. The system of claim 1, and further comprising a change tracking table for recording changes to the new entity.

4. The system of claim 3, wherein the headquarters server application is coupled to a service that periodically checks the change tracking table.

5. The system of claim 3, wherein an entry is added to the change tracking table upon a modification to the new entity.

6. The system of claim 5, wherein entries are added periodically based upon a query for modifications to the new entity.

7. The system of claim 5, and further comprising a software trigger to automatically add the entry to the change tracking table.

8. The system of claim 1, wherein the manager class object includes information to instantiate a data object to encapsulate the new entity.

9. The system of claim 8, wherein the data object is transmitted over the link.

10. The system of claim 1, wherein the link includes web services.

11. The system of claim 1, wherein the new entity is compressed prior to transfer.

12. The system of claim 1, wherein the new entity is encrypted prior to transfer.

13. The system of claim 1, wherein the HQ application is coupled to a user interface that provides data views relative to at least one remote application.

14. The system of claim 13, wherein the interface provides data views of all remote applications in an organization.

15. The system of claim 14, wherein the views allow data to be modified.

16. The system of claim 1, wherein the information is business information, and wherein at least one of the remote locations is located at a store.

17. A method of extensibly replicating data between a source and at least one target located remotely from the source, the method comprising:

selecting a new entity for replication between the source and the target;

detecting a modification to the new entity at the source;

instantiating a manager object at the source relative to the modified new entity;

instantiating with the manager object a data object to encapsulate the new entity;

transferring the data object over a link from the source to the target;

instantiating a manager object at the target relative to the data object received over the link; and

using the manager object instantiated at the target to persist the data object.

18. The method of claim 17, wherein the target is a headquarters application.

19. The method of claim 18, wherein the target is a store.

20. The method of claim 17, wherein detecting a modification to the new entity includes checking a tracking table.

21. The method of claim 20, wherein an entry is added to the tracking table when the new entity is modified.

22. The method of claim 21, wherein entries are added periodically based upon a query for modifications to the new entity.

23. The method of claim 21, wherein the entry is automatically added.

24. The method of claim 23, wherein automatically adding entries includes employing a database trigger.

25. The method of claim 17, wherein transferring the data object includes employing web services to transfer the data object.

26. The method of claim 17, wherein the data object is compressed prior to the step of transferring.

27. The method of claim 17, wherein the data object is encrypted prior to the step of transferring.