Mapping OOM Objects to other Model Objects

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

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

Reference or table

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)

Generating from Classes

For a class to become a table you need to select the Persistent check box and define a type of generation in the Generation list in the Detail tab of the class property sheet.

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

Generating from Associations

If the association has a many-to-many multiplicity: both roles of the association have the * sign selected in their multiplicity lists, the association is translated into a table in the generated PDM. If it has any other multiplicity, the association becomes a reference.

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


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com