ZERO-DOWNTIME COLUMN-LEVEL ENCRYPTING METHOD FOR DATABASE

摘要

A seamless implementation method in a column unit cryptographic task of database for removing the loss of a user due to the business stoppage is provided to supply a service without interruption of database service during a database encryption construction working time. A copied table and an SQL Log table for ciphering an original copy table are generated during a service(S100). After the copy and encryption of the original copy tabular data are finished in the copy table, the changed contents recorded in the SQL Log table are encrypted. The change is included in the copy table(S200). After the content of the SQL Log is reflected, the switching of the original copy table and copy table is performed(S300).