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

SQL-based data extraction method and device

A data and database technology, applied in the computer field, can solve problems such as inflexible selection of data sources, and achieve the effect of realizing complex combination and simplifying the configuration process

Pending Publication Date: 2021-05-07
SUNINFO INFORMATION TECH
View PDF6 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] One purpose of this application is to provide a SQL-based data extraction method and equipment to solve the problem of insufficient flexibility in the selection of data sources in the process of data desensitization and extraction in the prior art

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
  • SQL-based data extraction method and device
  • SQL-based data extraction method and device
  • SQL-based data extraction method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] The application will be described in further detail below in conjunction with the accompanying drawings.

[0030] In a typical configuration of this application, the terminal, the device serving the network, and the trusted party all include one or more processors (such as a central processing unit (Central Processing Unit, CPU)), an input / output interface, a network interface, and a memory .

[0031] Memory may include non-permanent memory in computer-readable media, random access memory (Random Access Memory, RAM) and / or non-volatile memory, such as read-only memory (Read Only Memory, ROM) or flash memory (flash RAM). Memory is an example of computer readable media.

[0032] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples o...

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 aims to provide an SQL-based data extraction method and device, and the method comprises the steps of reading an SQL query statement to obtain source data in a source database, and storing the source data in a temporary table; desensitizing the data in the temporary table according to a data desensitization algorithm to obtain desensitized data; and storing the desensitized data in a target data table according to a table mapping relation. The data source is limited through the SQL statement, so that the extraction effect is achieved, the data source is flexibly limited, complex combination of multiple tables is achieved, and the configuration process is simplified.

Description

technical field [0001] The present application relates to the field of computers, in particular to a method and device for extracting data based on SQL. Background technique [0002] At present, while big data is widely used, the protection of personal information is facing unprecedented challenges. While enjoying the appropriate services brought by data analysis to their lives, people are also troubled by personal information leakage or even being harassed. Therefore, it is particularly important to desensitize the use of data. Ordinary extraction or desensitization operations operate on the entire table of the source database, which lacks flexibility in the selection of data sources. If you want to limit the fields to be extracted, the sorting of data, or want to To extract the content to a table, special configuration needs to be added, which is cumbersome to operate. Contents of the invention [0003] One purpose of the present application is to provide a SQL-based d...

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): G06F16/25G06F16/22G06F16/242
CPCG06F16/254G06F16/2282G06F16/2433
Inventor 马佩任养超徐岩
Owner SUNINFO INFORMATION TECH