Data Modeling Genie

Generate database from ERDs, with sample data, as you wish.

Entity relationship diagram

Entity relationship diagram (ERD) is used to present the Entity-Relationship Model in software engineering industry. ERD can be used for visualizing conceptual data structure and physical database schema. Smart Development Environment for Eclipse supports conceptual, logical and physical data modeling.
The following movie shows how to create conceptual data model and transit the conceptual data model to physical. The movie shows also the modeling of physical database schema, stored procedure and generates DDL from physical database design.

Online training

Basic Database Modeling Techniques (Free)

Know-how

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!

Define sample data in ERD

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

Object-Relational Mapping diagram

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

Stored procedure and trigger

Smart Development Environment for Eclipse can design, reverse and generate stored procedures and database triggers. Flexible grouping helps to group stored procedures and triggers in meaningful way.

Test Drive with Your DDL

Preview to see if there are any potential problems found in the Data Definition Language (DDL) or Data Manipulation Language (DML) statements for selected entities ad-hoc.

Import ERWin Data Modeler project files

Smart Development Environment for Eclipse 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.