Data tracing and influence relationship analysis method based on database script

A database and script analysis technology, applied in the database field, can solve the problems of different analysis methods, grammar generators, and failure to provide data impact analysis, etc.

Inactive Publication Date: 2012-10-24
深圳市远行科技股份有限公司
View PDF3 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Although the above two methods provide analysis of data scripts, they do not provide data impact analysis, and the analysis methods and syntax generators used are also different.

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 tracing and influence relationship analysis method based on database script
  • Data tracing and influence relationship analysis method based on database script
  • Data tracing and influence relationship analysis method based on database script

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the technical problems, technical solutions and beneficial effects to be solved by the present invention clearer and clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0027] The analysis method of data traceability and data impact relationship based on database script analysis provided by the present invention, the main technical solution involves the following parts: establish JavaCC lexical and grammar files according to SQL standards, and construct related Java classes based on the structure and type of database scripts , the database script parses and generates an SQL tree, searches the SQL tree and outputs the results. Among them, JavaCC is a syntax analysis generator developed in Java, which has the advantages ...

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 tracing and influence relationship analysis method based on database script analysis. The analysis method comprises the following steps that step 1, morphology and grammar files based on a JavaCC database script are built according to SQL (structured query language) standards; step 2, according to the built morphology and grammar files, a database script resolver is generated, and the relevant Java type is created; step 3, the database script resolver analyses the received database script, relevant data in the script is obtained for generating an SQL tree; and step 4, the original data and the influence relationship between the original data and the target data are found and obtained according to the generated SQL tree. Through the data tracing and influence relationship analysis method based on the database script analysis provided by the invention, the data script analysis can be realized, and in addition, the influence relationship of the data tracing and the data can be realized according to analysis information.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method for analyzing data traceability and data influence relationship based on database script analysis. Background technique [0002] At present, the IT system is large and centralized, and the business continues to develop. More and more data needs to be managed and maintained, and the data model is becoming more and more complex. At present, in the data management and operation and maintenance work, because the documents and the system cannot be synchronized in time, it is difficult for managers, operation and maintenance personnel, and even developers to clearly grasp the real application of the data in the database: what data Frequently visited? What data is junk data? What is the flow and processing of data? How are the data affected? Therefore, it is necessary to study an intelligent method to help relevant personnel to grasp the content and data relationship of the data mo...

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 & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 王东松
Owner 深圳市远行科技股份有限公司
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