Cryptograph index supported database transparent encryption method

A transparent encryption and database technology, applied in the field of information security, can solve the problems of easy cracking, difficulty, weak strength, etc., and achieve the effect of efficient ciphertext index, efficient data structure and algorithm, and efficient conditional query

Inactive Publication Date: 2009-08-12
BEIJING INSTITUTE OF TECHNOLOGYGY
View PDF1 Cites 29 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this encryption method is weak and easy to be cracked, and because the index file is not a part of the database, the database management system cannot implement transaction management on it, and it is difficult to ensure the consistency between the database and the index file
[0004] Patent 2005101

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
  • Cryptograph index supported database transparent encryption method
  • Cryptograph index supported database transparent encryption method
  • Cryptograph index supported database transparent encryption method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0038] Assume there is a table T with fields: {F 1 , F 2 ,...,F i ,...,F n}. Field F in table T is required i Perform transparent encryption. f i The data type of is R, and this field has index I and constraint C, which needs to implement ciphertext index.

[0039] Step 1. Transform the original table T. The specific steps are as follows:

[0040] (1) Rename table T to T 1 , which contains fields: {F 1 , F 2 ,...,F i ,...,F n , F n+1}. Among them, F n+1 used to store field F i The ciphertext information, the type is RAW;

[0041] (2) delete F i Constraint C on

[0042] (3) delete F i index I on

[0043] (4) Call the encryption algorithm, and T 1 F in i Perform encryption transformation and store the ciphertext in F n+1 in, and set F i The value is set to NULL; it is the ciphertext field F n+1 Build an index data structure and insert the existing ciphertext into the structure.

[0044] The data structure and algorithm of the index use a balanced binary...

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 belongs to the technical field of information safety, and relates to a database transparent encryption method supporting ciphertext indexes. The method is realized on the basis of a view mechanism and a trigger mechanism of a database system and transparently provides automatic encryption and decryption for users by using the view and the trigger. Under the condition of data inquiry, data is decrypted in the process of filling the view; and when novel data is inserted into a table or the data is corrected, the trigger is utilized for the encryption of the data and the maintenance of the ciphertext indexes. The method for realizing the ciphertext indexes comprises: establishing an auxiliary data structure for realizing the ciphertext indexes and an inquiry and maintenance algorithm on the basis of the database table and SQL language; and utilizing an index extension mechanism of a database system to realize the call and maintenance of the ciphertext indexes. The method is completely transparent as for the database-based application system, does not need to change the prior application system after the deployment of a database security enhancing system, and can guarantee high efficiency of ciphertext retrieval.

Description

technical field [0001] The invention belongs to the technical field of information security, and relates to a method for transparently encrypting fields in a database and realizing efficient conditional query. Background technique [0002] In information systems, databases are widely used. As a collection of information, the database system stores the most valuable information in the system. It is the core component of the computer information system. Encrypted for its security. At present, most of the existing domestic database systems are imported from abroad. Due to the restrictions of technology export laws, the security database systems that support ciphertext query are not exported to China. Therefore, for the existing database system, it is urgent to develop a database encryption technology that supports ciphertext query. [0003] After the database is encrypted, the original partial order relationship between the data will be lost, so the original index mechanism ...

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
IPC IPC(8): G06F17/30
Inventor 代六玲杜顶张晗立胡金武梁涛汤继良李奇陈合春
Owner BEIJING INSTITUTE OF TECHNOLOGYGY
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