Method of replicating data records

• US 6,421,686 B1
• Filed: 11/15/1999
• Issued: 07/16/2002
• Est. Priority Date: 11/15/1999
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Martin, James A. Jr.
• Primary Examiner(s): Breene, John
• Assistant Examiner(s): Wong, Leslie
• Application Number:
  US09/440,486
• Time in Patent Office: 974 Days
• Field of Search: 707/201, 707/204, 707/10, 707/6, 707/226
• 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: Y10S 707/99952 Coherency, e.g. same view to multiple users
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

Data records in a source database on a server are replicated to a cross-domain second server. A devoted client is formed having access to both servers. A generic agent manager database is created having one field, one form, one document, and one view. An intermediary agent is created in the generic agent manager database and run against the source database to replicate records to the second server.

Claims

1. A method of replicating records in a source database on a first server to a second database on a cross-domain second server, comprising the steps of:

forming a devoted client having access to said first and second servers;

creating a generic agent manager database on said devoted client having one field, one form, one document, and one view;

creating an intermediary agent in said generic agent manager database; and

running said intermediary agent against said source database on said first server to replicate said records to said second database on said second server.

2. The method as set forth in claim 1, wherein said intermediary agent replicates said records to said second database on said second server by first replicating to a staging replica and then replicates said staging replica to said second database on said second server.

3. The method as set forth in claim 1, wherein said intermediary agent when run performs data processing with said records in said source database and said second database.

4. The method as set forth in claim 1, further comprising forming a lookup view in said source database and said second database and wherein said intermediary agent replicates said records by traversing said lookup view in said source database to modify fields in said second database.

5. A computer system for replicating records in a source database on a first server to a second database on a cross-domain second server, said system comprising:

means for forming a devoted client having access to said first and second servers;

means for creating a generic agent manager database on said devoted client having one field, one form, one document, and one view;

means for creating an intermediary agent in said generic agent manager database; and

means for running said intermediary agent against said source database on said first server to replicate said records to said second database on said second server.

6. The computer system of claim 5, wherein said intermediary agent includes means for replicating said records to said second database on said second server by first replicating to a staging replica and then replicates said staging replica to said second database on said second server.

7. The computer system of claim 5, wherein said intermediary agent includes means for performing data processing with said records in said source database and said second database.

8. The computer system of claim 5, further comprising means for forming a lookup view in said source database and said second database and wherein said intermediary agent replicates said records by traversing said lookup view in said source database to modify fields in said second database.

9. A computer program product for instructing a processor to replicate records in a source database on a first server to a second server, said computer program product comprising:

a computer readable medium;

first program instruction means for forming a devoted client having access to said first and second servers;

second program instruction means for creating a generic agent manager database on said devoted client having one field, one form, one document, and one view;

third program instruction means for creating an intermediary agent in said generic agent manager database; and

fourth program instruction means for running said intermediary agent against said source database on said first server to replicate said records to said second database on said second server; and

wherein

all four said instruction means are recorded on said medium.

10. The computer program product of claim 9, wherein said intermediary agent includes program instruction means for replicating said records to said second database on said second server by first replicating to a staging replica and then replicates said staging replica to said second database on said second server.

11. The computer program product of claim 9, wherein said intermediary agent includes program instruction means which when run performs data processing with said records in said source database and said second database.

12. The computer program product of claim 9, further comprising fifth program instruction means recorded on said medium for forming a lookup view in said source database and said second database and wherein said means for running said intermediary agent includes means for replicating said records by traversing said lookup view in said source database to modify fields in said second database.