Author Topic: Data model synchronisation  (Read 4556 times)

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Data model synchronisation
« on: January 03, 2008, 12:11:14 am »
Hi
As you can see here: http://www.sparxsystems.com/cgi-bin/yabb/YaBB.pl?board=general;action=display;num=1199260159 , the data model is not synchronised, just exiting tables.
I sugest the when reverse engineering a DB with synchronisation chosen, it should also bring new tables (setialy becuse it lets you choose them!!!!!!!!).
« Last Edit: January 06, 2008, 06:53:21 am by MartinT »
Recursion definition:
If you don’t understand the definition read "Recursion definition".

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Data model synchronisation
« Reply #1 on: January 03, 2008, 05:55:50 am »
Hi Martin,

I hear you! And you're not alone.

But...

We've been waiting for this for quite some time. Still no luck.

I say "waiting" since this sort of thing has been requested many times. And Sparx has told us they are working on it - or at least they are moving towards this goal. Still, as each new minor release comes out we have not seen it. And EA 6 and 7 have appeared, but still we wait.

Granted, there's a lot involved in handling this stuff. Incremental database changes can be quite complex, not to mention all the issues with existing data. Still, it has now been years, and we continue to wait.

In Sparx' defense, I think that some of the issues are related to limitations in the data modeling profile. This profile did not originate with Sparx, and the limits were inherent when they (Sparx) took it up. It was one of the better tools of its kind at the time, and had been published widely, though it had little fanfare. But we've (Sparx and the EA community) have been frustrated by its limits for some time now. Sparx has done legion duty in pushing the envelope here, but there's only so much they can do.

Sparx has earlier stated that they were waiting on an upcoming OMG-backed successor to the current profile. Such a profile was talked about some time ago, and did make it to the RFP stage a while back. However, it has undergone quite a transformation, and has been dormant for the past year or so. This doesn't mean it's a dead issue, but I hope we'll see some movement on this front. If not, hopefully Sparx will consider development of a more robust data management metamodel, and a new profile based on that.

We live in hope...

David
No, you can't have it!

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Data model synchronisation
« Reply #2 on: January 03, 2008, 07:31:29 am »
Good to know.
Any way it is puzling for the user that you can choose a table in the list infrton of your eyes - and still not see it the data model after synch.
Recursion definition:
If you don’t understand the definition read "Recursion definition".

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Data model synchronisation
« Reply #3 on: January 03, 2008, 07:46:36 am »
[Without proof] I think this is a side effect of both the data modeling profile itself, and how the profile was implemented by Sparx.

The profile reused class models, and dates back to fairly early UML 1.x times. Sparx built their implementation on top of their existing class model engine, reusing a lot of the work they had already done for code generation.

This evolution has left us with a lot of baggage. In your case I suspect you see the option because the reverse engineering engine - the same core used for code engineering - provides you with the ability to choose. Since the data modeling engine does not provide this functionality (yet) any choice you make gets ignored. [Perhaps it isn't really ignored, just filed away in some mystical way until the function becomes available in a "future version." (The quotes are from Sparx' answers over the years.)]

David
No, you can't have it!

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: Data model synchronisation
« Reply #4 on: January 06, 2008, 06:52:58 am »
After checking with Sparx is seems I was toofast on the trigger. It all seems to work fine. the problem (which I yet to figure out) is problably with the spsific DB\table I was working on.
Recursion definition:
If you don’t understand the definition read "Recursion definition".