Generating OOM objects to a PDM

Generating OOM objects to a PDM

When you generate a Physical Data Model (PDM) from an Object-Oriented

Model (OOM), PowerDesigner translates OOM objects and data types to

PDM objects and data types supported by the current DBMS.

The current object language of an OOM has no effect on the generation to a

PDM.

Translating OOM objects into PDM objects

PDM generation translates OOM objects into physical objects.

OOM object

Domain

Class

Interface

Attribute

Identifier

Operation

Association

Dependency

Realization

Generalization

PDM object after generation

Domain

Table (only if the Persistent and Generate checkboxes are selected in the class property sheet). The cardinality of a class becomes the number of records of a table

Not translated

Column

Identifier

Stored-Procedure

Reference or table

Not translated

Not translated

Reference

Generating from

For a class to become an table the Persistent and Generate checkboxes must

classes

be selected in the property sheet of the class.

 

The cardinality of a class becomes the number of records of a table.

Generating from

If the association has a many-to-many cardinality, that is, where both roles of

associations

the association have the * sign selected in their multiplicity dropdown

 

listboxes, then the association is translated into a table in the generated PDM.

 

If it has any other cardinality, that is, where one of the roles of the association

 

does not have an * selected in its multiplicity dropdown listbox, then the

 

association becomes a reference.

 

A role name becomes a migrated foreign key after PDM generation.

216

 

Page 226
Image 226
Sybase 7.5 Generating OOM objects to a PDM, Translating OOM objects into PDM objects, Generating from, Associations, 216