SQL model question [message #119825] |
Tue, 12 July 2005 11:29 ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Igor Jacy Lino Campista![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=icampista%40gmx.de) Messages: 34 Registered: July 2009 |
Member |
|
|
Hi,
I have seen the SQL model of the RDB package in the Rational Rose mdl file
and I have doubts about the containment relations between Database and
Schema, Schema and all others(i.e. Tables, Indexes...).
The current model as of now, when generated using the EMF, and using a
sqlschema resource (for a Schema resource or a Database resouce), it is
not possible to create a child 'Schema' in a Database, and in a Schema we
cannot create a child 'table'(and quite other important SQLObjects). As
this would be sound natural to do.
And because of this, its necessary to have separate resources and refer
them loading the resource. Which of course allows reusing of resources,
but should be merely an option that could be used.
In the SQL mdl model I have made a small change to the containment
relations from "contains a" to "creates a" and now everything works as
before, but now I can create a child 'Schema' in the Database, and as well
a child 'Table' in a Schema. [of course other types of children are
available and this is just the simplest examples].
Could there be an official modification to the mdl model concerning the
containment relations to allow such resource functionality?
Best regards,
Igor Lino
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03927 seconds