Generating a PDM
|Previous Top Next|
From the Tools button, you can generate a Physical Data Model from an existing Conceptual Data Model. The PDM has to be of a certain DBMS type, as generating a PDM will use database system specific datatypes and features, like Domains.
For each of the available conceptual objects, a certain physical object is created.
However, this is not a one-on-one conversion. In some cases, a relation will generate an "intermediate" table, see Relationships to a PDM.
When the PDM gets generated, the objects in it will be auto-arranged, this might not be the optimal layout, but it should give a start.
Before a PDM is generated, the model will be validated, if the validation results in errors, the process cannot continue. After successful validation, an Options dialog will be shown.
When generating a PDM, the following options are available.
Available options when generating a PDM
The Target database version drop down box will hold the available versions for the selected target DBMS type. Depending on the version you're selecting, different features may be supported, for example, data types.
A PDM doesn't have to be associated with a database or session, they can be saved to a diagram file and re-used even without a database connection.
Next: Domains to a PDM