Data encryption and retrieval method for database

Abstract

The invention discloses a data encryption and retrieval method for a database. The method includes the steps: a) encrypting raw data by means of a one-way encryption algorithm to generate a non-decipherable indexable head under the condition of keeping sequence of the raw data unchanged; b) continuing to encrypt the raw data to generate decipherable ciphertext data; c) combining the indexable head and the decipherable ciphertext data to generate encryption combined data, and storing the encryption combined data in the database, wherein the one-way encryption algorithm in the step a) refers to MD5 (message-digest algorithm 5), SHA (secure hash algorithm) or HMAC (hash message authentication code); the encryption algorithm in the step b) refers to the symmetric key encryption algorithm. The data encryption and retrieval method for the database has the advantages that since the indexable head and the decipherable ciphertext data are combined for encrypted storage of all of the raw data by means of cipertext, and the indexable head are used for quick retrieval of the encrypted data, full table scanning is avoided while accuracy in data decryption and security in data retrieval are guaranteed.

Description

technical field [0001] The invention relates to a data encryption and retrieval method, in particular to a data encryption and retrieval method for a database. Background technique [0002] With the rapid development of computer technology, the application of database has been very extensive and has penetrated into various fields. Especially after entering the era of cloud and big data, more and more important data are stored in the database. However, it would be disastrous if some policies and regulations, top-secret documents of government agencies, some trade secrets of commercial organizations, personal information and financial property information of financial institutions and other sensitive data are stored in plain text. As long as you have a little bit of database expertise, you can easily obtain information related to national security and the rise and fall of enterprises. Therefore, how to effectively ensure the security of the database system and realize the co...

AI Technical Summary

Problems solved by technology

[0005] 1), the data is completely deformed

This kind of deformed data completely loses the meaning of the text before encryption, and the data stored in the database becomes messy and cannot be effectively sequenced and indexed.

[0006] 2), unable to perform indexing operations

At this time, the index table generated becomes disorganized and cannot be effectively indexed, which leads to the query of the encrypted table, which can only perform full table scan (TABLEFULLSCAN)

[0007] 3) Query performance drops significantly

The data effect produced in this way is a full table scan of a bunch of messy data. It will be a long process to find out the desired result, and basically has no practical operational significance.

[0008] 4) There are loopholes in data encryption

This encryption technology will generate an encrypted query condition statement when querying. This kind of statement is easy to be illegally captured and anti-decrypted. The data can actually be decrypted, so there are certain loopholes in security.

Images