Method and system for partial matching query of encrypted field in database

A technology for encrypting fields and databases, applied in the field of database query, can solve problems such as long query time, only allowing complete matching queries, and technicians abandoning the encryption scheme, achieving good encryption, improving security, ease of use, and high efficiency Effect

Active Publication Date: 2015-12-09
FUJIAN TQ DIGITAL
View PDF6 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, the database encrypts the fields to ensure the security of the database. However, when partially matching the query, each piece of data needs to be decrypted and then matched and searched. When the amount of data is large, the query time will be too long, causing the technicians to give up. Encryption scheme, or only allow exact match queries

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
  • Method and system for partial matching query of encrypted field in database
  • Method and system for partial matching query of encrypted field in database
  • Method and system for partial matching query of encrypted field in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to describe the technical content, achieved goals and effects of the present invention in detail, the following descriptions will be made in conjunction with the embodiments and accompanying drawings.

[0027] The present invention provides a method for partial matching query of database encrypted fields, including:

[0028] Create a data record table;

[0029] Create an encrypted index table for the encrypted field according to the data record table;

[0030] The program obtains the field to be queried and encrypts it;

[0031] In the data record table, query out the completely matching data through the SQL statement, and record the completely matching data as the first value;

[0032] Perform SHA hashing on the field to be queried, and query the corresponding data unique sign in the encrypted index table through the SQL statement;

[0033] According to the unique mark of the corresponding data, query all the data of the unique mark of the data in the data ...

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 method and a system for partial matching query of an encrypted field in a database. The method comprises the following steps: creating a data record table; creating an encrypted index table for the encrypted field according to the data record table; obtaining and encrypting a to-be-queried field by program; querying completely matched data from the data record table through a structured query language (SQL) sentence, and recording the completely matched data as first values; carrying out secure hash algorithm (SHA) hashing on the to-be-queried field, and querying a corresponding unique data identifier from the encrypted index table through the SQL sentence; and querying all data with the unique data identifier in the data record table according to the corresponding unique data identifier, and recording the data as second values; and merging the first values with the second values. In the manner, an encryption scheme can be used only by partial matching query of the field under the condition of ensuring the performance, so that the safety and the usability of the system are improved.

Description

technical field [0001] The invention relates to the technical field of database query, in particular to a method and system for partial matching query of encrypted fields of a database. Background technique [0002] At present, the database encrypts the fields to ensure the security of the database. However, when partially matching the query, each piece of data needs to be decrypted and then matched and searched. When the amount of data is large, the query time will be too long, causing the technicians to give up. Encryption scheme, or only allow exact match queries. [0003] The existing patent (application number: 201410150462.1) discloses a data encryption and retrieval method for databases, including the following steps: a) Encrypt the original data using a one-way encryption algorithm, and keep the order of the original data unchanged. , to generate a non-decryptable indexable header; b) then continue to encrypt the original data to generate decipherable ciphertext dat...

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 Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/24553
Inventor 陈丛亮刘德建毛新生
Owner FUJIAN TQ DIGITAL
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products