When you transform a physical data model into a logical
data model, certain naming rules are used. Physical data objects are
transformed into corresponding logical data objects according to certain
rules.
When a physical data model is transformed to a logical
data model, table and column names are transformed to entity and attribute
names according to the following rules:
- The name of each physical data object is used for the corresponding
logical data object.
- The separator character that is defined for physical data objects
on the Naming Standard preference page is replaced
by the separator character that is defined for logical data objects
on the Naming Standard preference page.
Physical data objects are transformed to logical data
objects according to the following rules.
Table 1. Physical
to logical data model object mappingsPhysical data object or property |
Logical data object or property generated by
the transform |
Table |
Entity |
Column |
Attribute |
XML Column |
XML Attribute or Entities |
Foreign key constraint and relationship |
Foreign key and relationship |
Primary key constraint |
Primary key |