Visual Paradigm logo

Entity Relationship Diagram (ERD) Tool
for Data Modeling using ORM Hibernate Framework

Overview

Data modeling is often the first step in database design as the designers first create a conceptual model of how data items relate to each other, it will then involve a progression from conceptual model to logical model, and to physical schema. These diagrams can be used as a blueprint for the construction of new software or for re-engineering a legacy application.

  • Entity Relationship Diagram
    ER Diagram Tool that supports different levels of database design needs (Logical, Conceptual, and Physical).
  • Conceptual ERD
    Conceptual ERD - Traceability is maintained between conceptual and logical ER model.
  • Logical ERD
    Logical ERD - Again, you can derive the Physical model from the Logical model and with traceability maintained.
  • Physical ERD
    Physical ERD - The physical database schema ready for ERD to database generation.
  • Form ERD from Database
    Form Entity Relationship Diagram (ERD) from physical database. Support wide-range of DBs: MySQL, Oracle, MS SQL Server, Sybase, PostgreSQL, Firebird, INGRES, Derby, MariaDB, etc.
  • Generate Database from ERD
    Generate a new database and DDL from ERD, or apply patching changes to an existing database
  • Synchronization Between ERD and UML Class Diagram
    Synchronize between ER diagram and UML Class Diagram. The entities, columns, relationship and layout are automatically be converted into UML classes, attributes and associations.
  • Hibernate ORM Wizard
    Generate ORM Hibernate mapping tier and the necessary source files (including samples) for programming purpose.
  • Using ORM Code
    Programming with the generated ORM tier in Eclipse. ORM allows developers to access a relational database through the generated classes without writing a single line of SQL!
  • Integrate Entity in DFD
    Incorporate an ERD entity in a DFD, which shows the way how data (identified in DFD) shall be persisted in physical RDBMS.
  • Using Visual Diff on ERD
    Compare the differences between current and target database design using Visual Diff. In this example, it reported that the entity has been renamed.

Key Benefits

  • Help to manage the vast and complex data environments found in the modern organization
  • Add value to the business through cost reduction and improved data quality by providing visual modeling simplicity and automation

Major Features

  1. Transform Your Design Smoothly from one model to another
    • Design from conceptual model for your problem and seamlessly progressing to logical model, and subsequently to physical schema for automatic database generation
    • Maintain the traceability between models automatically
    • Support most of the leading databases in market (when change the connection of the database type, the diagram will automatically be conformed to column type style of the supported database)
    • Generate database schema from the entire ER diagram, a part of even a single entity of the diagram
  2. Reverse engineering of existing database from either a database or DDL
  3. Flexibly generate database from different models and keep them in sync bi-directionally
    • Class diagram to ERD
    • ERD to Class Diagram
  4. Integrate RDBMS with object-oriented technology using Object-Relational Mapping with Hibernate Framework and make the auto transformation with the easy ORM Wizard
  5. Support stored procedure and triggers in code engineering
  6. Switch the connection between the production database, or your personal database at your own choice
  7. Use Visual Diff to identify the modifications between different version of diagrams
  8. Reference your data entity from one model to another model, such as, a piece of data entity in the database linking to a data field a wireframe of your UX model

Learn More

Request Demo


Believe Us! You Will Love Visual Paradigm's Solutions -- But You Be the Judge.

Schedule a Demo

We are trusted by over 320,000 people in companies ranging from small business to Fortune 500 companies, universities and government units.

Who's using Visual Paradigm?