Chat now with support
Chat mit Support

Toad Data Modeler 7.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 Microsoft SQL Server 2019 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 MySQL 8.0 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Oracle 19c PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 PostgreSQL 11 PostgreSQL 12 SQLite 3.7 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Copyright Legal Notices

Move Entities

In Toad Data Modeler there are several methods to move entities. You can select from the following options.

To move entities on a Workspace, use

  • Drag&Drop techniques

or

  • Keyboard arrows

TIP:

  1. Select Settings | Options | Graphics | Move Objects by (mm/10) to set the size of a step to move (in tenths of millimeters).
  2. Select an entity, press SHIFT, hold it down and use the keyboard arrows to change size of the entity box.

To move multiple entities at once

  1. Make multiple selection of entities (see Select Objects for more information).
  2. Point your mouse cursor at any of the selected entities, click and hold the mouse button down.
  3. Drag the objects to the required position and drop. All selected entities will be moved there, including their relationships.

To move entities to another Workspace or another model, select from the following options:

  • Cut&Paste functions: Edit | Cut/Paste, or via shortcuts CTRL+X, CTRL+V
  • Drag&Drop techniques between the Entities dialogs of two different models
  • Drag&Drop techniques between the Entities dialog and Model Explorer
  • Drag&Drop techniques in or from Model Explorer
  • Drag&Drop techniques between Entities dialog/Model Explorer and Workspace

Example: Moving an entity from Model A to Model B using Model Explorer:

Method 1: Moving an entity between Model Explorers of the two models.

  1. Open Model Explorers in both models. You may want to undock at least one of the Model Explorer windows.
  2. Select an entity in Model Explorer A and hold the mouse button down.
  3. Drag the entity to the Entities folder in the Model Explorer B and drop.

Version B: Moving an entity from Model Explorer A directly to a Workspace of Model B.

  1. Undock the Model Explorer A if it's docked, and click the Workspace tab of Model B in the Application Window.
  2. Select an entity in Model Explorer A and hold the mouse button down.
  3. Drag the entity to a Workspace of Model B and drop.

Entity Right-Click Options

Right-click the selected entity on the Workspace to see the following options:

Option Description

Format

Opens the Object Format dialog for the selected entity.

Add into Workspace

Opens the Workspaces dialog where you can select a Workspace to add the entity to.

Add into New Workspace

Creates a new Workspace and adds the entity to it.

Remove from Workspace

Removes the selected shortcut from particular Workspace.

Delete Object

Deletes selected entity from model.

Arrange

Arranges the entity in another layer.

Arrange Objects in Layers

Copy Object Layout to Copies the layout of the selected object to another Workspace
Add Object to Gallery Adds objects to selected Gallery.

Recalculate Size

Adjusts the entity size to the length of its columns.

Align Self Relationship

Aligns self relationship.

Edit

Opens the Entity Properties form.

Add Creates a new object (Attribute, Key or Index) in the selected entity.
Change Script Contains one option that allows you to compare selected entity with any other entity in another model or database and generate Change Script.
Edit Attribute... Opens Attribute Properties form (the item is active if attribute is selected)
Select  
Select Parent Objects Selects parent objects of the selected entity on Workspace.
Select Child Objects Selects child objects of the selected entity on Workspace.
Select Parent and Child Objects

Selects parent and child objects of the selected entity on Workspace.

TIP: Use these options for next multiple copy, move, format change etc.

Fill  

Fill Parent Objects

Displays shortcuts of parent objects of the selected entity on Workspace.

Fill Child Objects

Displays shortcuts of child objects of the selected entity on Workspace.

Fill Parent and Child Objects

Displays shortcuts of parent and child objects of the selected entity on Workspace.

Add to Category Adds object to selected category.
Macros Shows available macros for the selected entity.
 

Attributes

Toad Data Modeler allows you to design Entity Relationship Diagrams of specific database platforms, convert physical model from one database platform to another, create an ER Diagram directly from your database (Reverse Engineering feature), update physical models, generate DDL/SQL scripts and Change Scripts, create Dictionary Types, Views, Triggers, Functions, generate detailed documentation to your model (in HTML, RTF, PDF, XSLT formats) and much more.

This chapter describes features and functions related to Physical Data Modeling. Look around each section to get the information you need.

Note: See the sample physical model Videorental (Oracle 10g db) that is included in the installation package of Toad Data Modeler. Default location is: C:\Program Files (x86)\Quest Software\Toad Data Modeler7.3\Samples.

Benefits of Physical Data Model

  • Detailed definition of database structure, including database specific items, for example:
    • Stored procedures
    • Functions
    • Triggers
    • Views
    • Materialized views
    • Sequences (auto increments) etc.
  • Possibility to synchronize local model with existing database.
  • Possibility to specify logical names for objects (captions for tables, attributes and other objects).
  • Detailed database specific information can be exported to HTML/RTF/PDF or XML/XHTML/CSV reports.
  • Automatic generation of SQL code for selected objects (SQL code generation is not available in Logical and Universal Model)
  • Automatic migration of PK attributes to child entities (Attributes don't migrate to child entities in Logical Model)

Create Attributes

You can create attributes in:

  • Entity right-click menu on Workspace
  • Entity Properties dialog
  • Attribute Properties dialog
  • Model Explorer

To create an attribute on the Workspace

Right-click an entity on the Workspace and select Add | Attribute. The Attribute Properties dialog opens.

Note: Select the Primary Key (Unique) checkbox to set the attribute as PK or unique attribute.

To create an attribute in the Entity Properties form

  1. Double-click an entity on Workspace.
  2. In the Entity Properties form, switch to the Attributes tab and click Add.

Entity Properties attribute columns

Column/Option Description

Key

Graphical representation of keys of a particular attribute

Caption

Logical attribute name

Name

Physical attribute name

Data Type

Data Type of an attribute

TIP: You can set a default data type for newly created attributes. See Settings Menu | Options | Physical Model | *database platform and version* | Default Data Type combo-box. (The selected data type will be also applied to Dictionary Types and Domains.)

p1

Parameter 1. Only some of the available data types have this parameter. Defines properties of the selected data type, e.g. length in case of the Char data type.

p2

Parameter 2. Only some of the available data types have two parameters. E.g. the Decimal data type has two parameters, which define precision and scale.

Not Null

When checked, the attribute cannot be empty.

Comments

Comments or descriptions related to the attribute

Status

Shows status of attributes in grid. Status of Items in Grids

Buttons:

- opens the Application Variables form

Smaller Add button- adds new attributes quickly, just enter attribute name and then click Add.

Bigger Add button - adds an attribute

Edit - opens Attribute Properties of the selected entity

Delete - deletes the selected attribute

- moves the selected attribute up or down in the list

To create another attribute in the Attribute Properties form

Click OK+Add.

To create an attribute in Model Explorer

Unfold the Entities folder | Unfold the specific entity folder | Right-click the Attributes folder | Add Attribute.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen