Unlock instant, AI-driven research and patent intelligence for your innovation.

A Parallel Migration Method of Anonymized Data in Transparent Online Database

An anonymization and database technology, applied in structured data retrieval, database design/maintenance, etc.

Active Publication Date: 2019-12-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
  • A Parallel Migration Method of Anonymized Data in Transparent Online Database
  • A Parallel Migration Method of Anonymized Data in Transparent Online Database
  • A Parallel Migration Method of Anonymized Data in Transparent Online Database

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 details character 20 C_ADDR address character 100 C_SFZID ID 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] ALTER TABLE T_LIS_HZSFXX ADD C_LXFS_GAFF VARCHAR2(100);

[0030] ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21
Inventor 曾永丰张湖吴勇王石娇尹鹏
Owner 湖南格凡安信科技有限公司