Refactoring the logical model

Overview

Before generating the physical model, we strongly recommend that you structure your logical model in such a way as to avoid the errors that are frequently encountered when generating the physical model.

The available refactoring commands are as follows:

· "Set transient", which is used to mark all the element in a sub-hierarchy of the logical model as being transient, which allows you to not have them figure in the generated physical model.

· "Generate valid names for SQL", which generated the {sqlName} tagged value containing the name of the entity inside which the non-valid SQL characters have been replaced by valid characters (deletion of accents, replacement of special characters by the "_" character, and so on), if you have not already defined the {sqlName} character.

· "Regroup DataTypes and Enumeration", which groups all the datatypes and enumerations belonging to a package (and its classes) in a sub-package named "Enums and datatypes". Each attribute typed using a datatype or enumeration is retyped as a string limited to eight characters.

· "Linearize subclasses trees", which linearizes classes within each sub-package.

Note: All these commands deal with all the data contained in the package on which they are run.

Refactoring an MLD package

To open the refactoring dialog box, the "MDACs/SQLDesigner/Refactor MLD…" command is run on the package from which you want to run the refactoring operation. This package must belong to the logical model (MLD).

Figure 70. The MLD refactoring dialog box

To run the different commands, simply check the relevant tickbox and then click on "OK".