| |
Entity relationship diagram
|
|
Watch Demo »
|
|
| Learn how to work with entity relationship diagrams in VP-UML by going through steps like create entity, column, specify primary key, auto generate foreign key and presenting columns as icons. |
|
|
| | | |
| |
|
Reverse engineer existing databases to entity relationship diagrams (ERDs)
|
|
Watch Demo »
|
|
| Using VP-UML, you can reverse engineer databases to ERD in just a few steps. Databases from all popular database vendors are supported. |
|
|
| | | |
| |
|
Conceptual, logical and physical ERD support
|
|
Watch Demo »
|
|
| There are three types of ERDs: the conceptual, the logical, and the physical, which support modeling of data in three levels of abstraction from conceptual data model to implementation of a specific database. Visual Paradigm allows these three levels data modeling for facilitating the creation of database model independent on the particular database system. |
|
|
| | | |
| |
|
Define PK naming pattern
|
|
Watch Demo »
|
|
| Define the pattern of primary key, so that the name of primary key column will follow such pattern when create by synchronizing from object model to data model. |
|
|
| | | |
| |
|
Generate class diagrams from ERDs
|
|
Watch Demo »
|
|
| In VP-UML, you can generate class diagrams from ERD, and synchronize between them intuitively using the popup menu or mouse gestures. |
|
|
| | | |
| |
|
Select target diagram when first synchronized between class diagram and ERD
|
|
Watch Demo »
|
|
| With this new feature, now developers can specify which targeted ERD for the newly created class models to be synchronized in the first time, significantly enhanced the flexibility of the coding engineering process for database applications. |
|
|
| | | |
| |
|
Reverse engineer DDL models to ERD models
|
|
Watch Demo »
|
|
| A DDL (Data Definition Language) file is a computer language for defining data. Now, you can also use it to generate ERD with models like entities, views and relationships by reversing the DDL. |
|
|
| | | |
| |
|
Unique and Index support for entities
|
|
Watch Demo »
|
|
| Model unique and index in entity relationship diagram, and generate database tables from it. Grouping of index columns is also supported. |
|
|
| | | |
| |
|
Support AbstractPersistable class for generating non ORM super class attributes
|
|
Watch Demo »
|
|
| When we are design a class diagram, we often use generalization to move common properties to the super class. However, this may lead to existence of undesired entities when we synchronize the class diagram to an entity relationship diagram. Abstract Persistable a solution for making it possible to apply generalization in class diagram, making the attributes persistable, yet not persisting the Abstract Persistable class itself. |
|
|
|
|
| |
|
ORM diagrams
|
|
Watch Demo »
|
|
| ORM diagrams allow you to visualize the mapping between classes and entities, and you may synchronize models of both sides either automatically or manually. |
|
|
| | | |
| |
|
Generate and execute database schema (DDLs)
|
|
Watch Demo »
|
|
| After drawing ERD, you can generate the corresponding DDL for creating the database schema for your target database vendor. |
|
|
| | | |
| |
|
Reverse engineer stored procedures to ERDs
|
|
Watch Demo »
|
|
| Besides reverse engineering database tables, VP-UML also supports the reverse engineering of stored procedures to diagrams. |
|
|
| | | |
| |
|
Define FK relationship naming pattern
|
|
Watch Demo »
|
|
| Define the pattern of foreign key relationship, so that the name of relationships between entities will follow such pattern when create by synchronizing from object model to data model. |
|
|
| | | |
| |
|
Generate ERDs from class diagrams
|
|
Watch Demo »
|
|
| In VP-UML, you can generate ERD from class diagrams, and synchronize between them intuitively using the popup menu or mouse gestures. |
|
|
| | | |
| |
|
Database trigger and stored procedure modeling
|
|
Watch Demo »
|
|
| Our Entity Relationship Diagram supports visual modeling with stored procedures and database triggers. You can create and edit stored procedures and database triggers easily in an intuitive diagramming environment. |
|
|
| | | |
| |
|
Database trigger and stored procedure generation and reversal
|
|
Watch Demo »
|
|
| Stored procedure and database trigger are procedural code that can be executed at database. Visual Paradigm supports both generating and reversing stored procedure and database trigger to and from database. |
|
|
| | | |
| |
|
Convert a normal association to ORM association
|
|
Watch Demo »
|
|
| A problem ORM association refers to an association that is expected to be a persistable one, but now not. It can be caused by a wrong edit action. With this feature, users can fix problematic ORM association by just a few click. |
|
|
|
