Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for generating E-R map through intelligent analysis database table relation

An intelligent analysis and database technology, applied in the database field, can solve problems such as long system life, difficult database operation and maintenance work, difficulty in understanding database design, etc., and achieve the effect of reducing the difficulty of operation and maintenance

Active Publication Date: 2016-12-14
深圳市卓讯信息技术有限公司
View PDF6 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the maintenance work of the legacy system, especially the maintenance workload of the legacy database is gradually increasing. Due to the long life of the legacy system and the lack of complete and clear documents, it is difficult for software maintainers to understand the design of the database, so that they cannot accurately grasp the database tables. The various dependencies between the database and the lack of understanding of the dependencies of the database tables make the operation and maintenance of the database in the legacy system difficult.

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
  • Method and device for generating E-R map through intelligent analysis database table relation
  • Method and device for generating E-R map through intelligent analysis database table relation

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0038]The present invention provides a method and device for intelligently analyzing database table relationships to generate E-R diagrams, which are applied in the field of database technology. The method for intelligently analyzing database table relationships to generate E-R diagrams provided by the present invention includes: collecting SQL statements executed during business processing ;Analyze the SQL statement that is executed when the collected business is processed, filter out the qualified SQL statement and mark it; according to the filtered SQL statement, obtain the association relationship between the database tables; according to the obtained database The association relationship between tables generates the E-R diagram of the database table relationship, so as to help users intuitively obtain the association relationship between the database tables, and can intuitively display the generated E-R diagram of the database table relationship through graphic display , r...

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 discloses a method and device for generating an E-R map through an intelligent analysis database table relation. The method includes the steps of collecting SQL sentences executed when service is handled, analyzing the collected SQL sentences executed when service is handled, screening out and marking the SQL sentences meeting the conditions, obtaining the relation between database tables according to the screened-out SQL sentences meeting the conditions, and generating the database table relation E-R map according to the obtained relation between the database tables. Thus, a user can be visually helped to obtain the relation between the database tables, the generated database table relation E-R map can be visually shown in the form of image-text, and the operation and maintenance difficulty of databases is reduced.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for intelligently analyzing database table relationships and generating E-R diagrams. Background technique [0002] E-R Diagram: Entity Relationship Diagram (Entity Relationship Diagram), which provides a way to represent entity types, attributes and connections, and is used to describe the conceptual model of the real world. [0003] SQL: Structured Query Language (Structured Query Language) is a database query and programming language for accessing data and querying, updating and managing relational database systems; it is also the extension of database script files. [0004] In recent years, due to the rapid development of computer technology and continuous changes in business, more and more systems have become legacy systems because they cannot adapt to current application changes. Therefore, the maintenance work of the legacy system, especially the mai...

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
CPCG06F16/21
Inventor 邹纪根赖旭军
Owner 深圳市卓讯信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products