From Class model to Data model?

[Tom Spitzer]

Is there any way to generate a Data Model from a Class Model. We have a set of rules we use for our object relational mapping, so that given an class model, we can generate the supporting data model. However, in EA, I have to manually create the data model. I'm wondering if anybody has a way to take a class model diagram and derive a data model diagram from it.

[Dermot]

Have you looked at using the MDA transforms?

[Tom Spitzer]

I hadn't; I am. That looks very promising.

thanks!

[GeorgeS]

I have the same question: This seems like a use for Automation or MDG, but I haven't yet seen any object-relational mapping capability described anywhere I can find.

The "DDL" MDA transform is a beginning, but the whole mapping of multiple classes to a single table (attributes, class discriminants, etc.) needs to be much more powerful.

[Dermot]

If you are referring to mapping Class.Attr to Table.Field - you might like to look at: http://www.sparxsystems.com/uml_tool_guide/modeling_with_uml/connect_to_element_feature.html  (feature of 844).

[Frank Horn]

If you are referring to mapping Class.Attr to Table.Field - you might like to look at: http://www.sparxsystems.com/uml_tool_guide/modeling_with_uml/connect_to_element_feature.html  (feature of 844).

But how can you evaluate this in an MDA transformation?

[Kevin G. Watson]

Arn't they called out by stereotypes ( Table, Column, Row... immeadiately spring to mind ).

Then ya code-gens out ya favorite Squeelly friendly framework bits and bods...  If ya got some well hairy 'formation rules' then try getting a look at the visual studio Enity Framework Model view of your database ( or the yava equiv ). [smiley=bath.gif]

Kevin [smiley=bath.gif] [smiley=2vrolijk_08.gif]