Blood relationship analysis method of structured query language and tool thereof

A technology of structured query and analysis method, applied in the field of data traceability and prediction, can solve problems such as single database type, poor scalability, and distortion of analysis results, and achieve the effect of accurate analysis results, wide grammar rules, and extensive analysis

Active Publication Date: 2019-09-13
SUNING CLOUD COMPUTING CO LTD
View PDF8 Cites 26 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,

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
  • Blood relationship analysis method of structured query language and tool thereof
  • Blood relationship analysis method of structured query language and tool thereof
  • Blood relationship analysis method of structured query language and tool thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] Such as 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 o...

Embodiment 2

[0062] Such as 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 structure...

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 invention discloses a blood relationship analysis method of a structured query language, and a tool thereof. The blood relationship analysis method comprises the steps: extracting service systems of a plurality of different types of databases, and continuously importing the structured query language of the service systems into a message queue list in batches; preprocessing structured query languages containing static parameters and dynamic parameters in the message queue list respectively; performing grammatical proofreading on the preprocessed structured query language,generating abstract syntax trees matching the structured query languages of the different types of databases, traversing the abstract syntax trees, and obtaining the blood relationship of the structured query languages; and obtaining blood relationship veins and key blood relationship data of the blood relationship, finally forming a blood relationship map, and finally completing analysis and prediction of the service system. According to the embodiment of the invention, dynamic and static structured query languages of various types of databases can be analyzed continuously in batches, and data traceability and prediction of a service system are completed, and an analysis result is 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
IPC IPC(8): G06F16/21G06F16/215G06F16/28G06F16/51
CPCG06F16/21G06F16/215G06F16/284G06F16/51
Inventor 曾力袁洪军孙迁
Owner SUNING CLOUD COMPUTING CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap