Table 1 shows the correspondence between logical data objects and physical data objects.
Logical data object or property | Physical data object or property generated by the transform |
---|---|
Atomic domain (general) | None. If an attribute uses a domain data type, then the corresponding column is set to the base type of the domain. The column stores a URL to the domain. |
Atomic domain (with enumeration constraint) | Check constraint. |
Attribute - Alternate key property | Unique key constraint. |
Attribute - Data type property | The equivalent physical data type. Data type mappings are set in the Preferences window or in the Transform to Physical Data Model wizard. |
Attribute - Default value property | Default value. |
Attribute - Foreign key property | Foreign key constraint. |
Attribute - Primary key property | Primary key constraint. |
Attribute - Required property | Not null. |
Attribute - Surrogate key property | An identity or sequence. The option for transforming surrogate keys is set on the Options page of the Transform to Physical Data Model wizard. |
Constraint | A check constraint, trigger, or none. The option for transforming entity constraints is set on the General page of the Properties view in the Transform as field. |
Entity (Persistent) | Table. The option for whether to transform entities is set on the General page of the Properties view in the Persistent check box. |
Entity (Not Persistent) | Entity is not transformed. The option for whether to transforming entities is set on the General page of the Properties view in the Persistent check box. |
Generalization (Separate table) | A single table that contains columns equivalent to attributes for the super type. A type table will be created and linked to the table with an identifying relationship. The option for transforming generalizations is set on the General page of the Properties view in the Transform as field. |
Generalization (Roll Up) | A single table that contains columns equivalent to the attributes of the super type. A type table is created and linked to the table with an identifying relationship. The option for transforming generalizations is set on the General page of the Properties view in the Transform as field. |
Generalization (Roll Up) - Sub type | None. |
Generalization (Roll Up) - Super type - Key attributes | The equivalent key columns in the table. |
Generalization (Roll Up) - Super type - Non-Key Attributes | The equivalent non-key columns in the table. Functional dependency is introduced so that all non-key columns have functional dependencies on the key column. |
Generalization (Roll Up) - Super type - Owned relationships | The table owns the relationships. |
Generalization (Roll Up) - Super type - Referenced relationships | The relationships reference the table. |
Generalization (Roll-Down) | A table that corresponds to each subtype. Each table contains columns equivalent to the attributes of the corresponding subtype. |
Generalization (Roll-Down) - Super type | None. |
Generalization (Roll Up) - Sub type - Key attributes | The equivalent unique key columns in each table that correspond to a sub type. |
Generalization (Roll Up) - Sub type - Non-key attributes | The equivalent non-key columns in each table that correspond to a sub type. |
Generalization (Roll Up) - Sub type - Owned Relationships | A relationship is created for each table that corresponds to a sub type and the table owns the relationship. |
Generalization (Roll Up) - Sub type - Referenced Relationships | A relationship is created for each table that corresponds to a sub type and the relationship references the table. |
Generalization - Defining Attribute | The selected attribute is defined as a type discriminator for the generalization. When you transform to a physical model, a typed table is added only when no type discriminator is defined on the generalization and the Roll Up option is selected in the Transform as field. |
Inversion entry | An index or none. The option for transforming inversion entries is set on the General page of the Properties view in the Transform as field. |
Package | All packages are transformed to one schema. The schema name is specified on the Options page of the Transform to Physical Data Model wizard. |
Relationship - Identifying | Identifying relationship. |
Relationship - Non-identifying optional | Non-identifying optional relationship. |
Relationship - Non-identifying mandatory | Non-identifying mandatory relationship. |
Relationship - Many-to-many | A join table and two identifying relationships. |
Relationships - Referential integrity properties | Only the child table ON DELETE and ON UPDATE options are carried over to the physical data model. |
Relationships - Range cardinality properties | The corresponding child end is set to a cardinality string that is constructed from the logical range property values. |
Relationships - Verb phrase property | Verb phrase. |