Re: [SysML Forum] UML/SysML in rdbms

[Loïc Fejoz]

Hello,

Just a quick answer : rdbms might not be the best technical solution...
Indeed models are more like graph so :
http://en.wikipedia.org/wiki/Graph_database

And I agree with your last question in that it would ease usage.

--
regards,
Lo�c

Le 07/04/2013 16:27, Dieter Van Eessen a �crit :
> Hello,
>
> I've read some texts about whether to choose to store data in xml vs rdbms.
> Flexibility seems to be nearly the only reason to do so: (eg, quote from
> stack overflow)
>
> "The only reason, IMHO, to put XML in a database is if you need to
> interact, edit, or change the data with your project. If you are simply
> reading and using the XML Data, just throw it in a file."
>
> Now I'm wondering: has an attempt be made to store uml/sysml models
> inside a rdbms? Would this increase possibilities for collaborative
> work? Topcased mentions in it's documentation that models are split into
> submodels which have to be locked/unlocked to enable writing.
>
> Could storing the model in an sql database improve possibilities for
> online view+documentation+collaboration? It might allow a more dynamic
> locking/unlocking of model elements on lower level and certain
> concepts/models could be made public/open source allowing subscribed
> users to annotate and subscribed developers to update the model.... Or
> is this all just a foolish idea?
>
> kind regards,
> Dieter Van Eessen

[Matthew Hause]

It is not a dumb idea. Our product Atego Artisan Studio is built on a database for exactly the reasons that you mention. Otherwise working in groups becomes quite difficult.

 

From: sysml...@googlegroups.com [mailto:sysml...@googlegroups.com] On Behalf Of Dieter Van Eessen
Sent: Sunday, April 07, 2013 11:27 AM
To: sysml...@googlegroups.com
Subject: [SysML Forum] UML/SysML in rdbms

 

Hello,

I've read some texts about whether to choose to store data in xml vs rdbms.
Flexibility seems to be nearly the only reason to do so: (eg, quote from stack overflow)

"The only reason, IMHO, to put XML in a database is if you need to interact, edit, or change the data with your project. If you are simply reading and using the XML Data, just throw it in a file."

Now I'm wondering: has an attempt be made to store uml/sysml models inside a rdbms? Would this increase possibilities for collaborative work? Topcased mentions in it's documentation that models are split into submodels which have to be locked/unlocked to enable writing.

Could storing the model in an sql database improve possibilities for online view+documentation+collaboration? It might allow a more dynamic locking/unlocking of model elements on lower level and certain concepts/models could be made public/open source allowing subscribed users to annotate and subscribed developers to update the model.... Or is this all just a foolish idea?

kind regards,
Dieter Van Eessen

Privacy

--
--
You received this message because you are subscribed to the Google
Groups "SysML Forum" group.
Public website: http://www.SysMLforum.com
To post to this group, send email to sysml...@googlegroups.com
To unsubscribe from this group, send email to
sysmlforum+...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sysmlforum?hl=en_US?hl=en
 
---
You received this message because you are subscribed to the Google Groups "SysML Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sysmlforum+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Dieter VE]

Hello,

Do you know of any open source tools which use rdbm to store their models?
Is xml considered as a required intermediate format?

I've read a paper on xml to rdb mapping, but haven't found any literature on direct interaction with rdb's.
Most google searches return on how data-modeling can be done with uml...

I'm currently also checking out uml forum(s), if you may have a direction to point me in, I'd be grateful. 

kind regards,

Dieter

---

Date: Sun, 7 Apr 2013 14:00:33 -0700
From: stephan....@googlemail.com
To: sysml...@googlegroups.com
Subject: [SysML Forum] Re: UML/SysML in rdbms

Hi Dieter,

many UML/SysML tools store their model data in a relational database, but they did not do that by simply inserting XML snippets into the DB. The solutions that I know have an appropriate data model with clean semantics.

A central database where the model is accessible for all stakeholders supports collaborative work considerably.

Regards,

Stephan Roth

Am Sonntag, 7. April 2013 16:27:29 UTC+2 schrieb Dieter Van Eessen:

Hello,

I've read some texts about whether to choose to store data in xml vs rdbms.
Flexibility seems to be nearly the only reason to do so: (eg, quote from stack overflow)

"The only reason, IMHO, to put XML in a database is if you need to interact, edit, or change the data with your project. If you are simply reading and using the XML Data, just throw it in a file."

Now I'm wondering: has an attempt be made to store uml/sysml models inside a rdbms? Would this increase possibilities for collaborative work? Topcased mentions in it's documentation that models are split into submodels which have to be locked/unlocked to enable writing.

Could storing the model in an sql database improve possibilities for online view+documentation+collaboration? It might allow a more dynamic locking/unlocking of model elements on lower level and certain concepts/models could be made public/open source allowing subscribed users to annotate and subscribed developers to update the model.... Or is this all just a foolish idea?

kind regards,
Dieter Van Eessen

Privacy

[Nacho]

Maybe using svn or git to store models will be enough :)

[Klaas Gadeyne]

Hi Dieter,

> Do you know of any open source tools which use rdbm to store their models?

Christian Damus is currently porting the papyrus editors to support CDO <http://www.eclipse.org/cdo/>
Have a look at his blog <http://give-a-damus.blogspot.be>. AFAIK, the latest kepler developer and nightly builds (M6 or later) have support for CDO.

regards,

Klaas

[Dieter VE]

Wow!! Finally found time to completely watch the webinar on CDO: Scale, Share and Store your Models with CDO 2.0... Blows my mind! (Dated: January 2009!! Two years ago and only heard of it now :(, again I realize I'm far behind.).

Thanks!

Is there any knowledge on companies/workgroups setting certain modellibraries available for public use?

kind regards,
Dieter