O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

ER/Studio comes equipped with denormalization wizards to help you optimize the physical design. The wizards automate the denormalization process and keep the ties between the physical tables and the logical entities. The denormalization wizards available depend on which tables are selected. For example, if two tables that are related to each other are selected, the valid operations would be rollups or rolldowns.

To bring up the denormalization wizard, highlight those entities you would like denormalized and decide whether you would like to rollup or rolldown:

Menu

Toolbar

Explorer

Shortcut Key

Shortcut Menu

n/a

Modeling toolbar:

n/a

n/a

Right-click on one of highlighted entities, Denormalization Mapping > Rollups ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required