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

Entity relation graph ERD graph generation method and equipment

A technology of entity relationship diagram and entity, which is applied in the field of communication, can solve the problems of relying on foreign keys in reverse production of ERD diagrams, and the inability to completely reverse produce ERD diagrams, etc., and achieve the effect of improving adaptability and efficiency

Inactive Publication Date: 2020-06-02
上海逸迅信息科技有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] In the process of implementing the present invention, the inventor found that the reverse production of ERD diagrams in existing DBMS databases depends on foreign keys, and if there are no foreign keys, the relationship of entities cannot be generated
In some current environments (Internet environment), due to cost and equipment performance considerations, the DBMS design pattern does not recommend foreign key constraints, so many DBMS tables do not have foreign keys; in addition, the current ODS (Operational Data Store, operational data storage ) data warehouse does not recommend foreign keys, and cannot completely reverse the ERD diagram

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
  • Entity relation graph ERD graph generation method and equipment
  • Entity relation graph ERD graph generation method and equipment
  • Entity relation graph ERD graph generation method and equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0049]As mentioned in the background technology, in the prior art, ERD diagrams are generally generated by using foreign keys, but foreign keys also have various disadvantages, such as the database needs to maintain the internal management of foreign keys, and foreign keys are equal to data consistency. The implementation of transactions (meaning that the database must be in a consistent state before and after the execution of a transaction) is all completed by the database server. After adding, deleting, and updating operations involving foreign key fields, related operations need to be triggered to check. It has to consume server resources (CPU, memory, etc.), and foreign keys are prone to deadlocks because they need to request internal locks on other tables. Therefore, in some environments or industries, foreign keys are not used, especially in the Internet industry, where the number of users is large and the degree of concurrency is high. Therefore, the database server can ...

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 an entity relation graph ERD graph generation method. According to the method, word segmentation processing is carried out on physical names of entities and physical names of attributes in a database; and synonym merging is performed on prototype words corresponding to the words after word segmentation processing so as to generate standardized words, vectors corresponding to entities and attributes are generated according to the word frequency attributes of the words in the standardized word set, then the similarity between the entities and the attributes is determinedaccording to the vectors, and finally an ERD graph corresponding to the database is generated according to the similarity. According to the technical scheme, the accurate ERD graph can be quickly generated on the premise of not depending on a foreign key, so that the adaptability and efficiency of reverse work are improved.

Description

technical field [0001] The invention relates to the field of communication technology, in particular to a method for generating an entity relationship graph (ERD). The invention also relates to an ERD diagram generation device. Background technique [0002] ERD diagram (Entity Relationship Diagram, Entity Relationship Diagram) provides a way to represent entity types, attributes and connections, and is a conceptual model used to describe the real world. The ERD diagram is a data model or schema diagram used in the high-level description of the conceptual data model, which provides a graphical symbol for expressing the data model in the form of the entity relationship schema diagram. The basic elements that constitute the ERD diagram are as follows: [0003] Entity: Objects that can be distinguished from each other objectively are entities. Entities can be specific people and things, or abstract concepts and connections. The key is that one entity can be distinguished from...

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/28
CPCG06F16/288
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com