AST-based relational database SQL table relation analysis and display method

A relational analysis and database technology, applied in the web field to achieve the effect of clear and intuitive understanding

Pending Publication Date: 2020-01-10
山东爱城市网信息技术有限公司
View PDF2 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the development and growth of Internet technology, business requirements are changing rapidly, and product complexity is also increasing rapidly, causing development, testing, and operation and maintenance personnel to often encounter many difficulties when sorting out the underlying business logic

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
  • AST-based relational database SQL table relation analysis and display method
  • AST-based relational database SQL table relation analysis and display method
  • AST-based relational database SQL table relation analysis and display method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative work belong to the protection of the present invention. scope.

[0056] An AST-based relational database SQL table relationship analysis and presentation method of the present invention,

[0057] ①Mainly include the following two aspects:

[0058] Analyzing sql in the web background: through lexical and grammatical analysis of the input sql, an abstract syntax tree AST of the sql is generated, and then the syntax tr...

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 an AST-based relational database SQL table relation analysis and display method, and belongs to the technical field of web, java and databases. According to the method, an abstract syntax tree AST of sql is generated through syntax and lexical analysis of sql, and then the generated abstract syntax tree AST is accessed and traversed to extract tables and fields, so that analysis of table relationships of sql statements of the relational database and analysis of subordinate field relationships are realized. The table relationship and the field relationship are visually displayed in a drawing form through Mxgraph. And the complexity of association analysis is further reduced, and the compatibility of the system is improved.

Description

technical field [0001] The invention relates to web, java and database technologies, in particular to an AST-based relational database SQL table relationship analysis and presentation method. Background technique [0002] With the development of Internet technology, business requirements are changing rapidly, and product complexity is also increasing rapidly, causing development, testing, and operation and maintenance personnel to often encounter many difficulties when sorting out the underlying business logic. Contents of the invention [0003] In order to solve the above technical problems, the present invention proposes an AST-based relational database SQL table relationship analysis and display method, through which table relationships and field relationships are analyzed, so that development, testing, and operation and maintenance personnel can sort out the underlying business logic , can have a very clear and intuitive understanding of the underlying business logic r...

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): G06F16/28G06F16/25G06F16/242G06F16/2455G06F16/26
CPCG06F16/287G06F16/252G06F16/2433G06F16/24553G06F16/26
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