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

A method for automatic identification of database sensitive data

A sensitive data and automatic identification technology, applied in the field of database processing, can solve the problems of difficult manual sorting of sensitive data and inaccurate content positioning, and achieve the effect of improving business support capabilities, improving sorting accuracy, and improving work efficiency

Active Publication Date: 2018-11-09
上海新炬网络技术有限公司
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem to be solved by the present invention is to provide an automatic identification method for sensitive data in databases, which can solve the problems of manual combing of sensitive data and inaccurate content positioning, reduce the time-consuming and labor costs of manual combing, improve the accuracy of combing, and improve maintenance work efficiency

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 method for automatic identification of database sensitive data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0015] figure 1 It is a schematic diagram of the automatic identification process of database sensitive data in the present invention.

[0016] See figure 1 , the database sensitive data automatic identification method provided by the present invention, comprises the following steps:

[0017] Step S1: Configure the data source, and set the identification matching algorithm for the sensitive fields of the database tables in the data source; for example, save the database host IP, port, database instance name, database account number, and database password information through the database instance configuration interface as the data source ;The sensitive fields include name, unit mailing address, unit name, certificate validity time, ID card number, contact person, certificate address, contact information, actual residential address, and actual resident...

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 sensitive data automatically-recognizing method. The method comprises the steps of a, configuring a data source, and setting a recognition and matching algorithm for sensitive fields of storage tables in the data source; b, acquiring the configured data source and the recognition and matching algorithm, starting multiple threads backstage, and establishing long connection with a specific database with the JDBC method, wherein one thread processes all the tables or one table of one user; c, randomly drawing specific data from each storage table through sampling, and testing drawn data according to the set recognition and matching algorithm; d, marking the data passing the test as sensitive data, and conducting automatic saving and recording. According to the method, sensitive data in the database are automatically recognized, the problems that manual sensitive data combing is difficult, and content positioning is not accurate can be solved, time for manual combing is shortened, labor cost is saved, combing accuracy is improved, and maintaining efficiency is improved.

Description

technical field [0001] The invention relates to a database processing method, in particular to a database sensitive data automatic identification method. Background technique [0002] With the increasing application of mobile business support system data, the security of personal information has been paid more and more attention by the company. How to avoid a large amount of sensitive information involved in daily production and operation has become the primary consideration of information security, and the production database that carries the core business system is the top priority. In the daily informatization construction, it is inevitable to migrate a large amount of business test data from the production database to the test database. How to meet the requirements of informatization construction and protect sensitive information to the greatest extent is an important challenge at present. [0003] At this stage, there are many specifications based on the security manag...

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/30
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com