Logical-to-physical data model object naming rules

When you transform a logical data model into a physical data model, certain rules are followed to generate the name of the physical data model objects.
When a logical data model is transformed to a physical data model, entity and attribute names are transformed to table and column names according to the following rules:
  • If an entity has a defined abbreviation property, the corresponding table is named according to the abbreviation property.
  • If an entity does not have a defined abbreviation property, the Transform to Physical Data Model wizard searches for the entity name in the glossary models that are specified for the project. If the entity does not have a glossary model name, or there is no glossary model specified for the project, then the entity name is used.
  • If an attribute has a defined domain property, then the corresponding column is named according to the name of the domain property.
  • If an attribute does not have a defined domain property but has a defined abbreviation property, the corresponding column is named according to the abbreviation property.
  • If an attribute does not have a defined domain or abbreviation property, the Transform to Physical Data Model wizard searches for the attribute name in the glossary models that are specified for the project. If the attribute does not have a glossary model name, or there is no glossary model specified for the project, then the attribute name is used.
Related tasks
Setting constraint transformation properties for logical-to-physical data model transformation
Setting generalization transformation properties for logical-to-physical data model transformation
Setting inversion entry transformation properties for logical-to-physical data model transformation

Feedback