Generating Other Models from an OOM

You can generate conceptual and physical data models and XML models from an OOM.

The following table details how OOM objects are generated to other models:

OOM

CDM

PDM

XSM

Domain

Domain

Domain

Simple Type

Class (Persistent and Generate check boxes selected).

Entity

Table (The cardinality of a class becomes the number of records of a table.)

Element

Abstract class

Entity

Table

Complex type

Attribute (Persistent check box selected)

Attribute

Column

Attribute or element (see generation options)

Identifier

Identifier

Identifier

Key

Composition

-

-

New level in the element hierarchy

Operation with <<storedProcedure>> stereotype (parent class generated as a table)

-

Stored procedure attached to the table, with the operation body as a body in the procedure definition.

-

Operation with <<storedFunction>> stereotype (parent class generated as a table)

-

Stored function attached to the table, with the operation body as a body in the function definition.

-

Association

Relationship or association

Table (if many-to-many multiplicity) or reference. Role names become migrated foreign keys.

KeyRef constraints

Association class

Entity/relationship notation: entity with two associations.

Merise notation: association, and two association links

A table and two associations between the end points of the association class

-

Dependency

-

-

-

Realization

-

-

-

Generalization

Inheritance

Reference

Complex type derivation (XSD) or attribute migration to child element (DTD)

  1. Select Tools, and then one of the following to open the appropriate Model Generation Options Window:
    • Generate Conceptual Data Model... Ctrl+Shift+C - For example, to translate OOM classes into CDM entities. You will then be able to further refine your model and eventually generate a Physical Data Model (PDM) from the CDM.

    • Generate Physical Data Model... Ctrl+Shift+P - For example, to translate the design of your system to your database. This allows you to model the objects in the world they live in and to automate the translation to database tables and columns.

    • Generate Object-Oriented Model... Ctrl+Shift+O - For example, to transform an analytical OOM (designed with the Analysis object language) to implementation OOMs designed for Java, C#, and any other of the object languages supported by PowerDesigner.

    • Generate XML Model... Ctrl+Shift+M - For example, to generate a message format from your class structure.

  2. On the General tab, select a radio button to generate a new or update an existing model, and complete the appropriate options.
  3. [optional] Click the Detail tab and set any appropriate options. We recommend that you select the Check model checkbox to check the model for errors and warnings before generation.
  4. [optional] Click the Target Models tab and specify the target models for any generated shortcuts.
  5. [optional] Click the Selection tab and select or deselect objects to generate.
  6. Click OK to begin generation.
Note: For detailed information about the options available on the various tabs of the Generation window, see Core Features Guide > Linking and Synchronizing Models > Generating Models and Model Objects.