Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc)

Help

Home

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » ocl and database(future plans)

Show: Today's Messages :: Show Polls :: Message Navigator

ocl and database(future plans) [message #38061]

Mon, 19 June 2006 22:00

Eclipse User

Originally posted by: saya.txesystems.com

Hi,
As elver is going to be part of emft, I would like to know if there is any
plan on generating SQL code for OCL expression in the model. This would
allow us to enforce the constraints inside the database.

Thanks,
Selcuk

Report message to a moderator

Re: ocl and database(future plans) [message #38162 is a reply to message #38061]

Tue, 20 June 2006 14:51

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

Hi Selcuk,
Maybe the OCL people should also answer this. I have not yet had the
change to really study OCL. From our side this has not more than crossed
our mind at the moment. Also looking at the amount of work we have to do
I am not sure if we will look at this on the short term...

gr. Martin

Selcuk Aya wrote:
> Hi,
> As elver is going to be part of emft, I would like to know if there is
> any plan on generating SQL code for OCL expression in the model. This
> would allow us to enforce the constraints inside the database.
>
> Thanks,
> Selcuk
>

--

With Regards, Martin Taal

Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org

Report message to a moderator

Re: ocl and database(future plans) [message #38228 is a reply to message #38162]

Tue, 20 June 2006 19:19

Eclipse User

Originally posted by: cdamus.ca.ibm.com

Hi,

I suppose that there is a class of constraints that could be transformed to
very simple SQL expressions (JET2 comes to mind ...), and probably there is
a class of OCL constraints that cannot be so easily transformed to SQL.
More to the point, there is much that SQL can do that has no analogue in
OCL.

In any case, the EMFT OCL provides an AST metamodel that should support any
such transformations. There is no plan in EMFT OCL to generate SQL.

Cheers,

Christian

Martin Taal wrote:

> Hi Selcuk,
> Maybe the OCL people should also answer this. I have not yet had the
> change to really study OCL. From our side this has not more than crossed
> our mind at the moment. Also looking at the amount of work we have to do
> I am not sure if we will look at this on the short term...
>
> gr. Martin
>
> Selcuk Aya wrote:
>> Hi,
>> As elver is going to be part of emft, I would like to know if there is
>> any plan on generating SQL code for OCL expression in the model. This
>> would allow us to enforce the constraints inside the database.
>>
>> Thanks,
>> Selcuk
>>
>

Report message to a moderator