Automatic external data synchronization method
First Claim
Patent Images
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.
1 Assignment
0 Petitions
Accused Products
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.
-
Citations
6 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. - View Dependent Claims (3, 4, 5)
-
-
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.
-
Specification