Data Modeling

Consistent DB Column Type

Centralize the definition of a column type. Use it in class attributes and let code generation take care of the translation. Any changes become a breeze!

Input initial database record when designing database with entity relationship diagram (ERD). When you generate database or DDL from ERD, those sample records will be included.

Tutorial

• Specifying default data in database design

Mapping View:

	Class Mapping

	Attribute Mapping

Object-relational mapping diagram (ORM diagram) presents the mapping between classes and entities visually. Visualization between classes and entities can help developer to gain more understanding on how a row of data in database transform to/from object in memory. The following movie shows how to visualize the mapping between classes and entities.

Know-how

• Comparison of query performance when working with ORM

Design, reverse and generate stored procedures and database triggers. Flexible grouping helps to group stored procedures and triggers in meaningful way.

User's Guide

• Drawing stored procedures

Run checks on Data Definition Language (DDL) or Data Manipulation Language (DML) statements for the selected entities ad-hoc.

Visual Paradigm for UML imports AllFusion ERWin Data Modeler project files. You can import your entire AllFusion ERWin Data Modeler project files into Visual Paradigm format. The following screenshots demonstrates how to import AllFusion ERWin Data Modeler project file.

Import ERWin Data Modeler project files

Step 1 of 3: Produce XML file from ERwin

In ERwin Data Model, save the project as an XML file.

Step 2 of 3: To import ERwin project

Import the XML file in VP by selecting File > Import > ERwin Project (XML)... from the main menu.

Step 3 of 3: Specify file path

Specify the file path of the XML file, then click OK. After that, select the imported diagram(s) to open. Once complete, you may perform modeling in VP in further.

User's Guide

• Importing ERwin data modeler project into VP-UML