System and Method for Dynamic and On-Demand Data Transfer and Synchronization Between Isolated Networks

• US 20080133543A1
• Filed: 11/30/2007
• Published: 06/05/2008
• Est. Priority Date: 12/01/2006
• Status: Abandoned Application

• Current Assignee: Google Technology Holdings LLC (Alphabet Inc.)
• Original Assignee: General Instrument Corporation (CommScope Holding Company, Inc.)
• Inventors: Oo, Zaw Naing L., Fu, Xiaozhou, Qiu, Xin
• Application Number:
  US11/947,902
• Publication Number:
  US 20080133543A1
• Time in Patent Office: Days
• US Class Current: 707/10
• 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

Abstract

A system, method and computer-readable medium of instructions for performing dynamic and on-demand data transfer between databases (116, 124) in public and secure networks (102, 104), and synchronization of those databases (116, 124), in a public key infrastructure (PKI) environment. The system, method and computer-readable medium of instructions operate to identify at least one record of information in the database (116) of the public network (102) to be updated in the database (124) of the private network (104), enter update information in at least one data transfer table (400, 600/602) based on the at least one record of information, and use the at least one data transfer table (400, 600/602) to update at least one record in the database (124) of the private network (104) in accordance with the update information without overwriting other information in the database (124).

Claims

1. A method for updating at least one record in a target database based on information in at least one record in a source database, with one of the target and source databases being in a public network and the other of the source and target databases being in a secure network that is air gap secured from the public network, the method comprising:

identifying said at least one record of information in the source database to be updated in the target database;

entering update information in at least one data transfer table based on said at least one record of information; and

using said at least one data transfer table to update said at least one record in the target database in accordance with said update information without overwriting other information in the target database.

2. A method as claimed in claim 1, wherein:

said entering step enters said update information in a plurality of data transfer tables.

3. A method as claimed in claim 2, wherein:

said plurality of data transfer tables includes a header table into which update information that identifies said at least one record of information is entered, and a details table into which update information corresponding to the information in said at least one record is entered.

4. A method as claimed in claim 1, wherein:

said information in the source database includes at least one of binary data and variable-length data field data.

5. A method as claimed in claim 1, wherein:

said at least one record of information in the source database is arranged in a row format in the database; and

said update information is entered in said at least one data transfer table in column format.

6. A method as claimed in claim 1, wherein said using step comprises:

loading a file representing said at least one table onto a device coupled to receive information from the source database;

uncoupling said device from the source database; and

coupling said device to the target database for use in updating said at least one record in the target database based on the file loaded onto the device.

7. A method as claimed in claim 1, wherein:

said identifying step comprises identifying a plurality of said records of information in the source database to be updated in the target database;

said entering step comprises entering update information in at least one data transfer table based on said plurality of records of information; and

said using step comprises using said at least one data transfer table to update a plurality of said records in the target database in accordance with said update information without overwriting other information in the target database.

8. A method as claimed in claim 1, wherein:

said update information includes information pertaining to one of insertion of a new record in the target database, updating of an existing record in the target database and deletion of an existing record from the target database.

9. A computer-readable medium of instructions for updating at least one record in a target database based on information in at least one record in a source database, with one of the target and source databases being in a public network and the other of the source and target databases being in a secure network that is air gap secured from the public network, the computer-readable medium of instructions comprising:

a first set of instructions for enabling a computer to identify said at least one record of information in the source database to be updated in the target database; and

a second set of instructions for enabling a computer to enter update information in at least one data transfer table based on said at least one record of information, said update information being configured for use in updating said at least one record in the target database in accordance with said update information without overwriting other information in the target database.

10. A computer-readable medium of instructions as claimed in claim 9, wherein:

said second set of instructions enables the computer to enter said update information in a plurality of data transfer tables.

11. A computer-readable medium of instructions as claimed in claim 10, wherein:

said plurality of data transfer tables includes a header table into which update information that identifies said at least one record of information is entered, and a details table into which update information corresponding to the information in said at least one record is entered.

12. A computer-readable medium of instructions as claimed in claim 9, wherein:

said information in the source database includes at least one of binary data and variable-length data field data.

13. A computer-readable medium of instructions as claimed in claim 9, wherein:

said at least one record of information in the source database is arranged in a row format in the source database; and

said update information is entered in said at least one data transfer table in column format.

14. A computer-readable medium of instructions as claimed in claim 9, wherein:

said first set of instructions enables the computer to identify a plurality of said records of information in the source database to be updated in the target database; and

said second set of instructions enables the computer to enter update information in at least one data transfer table based on said plurality of records of information, such that said at least one data transfer table is configured for use in updating a plurality of said records in the target database in accordance with said update information without overwriting other information in the target database.

15. A computer-readable medium of instructions as claimed in claim 9, wherein:

said update information includes information pertaining to one of insertion of a new record in the target database, updating of an existing record in the target database and deletion of an existing record from the target database.

16. A system comprising:

a public network comprising one of a source database and a target database;

a secure network comprising the other of the source database and the target database and air gap secured from the public network;

a computer, operable to identify at least one record of information in the source database to be updated in at least one record in the target database, and enter update information in at least one data transfer table based on said at least one record of information, such that said at least one data transfer table is configured for use in updating said at least one record in the target database in accordance with said update information without overwriting other information in the target database.

17. A system as claimed in claim 16, wherein:

said computer is operable to enter said update information in a plurality of data transfer tables.

18. A system as claimed in claim 17, wherein:

said plurality of data transfer tables includes a header table into which update information that identifies said at least one record of information is entered, and a details table into which update information corresponding to the information in said at least one record is entered.

19. A system as claimed in claim 16, wherein:

said information in the source database includes at least one of binary data and variable-length data field data; and

said at least one record of information in the source database is arranged in a row format in the source database, said update information is entered in said at least one data transfer table in column format.

20. A system as claimed in claim 16, further comprising:

a device, configured to couple to the computer associated with the source database to enable the computer to load a file representing said at least one table onto the device, and further configured to couple to a computer associated with the target database, when removed from the computer associated with the source database, to enable the computer associated with the target database to update said at least one record in the target database based on the file loaded onto the device.