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.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]This application is a divisional of U.S. patent application Ser. No. 16 / 464,255 filed on May 24, 2019, which claims priority to and the benefit of Korean Patent Application No. 10-2016-0158427 filed in the Korean Intellectual Property Office on Nov. 25, 2016, the entire contents of which are incorporated herein by reference.TECHNICAL FIELD[0002]The present invention relates to database management, and more particularly, to an improved method of replicating and storing data in a database.BACKGROUND ART[0003]A database means a set of data integrated and managed so as to be shared and used by multiple persons. The database may be used in banks, online shopping malls, in-house management systems, and the like.[0004]Current database systems allow storing and retrieving a large amount of information. Some of the information may include, for example, sensitive information such as a credit card number, etc. In particular, the security of a databa...

AI Technical Summary

Benefits of technology

The present patent provides a computer program and computer system for replicating a database with security data. The computer program includes a first management module that extracts data from a first database, including encrypted column data and non-encrypted column data. The first management module identifies if the extracted data is the encrypted column data and decides to change the data to null. The computer system then sends a request to the second database for the encrypted column data. The second database receives the request and generates the changed data by performing a processing on the data and requesting it from the first database. The computer system also includes a second management module that encrypts the data and sends it to the second database for recording. The technical effect of this patent is to provide a method for securely replicating a database with change data capture between two databases.

Problems solved by technology

In a solution for preventing the loss of the data by replicating the database, when the data is backed up to another database, there is a risk that the sensitive information will be lost.

Images