Book a Demo
Prev Next

Create a Data Model from a Model Pattern

The easiest way to create a Data Modeling workspace is to use the predefined Database Model Patterns, available through the Model Builder.  Enterprise Architect provides a Pattern for each DBMS supported by the system.

Access

Display the Model Builder using any of the methods outlined here.

In the Model Builder dialog, select the 'Database Engineering' Perspective.

Ribbon

Start > Personal > Model Builder

Design > Package > Model Builder

Context Menu

Right-click on Package | Model Builder (pattern library)

Keyboard Shortcuts

Ctrl+Shift+M

Other

Browser window caption bar menu | Model Builder (pattern library)

Create a Data Model

Field/Button

Action

See also

Add to Package

Displays the name of the selected root Package.

Technology

Click on 'Database'.

Name

If necessary, expand the Database Engineering group of Patterns.

Click on the checkbox against each Database Management System you are supporting in the model.

All

Click on this button to select the checkboxes for all Database Engineering model types and the Entity Relationship diagram, to include them all in the model.

None

Click on this button to clear all selected checkboxes so that you can re-select certain checkboxes individually.

OK

Click on this button to add to the Browser window the Packages and diagram for each Database Management System you are modeling.

What each Data Modeling Pattern provides

  • A summary diagram of the model
  • A Report Specification Artifact element (on the summary diagram) that can be used to quickly document the data model
  • A Package for each of the Logical and Physical models
  • Within the Physical Model Package, a predefined hierarchy of sub-Packages, one for each object type supported by the DBMS being modeled (such as Tables, Views, Procedures and Functions); these automatically organize the database objects as they are added
  • The DBMS type for the workspace
  • A default owner
  • A Data Modeling diagram in each Package with the connector notation set to IDEF1X

Notes

  • Once a data modeling workspace has been created, you can begin to develop your model in one of two ways:
         -  Through the Database Builder, which is a purpose-built view that supports database modelers
         -  Through the Browser window and diagrams, which is the traditional method that might suit users
             who are experienced UML modelers

Learn more

Prev Next