Synchronizing differing data formats

• US 7,213,039 B2
• Filed: 09/07/2001
• Issued: 05/01/2007
• Est. Priority Date: 09/07/2001
• Status: Expired due to Term

• Current Assignee: Extended Systems Inc. (SAP SE)
• Original Assignee: Extended Systems Inc. (SAP SE)
• Inventors: Jeide, Scott A., Ramanujam, Srinivasan
• Primary Examiner(s): LE, UYEN T
• Application Number:
  US09/949,313
• Publication Number:
  US 20030050910A1
• Time in Patent Office: 2,062 Days
• Field of Search: 707/1, 707/100, 707/200, 707/203, 709/248
• US Class Current: 1/1
• CPC Class Codes: G06F 16/275 Synchronous replication
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

A system and method for synchronizing records stored in differing formats in a shared data environment. One aspect of the invention involves distinguishing a record without regard to its format. Once a record is introduced into the environment, it is detected. A record tag, unique to the environment, is generated and associated with the record. When synchronizing, only those records with equivalent record tags are compared and updated.

Claims

1. A method for distinguishing a record in a shared data environment that includes plural data stores each associated with a different device, comprising:

in a particular one of the data stores, detecting a record new to the shared data environment, the detected record having a local identifier that uniquely identifies and distinguishes the record within the particular data store;

generating a record tag that uniquely identifies the detected record within the shared data environment, the generated record tag being unique in its value, and

associating the record tag with the record wherein associating comprises providing a file in a database associated with the particular data store, the file containing the local identifier, the record tag, and a record status, the local identifier associating the provided file with the detected record.

2. The method of claim 1, wherein the act of generating comprises:

identifying all other record tags in the shared data environment; and

repeatedly generating a new record tag until the generated record tag is different from each of the other identified record tags.

3. The method of claim 1, wherein the particular data store is associated with a data store tag unique to the shared data environment, and wherein the act of generating comprises:

generating a record tag for the detected record by at least in part combining the local identifier with the data store tag.

4. A computer program product for distinguishing a record in a shared data environment that includes plural data stores each associated with a different device, the product comprising a computer useable medium having computer readable instructions thereon for:

in a particular one of the data stores, detecting a record new to the shared data environment, the detected record having a local identifier that uniquely identifies and distinguishes the record within the particular data store;

generating a record tag that uniquely identifies the detected record within the shared data environment, the generated record tag being unique in its value, and

associating the record tag with the record wherein associating comprises providing a file in a database associated with the particular data store, the file containing the local identifier, the record tag, and a record status, the local identifier associating the provided file with the detected record.

5. The computer program product of claim 4, wherein the instructions for generating comprise instructions for:

identifying all other record tags in the shared data environment; and

repeatedly generating a new record tag until the generated record tag is different from each of the other identified record tags.

6. The computer program product of claim 4, wherein the particular data store is associated with a data store tag unique to the shared data environment, and wherein the instructions for generating comprise instructions for:

generating a record tag for the detected record by combining the local identifier with the data store tag.

7. A computer program product for synchronizing records in a shared data environment, the product comprising a computer useable medium having computer readable instructions thereon for:

accessing a first database associated with a first data store, the first database containing a first plurality of files each associated with a different record in the first data store, the first plurality of files including a first file containing a first record tag, a first record status, and a first local identifier;

accessing a second database associated with a second data store, the second database containing a second plurality of files each associated with a different record in the second data store, the second plurality of files including a second file containing a second record tag, a second record status and a second local identifier;

acquiring, from the first file, the first record tag, the first record status and the first local identifier;

acquiring, from the second file, the second record tag, the second record status, and the second local identifier;

comparing the first and second record tags; and

if the first and second record tags are equivalent, synchronizing a first record from the first data store with a second record from the second data store according to the first and second record statuses, wherein the first record is uniquely identified in the first data store by the first local identifier and the second record is uniquely identified in the second data store by the second local identifier.

8. The computer program product of claim 7, wherein;

the instructions for synchronizing comprise instructions for;

modifying the first record to match the second record if the first record status indicates that the first record is new or unchanged and the second record status indicates that the second record has been modified;

deleting the first record if the first record status indicates that the first record is new or unchanged and the second record status indicates that the second record has been deleted;

modifying the second record to match the first record if the second record status indicates that the second record is new or unchanged and the first record status indicates that the first record has been modified; and

deleting the second record if the second record status indicates that the second record is new or unchanged and the first record status indicates that the first record has been deleted.

9. The computer program product of claim 7 wherein the record tags are scalar and wherein the instructions for comparing comprise instructions for performing a scalar comparison of the first and second record tags.

10. The computer program product of claim 7 further comprising instructions for:

detecting records new to the environment; and

for each detected record, generating a record tag and associating that record tag with the record.

11. The computer program product of claim 10, wherein the instructions for generating comprise instructions for:

identifying all other record tags in the shared data environment; and

repeatedly generating a new record tag until the generated record tag is different from each of the other identified record tags.

12. The computer program product of claim 10, wherein the shared data environment includes two or more data stores and each record in the shared data environment is contained within one of the data stores and is associated with a local identifier unique to the data store in which the record is contained, each shared data store being associated with a data store tag that is unique to the shared data environment, and wherein the instructions for generating comprise instructions for:

generating a record tag for the detected record by combining the local identifier for the detected record with the data store tag for the data store containing the detected record.

13. The computer program product of claim 12, further comprising instructions for:

detecting data stores new to the shared data environment; and

for each detected data store, generating a data store tag that is unique to the shared data environment and associating the generated tag with the data store.

14. The computer program product of claim 13, wherein the instructions for generating a data store tag comprise instructions for:

identifying all other data store tags in the shared data environment; and

repeatedly generating a new data store tag until the generated tag is different from each of the other identified data store tags.

15. A method for synchronizing records in a shared data environment, comprising:

providing a first database associated with a first data store, the first database containing a first plurality of files each associated with a different record in the first data store, the first plurality of files including a first file containing a first record tag, a first record status, and a first local identifier;

providing a second database associated with a second data store, the second database containing a second plurality of files each associated with a different record in the second data store, the second plurality of files including a second file containing a second record tag, a second record status and a second local identifier;

acquiring, from the first file, the first record tag, the first record status and the first local identifier;

acquiring, from the second file, the second record tag, the second record status, and the second local identifier;

comparing the first and second record tags; and

if the first and second record tags are equivalent, synchronizing a first record from the first data store with a second record from the second data store according to the first and second record statuses, wherein the first record is uniquely identified in the first data store by the first local identifier and the second record is uniquely identified in the second data store by the second local identifier.

16. The method of claim 15, wherein;

the act of synchronizing comprises;

modifying the first record to match the second record if the first record status indicates that the first record is new or unchanged and the second record status indicates that the second record has been modified;

deleting the first record if the first record status indicates that the first record is new or unchanged and the second record status indicates that the second record has been deleted;

modifying the second record to match the first record if the second record status indicates that the second record is new or unchanged and the first record status indicates that the first record has been modified; and

deleting the second record if the second record status indicates that the second record is new or unchanged and the first record status indicates that the first record has been deleted.

17. The method of claim 15 wherein the record tags are scalar and the act of comparing comprises performing a scalar comparison of the first and second record tags.

18. The method of claim 15 further comprising:

detecting records new to the environment; and

for each detected record, generating a record tag and associating that record tag with the record.

19. The method of claim 18, wherein the act of generating comprises:

identifying all other record tags in the shared data environment; and

repeatedly generating a new record tag until the generated record tag is different from each of the other identified record tags.

20. The method of claim 18, wherein the shared data environment includes two or more data stores and each record in the shared data environment is contained within one of the data stores and is associated with a local identifier unique to the data store in which the record is contained, each shared data store being associated with a data store tag that is unique to the shared data environment, and wherein the act of generating comprises:

generating a record tag for the detected record by combining the local identifier for the detected record with the data store tag for the data store containing the detected record.

21. The method of claim 20, further comprising:

detecting data stores new to the shared data environment; and

for each detected data store, generating a data store tag that is unique to the shared data environment and associating the generated tag with the data store.

22. The method of claim 21, wherein the act of generating a data store tag comprises:

identifying all other data store tags in the shared data environment; and

repeatedly generating a new data store tag until the generated tag is different from each of the other identified data store tags.

23. A system for synchronizing records in a shared data environment, comprising:

a first database associated with a first data store, the first database containing a first plurality of files each associated with a different record in the first data store, the first plurality of files including a first file containing a first record tag, a first record status, and a first local identifier;

a second database associated with a second data store, the second database containing a second plurality of files each associated with a different record in the second data store, the second plurality of files including a second file containing a second record tag, a second record status and a second local identifier;

a single synch engine operable to compare the first and second record tags of the first and second files and, if the first and second record tags are equivalent, to synchronize a first record associated with the first file with a second record associated with the second file according to the first and second record statuses, wherein the first record is uniquely identified in the first data store by a first local identifier from the first file and the second record is uniquely identified in the second data store by a second local identifier from the second file.

24. The system of claim 23, wherein the synch engine is operable to:

modify the first record to match the second record if the first record status indicates that the first record is new or unchanged and the second record status indicates that the second record has been modified;

delete the first record if the first record status indicates that the first record is new or unchanged and the second record status indicates that the second record has been deleted;

modify the second record to match the first record if the second record status indicates that the second record is new or unchanged and the first record status indicates that the first record has been modified; and

delete the second record if the second record status indicates that the second record is new or unchanged and the first record status indicates that the first record has been deleted.

25. The system of claim 23 wherein the record tags are scalar and the synch engine is operable to perform a scalar comparison on the first and second record tags.

26. The system of claim 23 further comprising:

a record detector operable to detect records new to the shared data environment, each detected record having a local identifier that uniquely identifies and distinguishes the record within a data store containing the record; and

a tag generator in communication with the record detector, the tag generator operable to generate a record tag for the detected record, the record tag uniquely identifying the detected record within the shared data environment, and associate the generated record tag with the detected record.

27. The system of claim 26, wherein the tag generator is operable to identify all other record tags in the shared data environment and to repeatedly generate a new record tag until that generated record tag is different from each of the other identified record tags.

28. The system of claim 26 wherein each record in the shared data environment is contained in a data store, the system further comprising:

a data store detector operable to detect data stores new to the shared data environment; and

wherein the tag generator is further operable, for each detected data store, to generate a data store tag and to associate the generated tag with the detected data store.

29. The system of claim 28, wherein the tag generator is operable to identify all other data store tags in the shared data environment and to repeatedly generate a new data store tag until that generated tag is different from each of the other identified data store tags.

30. The system of claim 28, wherein each record in a given data store is associated with a local identifier that uniquely identifies that record within the given data store and wherein the tag generator is operable, for each detected record, to combine the local identifier for that detected record with the data store tag for the data store containing that detected record to generate the record tag.