Automatic external data synchronization method

• US 6,141,663 A
• Filed: 03/18/1994
• Issued: 10/31/2000
• 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): AMSBURY, WAYNE P
• Application Number:
  US08/210,320
• Time in Patent Office: 2,419 Days
• Field of Search: 395/600, 707/201
• 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 of synchronizing redundant data in a plurality of dissimilar external electronic database files, comprising the steps of:

(a) for each such external data file, determining the data field and record structure of the database, and creating a format file describing said structure;

(b) determining the addressable location for each such external data file;

(c) for each such external data file, creating a data link file which associates its format file with the text field in a database used to hold the data;

(d) in response to desired modification of any of the data which is held in more than one of said external data files, for each described modification, applying a change to the data in the affected data files;

including;

(e) comparing said change to said format files as associated with each of the said external files to determine which external data files need to be updated;

(f) using link files, format information, and address location to update the data fields in the affected external data files to correspond with the change; and

(g) repeating steps e and f until all affected external data files have been updated to reflect the changed data.

2. A method of synchronizing redundant data in a plurality of dissimilar external electronic database files, comprising the steps of:

(a) for each such external data file, determining the data field and record structure of the database, and creating a format file describing said structure;

(b) determining the addressable location of each external data files;

(c) for each such external data file, creating a data link file associating its format file with the text field in a database used to hold the data;

(d) creating a common database of data field items which are found in common in a plurality of said external data files;

(e) in response to desired changes in any of the data which is held in more than one of said external data files, changing the data in the common database;

(f) for each such change of data in the common database, comparing said change to said format files to determine which external data files need to be updated;

(g) using link files, format information, and address location to update the data fields in the affected external data files to correspond with the change made to the common database; and

(h) repeating steps f and g until all affected external data files have been updated to reflect the changed data.

3. The method of claim 2 wherein the step of creating a format file for each external data file includes identifying the fields, and the field and record delimiters.

4. The method of claim 2 wherein said step of changing the data in the common database includes entering replacement data, comparing it with the previous data, and generating a change object to apply to update the external databases.

5. The method of claim 2 wherein said step of changing the data in the common database includes collecting a number of changes, then scheduling a batch update to the external databases.

6. A system for automatically updating data fields which are used in a plurality of different external target database files which may have differing data structures, comprising:

a computer for performing the data updates, said computer having storage and processing resources, and data communication means operatively connected for selective access to the external target files;

a common database holding data elements which are used in the external target files;

first programmed data means for specifying the data format structure and field identification for each of the external target files;

second programmed data means for linking said data formats with the text fields in external target files used to hold the data;

said computer system including means for entering changes in data elements of said common database to reflect changes in the underlying information represented by the data; and

said computer system including programmed means operative in response to changes in data elements in said common database to use said link and format data to rewrite the affected data fields in the external target files to synchronize them with the common database.