An activity that includes producing a Rationalized Physical Data Model (RPDM) that makes a copy of each Table that contains redundant columns into a Materialized View, moves the redundant columns from the Table into Materialized Views, adds for each of these columns the function that is used to derive them, and adjusts the name of either the Table or the Materialized View according to an approved naming standard and related procedure. The Materialized View carries the indexes and constraints that involve the redundant columns, instead of the Table. The source for the redundant columns in other views becomes the Materialized View instead of the Table. This is a new modeling activity that TDM proposes to set the stage and facilitate further reverse engineering into various data models, from the DSM to an LDM. This activity must be preceded by producing a recent reversed engineered PDM from the target database, schema or environment.