System and method for asynchronously receiving multiple packets of audit data from a source databased host in a resynchronization mode and asynchronously writing the data to a target host

• US 6,430,577 B1
• Filed: 10/08/1999
• Issued: 08/06/2002
• Est. Priority Date: 10/08/1999
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Unisys Corporation
• Inventors: Hart, Donald Ralph
• Primary Examiner(s): Alam, Hosain T.
• Application Number:
  US09/415,273
• Time in Patent Office: 1,033 Days
• Field of Search: 707/10, 707/201-204, 714/2, 714/4, 714/6, 714/8, 714/10, 714/15-16, 714/19-20, 714/12, 714/33, 709/226, 709/237, 709/239, 709/248
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

In order to obviate data discrepancy between a primary source database and a secondary remote backup database, a Tracker program is used to sense the lack of synchronism between a primary audit file and secondary audit file. Then, a Catch-up program operates to transfer sectioned audit files from the primary to secondary in a parallel transfer mode until the primary and secondary audit files are accurate duplicates of each other, i.e., they are now in synchronism.

Claims

1. A system for synchronizing the audit data of a primary database onto a secondary remote backup database comprising:

(a) transfer means for conveying primary source audit trail files from a primary source host to secondary audit trail files of a secondary host;

(b) sensing means utilizing a Tracker program to determine when said source and remote audit files are no longer in synchronization;

(c) means for dividing each of said source and remote audit files into source sections and remote sections;

(d) means for expediting the transfer of said source audit file sections over to said remote sections utilizing a Catch-up program when a pre-set disparity is sensed by said sensing means;

(e) means for asynchronous and concurrent transfer of said source audit file sections onto said remote backup database said means including;

(e1) multiple parallel port and path means for concurrently transferring multiple groups of audit file sections onto said remote database.

2. The system of claim 1 wherein said transfer means including:

(a1) dedicated port means between said source and remote host to expedite transfer of audit trail files.

3. The system of claim 1 wherein said sensing means includes:

(b1) means to compare the size of the source audit trail file with the size of the remote audit file.

4. The system of claim 1 wherein said means for dividing includes:

(c1) schema means to package each said audit trail files in equally portioned sections.

5. A method for expediting the transfer of sectioned audit files from a source host database to a remote host database when a synchronizing sense parameter indicates an out-of-sync condition between source and remote sectioned audit files, said method comprising the steps of:

(a) initiating a Catch-up procedure to expedite the transfer of source sectioned audit files for placement into said remote host as remote sectioned audit files;

(b) utilizing a parallel transfer process to asynchronously and concurrently convey said remote sectioned audit files onto a remote host database which will duplicate said source host database.

6. A method for expediting the transfer of audit files from a source host database to a remote host database for development of a synchronized remote database which duplicates said source database, said method comprising the steps of:

(a) transferring, via a port means, a set of source audit files over to a remote set of audit files;

(b) partitioning said source audit files for receipt by said remote host as a set of sectioned audit files in equally partitioned sections;

(c) sensing when said remote sectioned audit files are not in synchronization with said source sectioned audit files according to a pre-set parameter indicating amount of non-synchronization;

(d) expediting the transfer of said remote sectioned audit files onto said remote host database via a parallel concurrent asynchronous set of transfer operations on said remote sectioned audit files.