Database information encryption method and system

An information encryption and database technology, applied in the field of information security, can solve the problems of high deployment cost, difficulty in preventing database administrators from abusing permissions, and high risk of loss of storage media.

Inactive Publication Date: 2009-08-12
INST OF SOFTWARE - CHINESE ACAD OF SCI
View PDF0 Cites 56 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since the encryption mechanism provided by the database management system often uses special SQL statements, changes to the upper-layer application are inevitable, and the deployment cost is extremely high
[0011] (2) The key is managed by the database administrator, and it is difficult to prevent the database administrator from a...

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
  • Database information encryption method and system
  • Database information encryption method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0101] The present invention will be described in further detail below in conjunction with the accompanying drawings and specific embodiments, but the scope of the present invention is not limited in any way.

[0102] This embodiment adopts as figure 2 In the database system structure shown, there are three users in the database system, namely admin, tom and jerry, wherein admin is the database administrator of the database system, and tom and jerry are general users.

[0103] Assume that there is a data table emp created by admin that involves confidential information in the database. The data structure and data content of this data table are shown in Table 2 and Table 3 below, respectively. Among them, the Salary field belongs to confidential information and needs to be stored encrypted.

[0104] Table 2: Data structure of the data table emp

[0105] field name Types of illustrate ID Integer employee identification name Char name of worker ...

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 database information encryption method and a database information encryption system using the same, which belong to the technical field of information security. The method comprises the following steps of: encrypting a sensitive field in a datasheet through a cryptoequipment unit, and creating a homonymous view which points to the encrypted datasheet for the sensitive field; maintaining the use permission of a user to a key, and encrypting the used cryptoequipment unit, an encryption mode and the key; allowing a user with the permission to successfully read and modify encryption information; and for a user without the permission, using a random key for error decryption when the encryption information is read, and returning key acquisition failure information when the encryption information is modified. The system comprises a security management host and one or more database server hosts, and is provided with an abstract cryptoequipment module for providing a uniform encryption and decryption interface and calling one or more different cryptoequipment units to realize the encryption and decryption. The database information encryption method and the database information encryption system can be used for the encryption of database information.

Description

technical field [0001] The invention relates to database information security, in particular to a database information encryption method and a database information encryption system using the method. It belongs to the field of information security technology. Background technique [0002] With the continuous advancement of informatization, information assets have become one of the core assets of enterprises. How to use technical means to maintain the security of enterprise business data has become a common concern of enterprises. As the core component of data storage and management, the security of database system has attracted extensive attention. [0003] In an enterprise configured with an information system, database administrators are usually hired to maintain and manage the database system, and these super users have control over all data in the database. However, in modern enterprise business processes, the database administrator is only a technician, not the owner ...

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): G06F21/00G06F21/62
Inventor 陈驰张敏咸鹤群安然
Owner INST OF SOFTWARE - CHINESE ACAD OF SCI
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