A Kind of Genealogy Parsing Method and Tool of Structured Query Language

A technology of structured query and parsing method, applied in the field of data traceability and prediction, it can solve problems such as inability to perform batch processing, single database type, poor scalability, etc., and achieve effective data traceability and data prediction, accurate parsing results, and grammar rules. wide effect

Active Publication Date: 2022-02-25
SUNING CLOUD COMPUTING CO LTD
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, there are many deficiencies in traditional structured query language lineage analysis. For example, the syntax rules designed for lineage analysis in structured query language are only applicable to a certain type of database, and the supported database type is single. If other types of databases are introduced, design In addition to the applicable grammatical rules, the compatibility of various structured query language grammars must also be considered, and the research cost is high. Therefore, the existing structured query language analysis technology is relatively single and has poor scalability; moreover, the existing structured query language Language parsing technology only analyzes a single structured query language, cannot perform batch processing, and has poor continuity. The current structured query language analysis needs to manually input one or several structured query languages ​​as the data source for analysis, and parse through the parser , output the result, the parsing is over, there is no follow-up parsing power except manually adding structured query language, and it is impossible to perform continuous automatic parsing for a large number of structured query languages; further, the existing structured query language parsing technology only It is suitable for parsing static structured query language, and does not support the analysis of dynamic structured query language. If the structured query language contains dynamic parameters, the existing parsing technology will report a syntax error during the verification stage of the structured query language and the parsing will be terminated. Or replace dynamic parameters with characters that can be recognized by the parser in the stage of removing impurities in the structured query language, so that although the structured query language can be parsed normally, the analysis result will be distorted

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 Kind of Genealogy Parsing Method and Tool of Structured Query Language
  • A Kind of Genealogy Parsing Method and Tool of Structured Query Language
  • A Kind of Genealogy Parsing Method and Tool of Structured Query Language

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] like figure 1 As shown, the embodiment of the present invention provides a structured query language blood relationship analysis method, the blood relationship analysis method includes:

[0045] S1: Extract several business systems of different types of databases, and continuously import the structured query language of the business systems into the message queue table in batches;

[0046] Preferably, the different types of databases include Hive data warehouses and relational databases, and the relational databases include mainstream MySQL databases, Oracle databases, and DB2 databases. Compared with the current kinship analysis of language, the embodiment of the present invention can simultaneously analyze the SQL of multiple databases in batches, wherein, due to the parsing queues for multiple different SQLs in the embodiment of the present invention, it can be used for multiple Automatic batch parsing of SQL significantly improves the parsing speed and breadth of S...

Embodiment 2

[0062] like Figure 5 As shown, the embodiment of the present invention provides a structured query language blood relationship analysis tool, the blood relationship analysis tool includes:

[0063] The data source extraction system 101 is used to extract business systems of several different types of databases, and continuously import the structured query language of the business systems into the message queue table in batches;

[0064] The data preprocessing system 102 is configured to preprocess the structured query language containing static parameters and dynamic parameters in the message queue table, and perform standardized format operation if only static parameters are involved in the structured query language , if dynamic parameters are involved in the structured query language, pre-processing is performed;

[0065] A data syntax proofreading system 103, configured to perform grammar proofreading on the preprocessed structured query language, so that the structured q...

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 embodiment of the present application discloses a structured query language blood relationship analysis method and its tools. The blood relationship analysis method includes: extracting business systems of several different types of databases, and continuously importing the structured query language of the business systems into messages in batches In the queue table; the structured query language containing static parameters and dynamic parameters in the message queue table is preprocessed respectively, and the syntax of the preprocessed structured query language is checked to generate a structured query language matching the different types of databases The abstract syntax tree of the abstract syntax tree is traversed to obtain the blood relationship of the structured query language; the blood relationship context and key blood relationship data are obtained, and finally a blood relationship map is formed to finally complete the analysis and prediction of the business system. The embodiment of the present application can batch and continuously analyze dynamic and static structured query languages ​​of various types of databases, complete data traceability and prediction of business systems, and the analysis results are accurate.

Description

technical field [0001] The invention relates to the field of data traceability and prediction, in particular to a blood relationship analysis method of a structured query language and a tool thereof. Background technique [0002] At present, various industries have paid more attention to big data, and the research on big data has been further deepened. The analysis of blood relationship in structured query language in data is also an important direction. [0003] However, there are many deficiencies in traditional structured query language lineage analysis. For example, the syntax rules designed for lineage analysis in structured query language are only applicable to a certain type of database, and the supported database type is single. If other types of databases are introduced, design In addition to the applicable grammatical rules, the compatibility of various structured query language grammars must also be considered, and the research cost is high. Therefore, the existin...

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 & AuthorityPatents(China)
IPC IPC(8): G06F16/21G06F16/215G06F16/28G06F16/51
CPCG06F16/21G06F16/215G06F16/284G06F16/51
Inventor曾力袁洪军孙迁
OwnerSUNING CLOUD COMPUTING CO LTD