Chat now with support
Chat with Support

Toad Data Modeler 6.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 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
Legal Information

Inheritance

Models and Model Objects > Logical Data Model > Conversion to Physical Model > Inheritance

Inheritance is a special abstract object which can be used in early phases of database development to visualize the inheritance process.

However, Inheritance is only supported in Logical Model. When converting Logical Model to Physical Model, Toad Data Modeler resolves Inheritance one of the three ways:

  • Single Table
  • N - 1 Tables
  • N Tables

Before you convert your Model, you have the option to pick one of the three ways to resolve all Inheritance objects:

  1. Double-click the Inheritance and select tab Generation.
  2. In the Physical Implementation area, select any of available options:

a) Single Table - Parent Inherits All Children

The conversion output is the following:

b) N - 1 - Each Child Inherits the Parent

The conversion output is the following:

c) N Tables - Physical Model Matches Logical

The conversion output is the following:

Note:

    Single Table Generation (Parent Inherits All Children), Discriminator for Child Entities is Set - After the conversion, a check constraint will be created in parent entity in PER model. This check constraint determines conditions for setting Not Null value of attributes taking into account options set in Discriminator.
  • Inheritance Exclusive, N - 1 Generation (Each Child Inherits the Parent) - During the conversion, all attributes of parent entity will be passed to child entities and triggers will be created in the child entities. These triggers determine creation of new items in child entities. - Rule: it is not possible that two child entities with the same key of parent entity would exist.
  • N Tables Generation (Physical Model Matches Logical) - Instead of inheritance, relationship (identifying by default) will be created between parent and child entities in PER model.
  • Inheritance conversion - Relationship names are made unique in physical model. 
  • N - 1 Tables - Each Child Inherits the Parent: Relationship name_number (e.g. Relationship1_1, Relationship1_2)
  • N Tables - Physical Model Matches Logical: Parent Entity Name_Child Entity Name

Defaults

Defaults

Models and Model Objects > Logical Data Model > Defaults > Defaults

To add a default

Select Model | Model Items | Defaults and click Add in the Defaults dialog.

To edit a default

Select Model |Model Items | Defaults and double-click the selected default or click Edit.

Note: You can also edit/rename/delete defaults in Model Explorer | Defaults folder | Right-click the selected default.

To select a default for attributes

  1. Open the Attribute Properties dialog of the selected attribute | General tab.
  2. From the Default Rule box, select a default or write your own default to the Default box.

Note: You can define defaults for domains too.

Rules

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating