Method and system for maintaining the safe of data base

Abstract

The invention discloses a method for maintaining database safety, including the following steps: a user creates a relation; whether the data in database needs encryption storage is determined through SQL extension statement; if the data needs encryption storage, a cipher key generator automatically generates a cipher key; if the data does not need encryption storage, the data is written out to an external memory; the cipher key generated by the cipher key generator is stored in the encryption relation table of a security dictionary; when data is written out to an external memory by DBMS, the security dictionary in a system table is queried so as to judge whether encryption is needed; if encryption is needed, data encryption is completed by the cipher key in the security dictionary; otherwise, the data is output to the external memory. The invention completes encryption operation when DBMS writes out the data in a memory to the external memory and completes deciphering operation when the data in the external memory is read in the memory; moreover, because the data is in plaintext in the memory, the function of the DBMS is not influenced and an index can be created in a conventional mode.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method and system for maintaining database security. Background technique [0002] At present, the security issues of computer data storage, the anti-theft and anti-tampering of sensitive data have attracted more and more attention. As the core of the computer information system, the database system and the database file are the aggregation of information. top priority. Traditional physical security, operating system security mechanism and database access control mechanism provide a certain security guarantee for the database, but these cannot meet all the security requirements of the database, and cannot guarantee the security of important and sensitive data in some departments, which involves Encryption of data. [0003] The maintenance of database security is mainly realized by encrypting the data in the database. The existing encryption of data in the database is mainly carried ...

AI Technical Summary

Problems solved by technology

Encrypted data will be difficult to maintain the original logical relationship. When DBMS stores encrypted data in the database, index establishment will be a great challenge, which will have a great impact on the performance and functions of the database.

Images