Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forward engineering options for type hierarchies

beatrizApr 6 2011 — edited Apr 8 2011
Hello,

I'm using Data Modeler 3.0.0-665.

I have models which use type hierarchies with more than 2 levels. I'm having dificulty forward engineering into tables.

For example I have the following entity hierarchy:
ent1
ent21
ent211
ent212
ent22
ent221
ent222
I would like to enginer tables as follows:
- ent21 and its sub-types implemented as single table
- ent22 and its sub-types implemented as sub-type implementation (table per child)

What seems to happen in Data Modeler is that the Forward Engineer Strategy property is set once only for the entire hierarchy. So I cannot engineer two sub-types with different engineering strategies.
I also was unable to engineer only children of ent21 even though I had de-selected the children of ent22.

Is there a way to make Data Modeler implement sub-types using different strategies within the hierarchy?

Thank you,
Beatriz.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 6 2011
Added on Apr 6 2011
3 comments
229 views