Benefits of Designing Database with Visual Paradigm

Visual Paradigm provides the following key features so as to help you simplify your application development:

Persistance Made Easy

Traditionally developers spend a lot of effort in saving and loading objects between memory and database which makes the program complicated and difficult to maintain. Visual Paradigm simplifies these tasks by generating a persistence layer between object and data models.

Sophisticated Object-Relational Mapping Generator

Visual Paradigm generates object-relational mapping layer which incorporates prime features such as transaction support, pluggable cache layer, connection pool and customizable SQL statement. With this mapping layer, developers can keep away from mundane implementation work and focus on the business requirements.

Model Driven Development

Visual Paradigm provides a true model driven platform for application development. Visual Paradigm allows developer not only to start from creating the models by using UML Class Diagram or Entity Relationship Diagram tools (ERD tools) to generating the executable persistence layer from the models, but also to modify the entity-relational model which comes from reverse engineering an existing database, transform into object model and generate persistence layer. With the sophisticated model-code generator, the persistent model will be updated automatically according to any modification.

Extensive Database Coverage

Visual Paradigm supports a wide range of database, including Oracle, DB2, Cloudscape/Derby, Sybase Adaptive Server Enterprise, Sybase SQL Anywhere, Microsoft SQL Server, PostgreSQL, MySQL and more. Visual Paradigm also promotes an easy migration between databases by enabling the same set of ORM Java objects to work with different databases and transforms the proprietary data type that suit the default database specified.

Database Reverse Engineering

Visual Paradigm allows you to reverse engineering an existing database through JDBC into the entity-relational model. Developers can transform the entity-relational model to object model and redesign the database for further development

Class Reverse Engineering

Visual Paradigm allows you to reverse engineering Java classes and Hibernate models into the persistent object model. Developers can transform the persistent object model to data model and redesign the models for further development.

IDE Integration

Visual Paradigm is not only a standalone application, but also integrated to the major Integrated Development Environments (IDEs), including Eclipse, NetBeans, IntelliJ IDEA and Visual Studio, which results in streamlining the entire model code- deploy software development process.

Related Resources

The following resources may help you to learn more about the topic discussed in this page.

1. Overview of Database Design & Management with Visual Paradigm Table of Contents 3. Database Configuration