Field-level data consanguinity extraction method and device, equipment and storage medium

Abstract

The invention relates to the technical field of artificial intelligence, and discloses a field-level data blood relationship extraction method and device, equipment and a storage medium. The method comprises the following steps: preprocessing an initial SQL statement to obtain a target SQL statement, and analyzing the target SQL statement into an abstract syntax tree; based on an analysis rule and an analysis strategy of the abstract syntax tree, traversing nodes of multiple levels of the abstract syntax tree to obtain output fields in the target SQL statement; recursive backtracking is conducted on the abstract syntax tree, physical table fields corresponding to all the output fields are obtained, and the corresponding relation between the output fields and the physical table fields is determined; and according to the corresponding relationship between the output field and the physical table field, generating field blood relationship information between the output field and the physical table field. According to the scheme, the blood relationship data analysis and extraction of the output field are performed on the input SQL statement, so that the technical problems that multiple database systems cannot be covered and the blood relationship information among the data can not be accurately determined in the prior art are solved.

Description

technical field [0001] The invention relates to the technical field of artificial intelligence, and in particular, to a field-level data lineage extraction method, device, equipment and storage medium. Background technique [0002] Data security management and control is one of the important ways to protect data security. The principle of least authorization is adopted to reduce the risk of data leakage through precise control of field-level data access rights. One of the most important links in data security management and control is to trace the source of each field of the user query result to obtain the security management and control information of the actual table corresponding to these fields, for example, whether to have permission to access, whether to encrypt / desensitize, etc., so as to take corresponding measures. interventions. [0003] Because data security management and control needs to cover all database systems of the enterprise, including relational databas...

AI Technical Summary

Problems solved by technology

[0004] The main purpose of the present invention is to solve the technical problem that in the prior art, various database systems cannot be covered and the blood relationship information between the data can be accurately determined by analyzing and extracting the blood relationship data of the output field of the input SQL statement

Images