Transparent online database anonymized data parallel migration method

An anonymization and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc.

Active Publication Date: 2018-11-27
湖南格凡安信科技有限公司
View PDF11 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The technical problem to be solved by the present invention is to provide a transparent online database anonymized data parallel migration method to solve the need to shut down the business information system during the data migration process and achieve the data migration of the business information system. Online transparency with services

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
  • Transparent online database anonymized data parallel migration method
  • Transparent online database anonymized data parallel migration method
  • Transparent online database anonymized data parallel migration method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0021] This embodiment includes the following steps:

[0022] (1) Install and build an oracle database, create a business data table, and fill in about 100,000 business data. The data structure is as follows (the data fields that need to be anonymized are: C_XM, C_LXFS, C_ADDR, C_SFZID);

[0023] Table name: T_LIS_HZSFXX

[0024] column name

Chinese name

type of data

length

N_ID

serial number

integer

8

C_XM

Name

character

40

C_LXFS

Contact information

character

20

C_ADDR

address

character

100

C_SFZID

identity number

character

18

[0025] (2) Change the table structure into the following table through the PL / SQL operation of the oracle database, and change the table name to T_LIS_HZSFXX_GAFF at the same time;

[0026]

[0027] Specifically execute the sql statement:

[0028] ALTER TABLE T_LIS_HZSFXX ADD C_XM_GAFF VARCHAR2(100);

[0029] AL...

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 provides a transparent online database anonymized data parallel migration method comprising the following step: (1) adding a flag bit field and a corresponding anonymized field to a table which is determined and needed to be anonymized; 2) renaming the table to be anonymized, creating a view with the same name as the table to be anonymized and making the name and the number of each field the same as the table to be anonymized; (3) creating insert / add, update / modify and delete / delete triggers for views with the same name; (4) cyclically obtaining the unmigrated data in small batches according to the unmigrated flag bits and anonymously updating the data needed to be anonymized into the table until all updates are completed; and (5) the business operation data of the application system of the corresponding table are added, deleted, modified and queried in real time according to the rows of the view. The method can solve the problem that the business information system needsto be shut down in the data migration process so as to realize the online type transparency of the data migration and service of the business information system.

Description

technical field [0001] The invention relates to a method for parallel migration of anonymized data in a transparent online database, belonging to the field of data security protection. Background technique [0002] With the gradual and in-depth application of informatization construction, various businesses have higher and higher requirements for real-time online business systems. At present, the anonymization protection of existing information data needs to stop the business and perform separate data migration to achieve data synchronization. consistency. Contents of the invention [0003] The technical problem to be solved by the present invention is to provide a transparent online database anonymized data parallel migration method to solve the need to shut down the business information system during the data migration process and achieve the data migration of the business information system. Online transparency with services. [0004] The technical solution adopted by...

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 湖南格凡安信科技有限公司
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap