Field blood relationship analysis method, system and device based on depth-first traversal

Abstract

The invention discloses a field blood relationship analysis method, system and device based on depth-first traversal. The method comprises the steps that conversion processing is performed on a to-be-analyzed SQL statement to generate an abstract syntax tree; depth-first traversal is performed on the generated abstract syntax tree; and verification analysis is performed on the depth-first traversal result to obtain a blood relationship among fields in the SQL statement. The system comprises a conversion processing module, a depth-first traversal module and a verification analysis module. The device comprises a memory and a processor. According to the field blood relationship analysis method, system and device, the blood relationship among the fields is analyzed through the depth-first traversal method, analysis complexity is lowered, and analysis precision is improved; and besides, through the method, the SQL statement is directly processed without depending on an existing metadata system, so that the complexity of association analysis is further lowered, and compatibility is improved. The field blood relationship analysis method, system and device can be widely applied to the association analysis field.

Description

technical field [0001] The invention relates to the field of association analysis, in particular to a method, system and device for field blood relationship analysis based on depth-first traversal. Background technique [0002] With the rapid development of the innovation and integration process of the land tax business system, the types of products have expanded rapidly, and the relationship between products has become more and more complex. At the same time, due to the rapidly changing business requirements in the Internet era, the workload and complexity of system development, testing, and operation and maintenance have increased significantly. At present, the main reasons for the high complexity of the land tax information system include: First, the scale of the system expands with the expansion of the product, forming a huge program and software resources, and even dividing the system into more subsystems and handing them over to multiple organizations for development ...

AI Technical Summary

Problems solved by technology

The former is simple and easy to implement and has high execution efficiency, but its analysis accuracy is low and has limited guidance for research and development; the latter is based on the program source code (or intermediate code), and through the semantic analysis of program instructions, it can identify the data fields of related software entities. The mapping and transfer relationship between software entities, the analysis accuracy is high, and the analysis results can be used to create program impact analysis views and business logic views, which is convenient for design, testing, and operation and maintenance personnel to evaluate the impact details between software entities and determine the scope of program modification. Broad application prospects and higher application value, but the implementation technology is relatively complicated

[0004] In addition, the existing field-level blood relationship analysis needs to cooperate with a specific set of metadata systems, which has poor compatibility and high dependence on specific systems or platforms. Therefore, the existing field-level blood relationship analysis methods cannot be widely used in association Analysis field

Images