Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » M2M (model-to-model transformation) » [ATL] UML class diagram to ER
[ATL] UML class diagram to ER [message #30424] Mon, 09 April 2007 12:07 Go to next message
beaperez Mising name is currently offline beaperez Mising nameFriend
Messages: 81
Registered: July 2009
Member
Hello,
I have a UML class diagram from which I would like to obtain a SQL schema.
I have thought in obtaining from the class diagram the ER schema and later,
getting the SQL schema. Nevertheless, it is also possible to get directly
the SQL schema from the class diagram.

I don't know waht is the better solution, any idea?

Thanks in advance
Bea
Re: [ATL] UML class diagram to ER [message #30459 is a reply to message #30424] Tue, 10 April 2007 00:10 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: carrasco.ModelDrivenDevelopment.co.uk

Bea,
You may generate an intermediate ER schema,
if you need to perform some human-intelligent manipulations on the ER,
before produccing the DDL. This is usually the case in most teams.

You may indeed transform directly from classes to SQL DDL,
as long as you have completelly designed your transformations from class to
DDL.
You may want to restrict constructs in the UML classes,
to those you can transform properly into DDL.
Inheritance, Many-to-many associations, identity, ...
are some of the classical issues you need to decide upon.

Cheers!
ACV


"Bea" <beaperez@unizar.es> wrote in message
news:evdaap$jlp$1@build.eclipse.org...
> Hello,
> I have a UML class diagram from which I would like to obtain a SQL schema.
> I have thought in obtaining from the class diagram the ER schema and
> later, getting the SQL schema. Nevertheless, it is also possible to get
> directly the SQL schema from the class diagram.
>
> I don't know waht is the better solution, any idea?
>
> Thanks in advance
> Bea
>
Re: [ATL] UML class diagram to ER [message #30493 is a reply to message #30459] Tue, 10 April 2007 07:30 Go to previous messageGo to next message
beaperez Mising name is currently offline beaperez Mising nameFriend
Messages: 81
Registered: July 2009
Member
Hello Antonio,
I have created another ATL transformation to restrict some constructs in a
UML class diagram (association classes, inheritance relationships, etc).
What I want is to obtain the SQL schema from that without generating an
intermediate ER Schema. The thing is that I have only seen that example
(from UML class diagram to DB) as a model-to-model transformation, and I
don't know how I can justify my decision. Any idea?

Thank you in advance.
Bea



"Antonio Carrasco" <carrasco@ModelDrivenDevelopment.co.uk> escribi
Re: [ATL] UML class diagram to ER [message #30669 is a reply to message #30493] Wed, 11 April 2007 00:58 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: carrasco.ModelDrivenDevelopment.co.uk

Hi Bea,
Well, with MDA, we may produce models from models,
and then again, until all our stakeholder
Re: [ATL] UML class diagram to ER [message #30704 is a reply to message #30669] Wed, 11 April 2007 16:01 Go to previous message
beaperez Mising name is currently offline beaperez Mising nameFriend
Messages: 81
Registered: July 2009
Member
Thanks Antonio, you have been a great help. It is enough for me.


"Antonio Carrasco" <carrasco@ModelDrivenDevelopment.co.uk> escribi
Previous Topic:Re: [ATL] adding operation
Next Topic:[ATL] 'null' values not explicitly set?
Goto Forum:
  


Current Time: Tue May 14 21:00:33 GMT 2024

Powered by FUDForum. Page generated in 0.04196 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top