| 摘要 |
Disclosed are an apparatus and method for encrypting a data column. A schema inquiry unit inquires a schema of an original table which is a data table to perform encryption in a database in which a plurality of data tables are stored. A backup performing unit generates schema information of a backup table based on the schema of the original table; generates the backup table by using schema information of the backup table; copies data of the original table onto the backup table; changes the original table by adding a backup column to the original table; inactivates the restrictive conditions included in the changed original table; and copies the original columns included in the changed original table onto the backup column. An encrypting unit encrypts data of an encrypting target column, which is the column to be encrypted in the changed original table, and enters encrypted data in each field of the original columns of the changed original table. Then, when the encryption of data of the encrypting target column is completed, the backup performing unit eliminates the backup column from the changed original table and activates the restrictive conditions. According to the present invention, encryption is performed on the data column after generating the backup table for the original table, and the index column of the original table is not removed, thereby improving stability of the encryption process. |
