Insightful Database Design

Change-friendly DB Column Type

Centralize the definition of a column type. Definition used in entities automatically gets translated in database generation. Make change in one place, move effects across places.

Input sample data or initial database data when design database with Entity Relationship Diagram (ERD). The generated database initialization script includes insert sample data to the database.

Tutorial

• Specifying default data in database design

Generate entity relationship diagrams (ERD) from UML class diagrams and vice versa. Keeping both database design and object-oriented design always in-sync.

Tutorial

• Generate class diagrams from entity relationship diagrams

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 of 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

DB Visual ARCHITECT can design, reverse and generate stored procedures and database triggers. Flexible grouping helps to group stored procedures and triggers in meaningful way.

DB Visual ARCHITECT 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 demonstrate 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.