Data blood relationship analysis method and device and server

An analysis method and blood relationship technology, applied in the field of data processing, can solve problems such as limited scope of application, lack of flexibility, inability to process SQL statements, etc., to achieve the effect of wide application scope and flexible methods

Pending Publication Date: 2021-02-09
BEIJING KINGSOFT CLOUD NETWORK TECH CO LTD
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In related technologies, when analyzing blood relationship of data, if you want to analyze which physical table a certain column of data comes from in a SQL (StructuredQuery Language) statement, you can use string matching for analysis, for example , you can match the column names and table names contained in the SQL statement with each physical table; however, the SQL statements of different versions of the database may be different, and the diversity of SQL statements makes this string matching method unable to

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
  • Data blood relationship analysis method and device and server
  • Data blood relationship analysis method and device and server
  • Data blood relationship analysis method and device and server

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0033]In order to make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be described clearly and completely with reference to the accompanying drawings. Obviously, the described embodiments are part of the embodiments of the present invention, not all of them.的实施例。 Example. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative work shall fall within the protection scope of the present invention.

[0034]The blood relationship of data refers to a relationship formed between data in the process of data generation, processing and integration, circulation, and its ultimate extinction; drawing on a similar relationship in human society to express this relationship between data, It can be called the blood relationship of the data; the blood relationship of the data is one of the components of the metadata, which...

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 provides a data blood relationship analysis method and device and a server. The method comprises the steps: extracting a query statement, related to a query operation, in a target SQL statement based on an established abstract syntax tree of the target SQL statement, according to a target column name contained in the query statement, obtaining a target data table associated with thetarget column name and the associated target data column, and further determining a data blood relationship analysis result of the target SQL statement. According to the method, based on the abstractsyntax tree corresponding to the SQL statement, column names related to the SQL statement are analyzed, a data table and data columns related to the column names are obtained, and then a data blood relationship analysis result of the SQL statement is obtained; even if the SQL statement is relatively complex, a relatively accurate data blood relationship analysis result can be obtained through themethod; meanwhile, the method is relatively flexible, is suitable for various SQL statement source codes, can meet relatively complex data blood relationship analysis requirements, and is wide in application range.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a method, device and server for analyzing blood relationship of data. Background technique [0002] Data blood relationship refers to a relationship formed between data during the process of data generation, processing and fusion, circulation, and final extinction. Data lineage analysis can be used to analyze the impact of changes in upstream data on downstream data, and to track the source of upstream problems when downstream data changes. [0003] In related technologies, when analyzing blood relationship of data, if you want to analyze which physical table a certain column of data comes from in a SQL (StructuredQuery Language) statement, you can use string matching for analysis, for example , you can match the column names and table names contained in the SQL statement with each physical table; however, the SQL statements of different versions of the database ...

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/242G06F16/2458
CPCG06F16/2433G06F16/2458
Inventor 果然孙茂林
Owner BEIJING KINGSOFT CLOUD NETWORK TECH 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