Method for duplexing database

Abstract

The present invention contemplates a non-transitory computer readable medium including a computer program steps for a change data capture (CDC) between a first database and a second database when executed by one or more processors of the computer system. The disclosed non-transitory computer readable medium contemplates receiving data from a first database by a second transceiver module, the data including a null data contained in an encrypted column and a data contained in a non-encrypted column of a table, generating, by the second management module, a change data, by reproducing transactions performed in the first database with respect to the data transmitted from the first database and performing a processing on a transaction before commit, and determining, by the second management module, to request an encrypted column data corresponding to the null data to the first database.

What is claimed is: 
     
         1 . A non-transitory computer readable medium including a computer program, the computer program causing a computer to perform steps for a change data capture between a first database and a second database when executed by one or more processors, the steps including:
 receiving data from a first database by a second transceiver module, the data including a null data contained in an encrypted column and a data contained in a non-encrypted column of a table;   generating, by the second management module, a change data, by reproducing transactions performed in the first database with respect to the data transmitted from the first database and performing a processing on a transaction before commit; and   determining, by the second management module, to request an encrypted column data corresponding to the null data to the first database.   
     
     
         2 . The non-transitory computer readable medium according to  claim 1 ,
 wherein the generating a change data includes:   generating the change data by reproducing the transaction performed in the first database by modifying the encrypted column into the null data.   
     
     
         3 . The non-transitory computer readable medium according to  claim 1 ,
 wherein the steps further include:   recording the change data in a table of a second database by the second management module, wherein the change data includes a value of data included in a non-encrypted column and the null data.   
     
     
         4 . The non-transitory computer readable medium according to  claim 1 ,
 wherein the steps further include:   receiving, by the second transceiver module, a re-encrypted encrypted column data re-encrypted with a first security module key of the first database transmitted from the first database;   generating, by the second security module, the decrypted encrypted column data by decrypting the re-encrypted encrypted column data with a second security module key; and   updating, by the second security module, the decrypted encrypted column data in a table of a second database.   
     
     
         5 . The non-transitory computer readable medium according to  claim 4 ,
 wherein the updating, by the second security module, the decrypted encrypted column data in a table of a second database includes:   recording the decrypted encrypted column data into a second storage medium of the second database by modifying the data in the encrypted column of the table of the second database, in which the null data is recorded into the decrypted encrypted column data.   
     
     
         6 . A database for change data capture between a first database and a second database, the database including:
 a second transceiver module receiving data from a first database, the data including a null data contained in an encrypted column and a data contained in a non-encrypted column of a table;   a second storage medium module in which data of an encrypted column of a table is encrypted and recorded;   a second management module decrypting and reading the data of an encrypted column, determining to encrypt and to record the data of an encrypted column, generating a change data, by reproducing transactions performed in the first database with respect to the data transmitted from the first database and performing a processing on a transaction before commit, and determining to request an encrypted column data corresponding to the null data to the first database; and   a second security module for decrypting the re-encrypted encrypted column data.   
     
     
         7 . A method for change data capture between a first database and a second database, the method comprising:
 receiving data from a first database by a second transceiver module, the data including a null data contained in an encrypted column and a data contained in a non-encrypted column of a table;   generating by the second management module a change data, by reproducing transactions performed in the first database with respect to the data transmitted from the first database and performing a processing on a transaction before commit; and   determining by the second management module, to request an encrypted column data corresponding to the null data to the first database;   wherein the method is performed by one or more computing devices.