Automatic external data synchronization method

• US 5,970,501 A
• Filed: 05/07/1997
• Issued: 10/19/1999
• Est. Priority Date: 03/18/1994
• Status: Expired due to Fees

• Current Assignee: Unimax Systems Corporation
• Original Assignee: Unimax Systems Corporation
• Inventors: Stromquist, Brian R., Hunkins, Andrew D.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Robinson, Greta L.
• Application Number:
  US08/852,665
• Time in Patent Office: 895 Days
• Field of Search: 707/10, 707/204, 707/200, 707/504
• US Class Current: 1/1
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: H04M 2203/554 Data synchronization
• CPC Class Codes: H04M 2203/558 Databases
• CPC Class Codes: H04M 3/2263 Network management
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

Data integrity between multiple databases with redundant data fields is enhanced by a synchronization method which adapts to unspecified database formats by a flexible format definition, identification of a data origin and identification of data targets to significantly improve data integrity and update efficiency in legacy database systems.

Claims

1. A method, comprising the steps of:

assembling a common database representing data in a plurality of external data files;

constructing a link file including a listing of one or more format files, each format file identifying fields of data located in one or more external data files, each external data file having an address; and

modifying data in the plurality of external data files, by the steps including;

generating a project file, by the steps including;

modifying a record in the common database;

generating a change object for the record modified;

storing the change object in the project file; and

repeating the steps of modifying a record, generating a change object, and storing the change object in the project files, until the project file is completed; and

performing update of the plurality of external data files by executing the change objects in the project files, including the steps of;

selecting a change object;

locating the external data files affected by the change object;

modifying the external data files affected by the change object; and

repeating the preceding steps for each change object in the project file.

2. The method of claim 1, where the step of modifying the external data files comprises the step of rewriting the external data files.

3. The method of claim 1, where the step of constructing comprises the step of programming the link file to include one or more system enhanced fields.

4. The method of claim 1, where the step of constructing comprises the step of programming the link file to include one or more user defined fields.

5. The method of claim 1, where the step of constructing comprises the step of programming the link file to include one or more link fields.

6. The method of claim 1, where the step of performing update comprises the step of scheduling a batch update to the external databases.

7. The method of claim 1, where the step of modifying a a record comprises the steps of:

retrieving a record from the common database;

entering replacement data into the record;

comparing the replacement data to data in the record prior to entering replacement data; and

generating a change object based on differences between the replacement data and the data in the record prior to entering replacement data.

8. The method of claim 1, where the step of locating comprises the steps of:

opening the link file;

opening a particular format file in the link file;

comparing the change object to the fields of data in the particular format file; and

if the change object relates to the fields of data in the particular format file, then opening its associated external data files and changing the external data files according to the change object.

9. The method of claim 8, further comprising the step of repeating the steps of comparing, opening its associated external data files, and changing, for each external data file associated with the particular format file.

10. The method of claim 9, further comprising the step of:

repeating the steps of opening a particular format file, comparing, opening its associated external data files, and changing, for each format file in the link file.

11. A method for updating data in a plurality of external data files, comprising the steps of:

generating a project file, by the steps including;

generating a change object for each record modified in a common database; and

storing each change object in a project file; and

performing update of the plurality of external data files by executing the change objects in the project file, including the steps of;

selecting a change object;

locating the external data files affected by the change object;

modifying the external data files affected by the change object; and

repeating the preceding steps for each change object in the project file.

12. The method of claim 11, further comprising the step of rewriting the external data files.

13. The method of claim 11, where the step of performing update further comprises the step of scheduling a batch update to the external databases.

14. The method of claim 11, where the step of modifying comprises the steps of:

retrieving a record from the common database;

entering replacement data into the record;

comparing the replacement data to data in the record prior to entering replacement data; and

generating a change object based on differences between the replacement data and the data in the record prior to entering replacement data.

15. The method of claim 11, where the step of locating comprises the steps of:

opening a link file, the link file including a listing of one or more format files, each format file identifying fields of data located in one or more external data files;

opening a particular format file in the link file;

comparing the change object to the fields of data in the particular format file; and

if the change object relates to the fields of data in the particular format file, then opening its associated external data files and changing the external data files according to the change object.

16. The method of claim 15, further comprising the step of programming the link file to include one or more system enhanced fields.

17. The method of claim 15, further comprising the step of programming the link file to include one or more user defined fields.

18. The method of claim 15, further comprising the step of programming the link file to include one or more link fields.

19. The method of claim 15, further comprising the step of repeating the steps of comparing, opening its associated external data files, and changing, for each external data file associated with the particular format file.

20. The method of claim 19, further comprising the step of:

repeating the steps of opening a particular format file, comparing, opening its associated external data files, and changing, for each format file in the link file.

21. A system for updating a plurality of data files, comprising:

a computer;

common database, accessible by the computer, the common database including a file structure representing a copy of the plurality of data files;

one or more link files, accessible by the computer, the link files including data format information and link information for associating a file in the common database with one or more of the plurality of data files;

an input device receiving modifications to one or more files in the common database; and

an update device, recognizing modifications to the one or more files in the common database and updating the one or more of the plurality of data files based on the link information.

22. The system of claim 21, where the plurality of data files exist on different devices, and where the computer has access to the different devices.

23. The system of claim 21, further comprising:

a system for batch update of the one or more of the plurality of data files.

24. The system of claim 21, where the one or more link files include addresses for the one or more of the plurality of data files.

25. The system of claim 21, where the update device is programmed to update the one or more of the plurality of data files with text modifications to one or more files in the common database.

26. The system of claim 21, where the update device is programmed to update the one or more of the plurality of data files with data format modifications to one or more files in the common database.

27. The system of claim 26, where the one or more of the plurality of data files is updated by rewriting data files.