Author Topic: e-book about EA's database structure available  (Read 25354 times)

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #15 on: May 31, 2012, 01:00:07 am »
Thanks for the feedback! I'll include that in the next release of the book.

q.

[edit]: I have added the information and will publish a new release latest tomorrow. As a note: the CLASSGUID/TYPE do not appear as "real" columns as EA interprets them as double-click-link and for the icon left.

[edit]: Just published with following changes
- added chapter about t_taggedvalue (which is used for WSDL)
- detailed use of CLASSGUID/TYPE
- hint about tagged value contents
- some (reference) typos corrected

Thanks to Tanja and albert for the feedback
« Last Edit: May 31, 2012, 07:13:57 am by qwerty »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #16 on: June 21, 2012, 09:29:03 am »
I have just published a new release with these changes:

- revised the section about t_taggedvalue
- added descriptions for t_document, t_image and t_objectscenarios.

q.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #17 on: July 06, 2012, 10:38:03 pm »
Just added a description for t_script

A plea: if you have any additional information which is not yet in the book I'm happy to add this so all readers can profit!

If you're missing any details (e.g. the ?! placeholders) or not yet described tables, please let me know. Either by posting here, using my mail address printed in the book or the landing page of the book. I'd start investigating them.

q.

supplyondemand

  • EA Novice
  • *
  • Posts: 16
  • Karma: +0/-0
    • View Profile
Re: e-book about EA's database structure available
« Reply #18 on: July 09, 2012, 07:52:50 pm »
As far as I know there are three EA-books for sale right now:

Inside Enterprise Architect
Scripting Enterprise Architect
Fifty Enterprise Architect Tricks

Will these be offered as a bundle sometime?

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #19 on: July 09, 2012, 08:31:09 pm »
We can build that bundle. As we are two different authors I have to contact Peter but in general it's no issue. Unless he's on holiday it will only take a day or so. I'll post here as soon as the bundle is available.

q.

P.S. I've reached Peter. You can find the bundle here: http:// http://leanpub.com/b/EntArchBundleComplete
« Last Edit: July 09, 2012, 11:53:21 pm by qwerty »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #20 on: July 19, 2012, 10:38:01 pm »
Just publish a new revision:

- additional info for connector StylEex
- started adding API references

q.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #21 on: October 27, 2012, 09:16:35 pm »
After a longer pause due to sickness I just published a new version:

Added description of tables
- t_genopt
- t_trxtypes

q.

kepNCI

  • EA User
  • **
  • Posts: 127
  • Karma: +1/-0
    • View Profile
Re: e-book about EA's database structure available
« Reply #22 on: October 31, 2012, 07:59:03 am »
Just some observations:

t_lists
Appears to be a table set up to create various control lists, but looks like it is only being used for Settings/Project Type/General Types/Constraint Status Types.

t_objectproblems
Records Changes, Defects, Issues or Tasks related to element. Managed via View/More Element Tools/Maintenance

t_objectresource
Allocates time for specific resource on this element.  (see View/More Element Tools/Project Management).

t_objecttests
Tests defined for element via View/More Element Tools/Testing

Cannot find source in database for values maintained by:
Settings/Project Type/General Types/Difficulty
Settings/Project Type/General Types/Priority
Settings/Project Type/General Types/Test Status
Settings/Project Type/Estimation Factors/Default Hour Rate

BTW.  As suggested, I did create a data model of EA database via re-engineering and added notes to many of the table based upon observation of the type of data contained in the tables as well as added the apparent relationships of the tables that would be most used in queries. Helps quite a bit.

Karl

g.makulik

  • EA User
  • **
  • Posts: 355
  • Karma: +0/-0
    • View Profile
Re: e-book about EA's database structure available
« Reply #23 on: October 31, 2012, 08:18:10 am »
Quote
BTW.  As suggested, I did create a data model of EA database via re-engineering and added notes to many of the table based upon observation of the type of data contained in the tables as well as added the apparent relationships of the tables that would be most used in queries. Helps quite a bit.

Are you publishing this somewhere??

Regards,
Günther
Using EA9.3, UML2.3, C++, linux, my brain, http://makulik.github.com/sttcl/

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #24 on: October 31, 2012, 08:49:29 pm »
Karl,

Many thanks for these observations. I'll go ahead and add it to the book.

Thanks and cheers,

q.

P.S. Just realized that many menus have changed. E.g. the maintenance you mention above is under Element/Maintenance from V10 on. Wonder how to deal with that so V9 and V10 user will find the correct menu entry.   :-/
« Last Edit: October 31, 2012, 09:42:17 pm by qwerty »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #25 on: October 31, 2012, 09:50:41 pm »
Quote
Cannot find source in database for values maintained by:
Settings/Project Type/General Types/Difficulty
Settings/Project Type/General Types/Priority
Settings/Project Type/General Types/Test Status
Settings/Project Type/Estimation Factors/Default Hour Rate
Just found that t_lists contains Difficulty once you add a new entry with Category DifficultyType. If missing EA obviously assumes these default values. Likely the others will also appear in t_lists. I'll add a detailed description in my book.

q.

Edit: The Default Hour Rate seems to be a registry setting as it is not per model. Just change it in one model and it's also changed in the other model. Likely you`ll find that in the registry.
« Last Edit: October 31, 2012, 10:45:09 pm by qwerty »

kepNCI

  • EA User
  • **
  • Posts: 127
  • Karma: +1/-0
    • View Profile
Re: e-book about EA's database structure available
« Reply #26 on: November 01, 2012, 12:58:14 am »
Qwerty:
Is EA 10 compatible with EA 9 database?
Can EA 10 and EA 9 co-exist on the same PC? (Although I would not want to use EA 10 to access an active EA 9 project).
Karl

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #27 on: November 01, 2012, 02:04:53 am »
So far as I have tested there are no issues running both in parallel. I haven't yet compared the structures in detail but I don't expect any issue as the focus was on GUI optimization. I'll let you know the results as soon as I'm done.

q.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13257
  • Karma: +554/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: e-book about EA's database structure available
« Reply #28 on: November 01, 2012, 04:41:03 am »
Although a bit off topic, I've been using the v10 beta version for a while now where my colleagues are still on v9.
I've not yet seen any problems.
I would just avoid using the new enumeration type as that would not be recognized by v9.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: e-book about EA's database structure available
« Reply #29 on: November 02, 2012, 01:14:08 am »
To catch up I have just added sections for t_xrefsystem, t_lists and t_problemtypes. t_trxtypes has some newly discovered information. Thanks to Karl for posting his findings about t_lists and t_problemtypes.

q.