SYNCHRONIZATION OF A CONCEPTUAL MODEL VIA MODEL EXTENSIONS

• US 20100106684A1
• Filed: 08/19/2009
• Published: 04/29/2010
• Est. Priority Date: 10/26/2008
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Castro, Pablo M., Novik, Lev, Pizzo, Michael J., Muhunthan, Siva
• Application Number:
  US12/544,125
• Publication Number:
  US 20100106684A1
• Time in Patent Office: Days
• US Class Current: 707/610
• CPC Class Codes: G06F 16/275 Synchronous replication

Abstract

A method of synchronizing data between multiple endpoints each storing a copy of the data in accordance with different underlying schemas. An application model that provides a logical representation of an underlying schema is extended with a synchronization model that provides a logical representation of changes made to the data. The synchronization model comprises functions that provide synchronization information on the changes in a common format. Using such synchronization information, changes in a copy of the data stored in a first underlying schema on a first endpoints are applied to another copy of the data stored in a second underlying schema on a second endpoint in synchronization relationship with the first endpoint.

Claims

1. A method of representing data changes in a common format on multiple endpoints, the method comprising:

obtaining, through a first function of a set comprising a plurality of functions that provide information on the changes in the common format, synchronization data on changes to a first copy of data stored in a first underlying schema in a first data store of a first endpoint;

communicating the synchronization data to a second endpoint;

applying the synchronization data to a second function of the set of functions on the second endpoint; and

applying the changes, via the second function, to a second copy of the data stored in a second underlying schema in a second data store of the second endpoint.

2. The method of claim 1, wherein:

data in the first data store and the second data store is represented as a plurality of logical entities representing entities and entity relationships within the data;

a first application executing on the first endpoint utilizes the plurality of logical entities to access the first copy of the data; and

a second application executing on the second endpoint utilizes the plurality of logical entities to access the second copy of the data.

3. The method of claim 2, wherein at least a portion of the plurality functions of the set each receives as an argument a logical entity of the plurality of logical entities.

4. The method of claim 1, wherein the plurality functions comprises at least one of functions for reading the synchronization data and functions for writing the synchronization data.

5. The method of claim 4, wherein the functions for reading the synchronization data comprise entity sets for reading the synchronization data and the functions for writing the synchronization data comprise an ability to update entity sets for writing the synchronization data.

6. The method of claim 1, wherein the plurality functions comprise functions for enumerating the changes, in response to a query including parameters.

7. The method of claim 6, wherein the functions for enumerating the changes can be used to perform a join operation comprising combining information from the data and the synchronization data on the changes in accordance with the parameters.

8. The method of claim 6, wherein the changes comprise at least one of an update, an insertion or a deletion of a record in the copy of the data stored in the first underlying format.

9. The method of claim 6, wherein the parameters comprise at least one of a request to obtain information on a time when the changes were done, a source of the changes and a reason for the changes.

10. The method of claim 1, wherein the synchronization data comprises synchronization metadata on a version of the copy of the data stored in the first underlying format.

11. The method of claim 1, wherein

the plurality of logical entities representing entities and entity relationships within the data comprises an application model,

the plurality of functions comprises a synchronization model, and

the synchronization model is an extension of the application model.

12. The method of claim 1, wherein the synchronization data is available outside of the second endpoint.

13. The method of claim 1, wherein the first endpoint and the second endpoint comprise different change tracking mechanisms.

14. A computer-readable medium having a plurality of computer-executable modules that when executed on at least one processor perform synchronization of copies of data stored on multiple data stores, the computer-executable modules comprising:

an underlying data store module for storing a copy of data in a first underlying format;

an application data model module for mapping a plurality of logical entities to the data in the underlying data store; and

an synchronization data model module providing an interface for;

accessing synchronization metadata on changes to the data in terms of changes to the plurality of logical entities, through a plurality of functions on an endpoint that provide the information on the changes in a common format, and

applying, through the plurality of functions, changes to the data in accordance with changes made to a second copy of the data stored in a second underlying format.

15. A computer-readable medium of claim 14, wherein the application data model represents the data as the plurality of logical entities representing entities and entity relationships within the data.

16. A computer-readable medium of claim 15, wherein the synchronization data model represents the changes to the data though changes to the plurality of logical entities.

17. In a computer system comprising a plurality of endpoints each storing a copy of data and a synchronization component for synchronizing the data between the plurality of endpoints, a method comprising:

obtaining, through a first function of a set comprising a plurality of functions that provide information on the changes in a common format, synchronization data on changes to a first copy of the data stored in a first underlying schema in a first data store of a first endpoint of the plurality of endpoints;

communicating the synchronization data to a second endpoint of the plurality of endpoints;

applying the synchronization data to a second function of the set of functions on the second endpoint; and

applying changes, via the second function, to a second copy of the data stored in a second underlying schema in a second data store of the second endpoint, wherein applying the changes comprises applying changes to the data and synchronization metadata.

18. The method of claim 17, wherein:

data in the first data store and the second data store is represented as a plurality of logical entities representing entities and entity relationships within the data;

a first application executing on the first endpoint utilizes the plurality of logical entities to access the first copy of the data; and

a second application executing on the second endpoint utilizes the plurality of logical entities to access the second copy of the data.

19. The method of claim 18, wherein at least a portion of the plurality functions of the set each receives as an argument a logical entity of the plurality of logical entities.

20. The method of claim 17, wherein the synchronization metadata comprises data on least one of an insertion, deletion or an update to the data, and wherein the method further comprises initiating at least one trigger to record the data on the least one of the insertion, the deletion and the update.