Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A data encryption and retrieval method for database

A data retrieval and database technology, applied in the field of database data encryption and retrieval, can solve problems such as illegal capture of statements, meaningless operations, anti-decryption, etc., to achieve the effect of ensuring correctness and avoiding full table scanning

Active Publication Date: 2017-05-17
上海新炬网络技术有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A data encryption and retrieval method for database
  • A data encryption and retrieval method for database
  • A data encryption and retrieval method for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] The present invention will be further described below with reference to the drawings and embodiments.

[0025] figure 1 It is a schematic diagram of the data encryption process used in the database of the present invention.

[0026] See figure 1 , The data encryption method for database provided by the present invention includes the following steps:

[0027] Step 101: First use a one-way encryption algorithm to encrypt the original data, and generate a non-decrypted indexable header while keeping the original data sequence unchanged; the one-way encryption algorithm can be MD5, SHA or HMAC, etc. In the existing algorithm, the one-way encryption algorithm can not only keep the original data sequence unchanged to generate an indexable header, but also ensure that the index header is irreversible and undecryptable.

[0028] Step 102: Then continue to encrypt the original data to generate decryptable ciphertext data; such as AES, ARIA, SEED, TDES or DES and other symmetric key encr...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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 used in 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 is stored in the database. However, if government agencies’ policies and regulations, top-secret documents, business secrets of commercial agencies, personal information and financial property information of financial institutions, and other sensitive data are stored in plaintext, it would be catastrophic. As long as you have a little bit of database expertise, you can easily get the 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 confidentialit...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30G06F21/60
CPCG06F16/2272G06F21/6218
Inventor 程永新符强曾天水
Owner 上海新炬网络技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products