CA ERwin Data Modeler User Interface › The Data Modeling Workspace › Logical and Physical Modeling › Logical and Physical Model Denormalization

Logical and Physical Model Denormalization

You can denormalize the structure of the logical model so that you can build a related physical model that is designed effectively for the target RDBMS. Use the features that support denormalization as follows:

Logical only properties for entities, attributes, key groups, and domains.

You can mark any item in the logical model logical only so that it appears in the logical model, but does not appear in the physical model. For example, you can use the logical only settings to denormalize subtype relationships or support partial key migration in the physical model.

Physical only properties for tables, columns, indexes, and domains.

You can mark any item in the physical model physical only so that it appears in the physical model only. This setting also supports denormalization of the physical model because it enables you to include tables, columns, and indexes in the physical model that directly support physical implementation requirements.