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

qwerty · « **on:** April 18, 2012, 09:31:33 pm »

I just have published an e-book which explains numerous details of EA's repository structure. Intended readers are not only programmers but also people which want to get out more from EA's advanced search facility. I published a short résumé on the the Sparx Systems Enterprise Architect Community Site under Advanced Searching. The e-book itself and a preview are available at http://leanpub.com/InsideEA. I'd be happy to receive feedback and will amend the book accordingly.

q.

Geert Bellekens · « **Reply #1 on:** April 18, 2012, 10:01:37 pm »

Looks very interesting.
I'll definitely buy it.

Geert

qwerty · « **Reply #2 on:** April 18, 2012, 10:52:52 pm »

Looking forward to your feedback. I'll definitely add everything others have found where I did not dig deep enough. Subscribers will receive a free update. So hopefully this book will become a vade mecum.

q.

g.makulik · « **Reply #3 on:** April 19, 2012, 03:05:22 am »

I'll also buy it. I think it comes quite hamdy for me right now.

Best regards,
Günther

qwerty · « **Reply #4 on:** April 21, 2012, 03:14:47 am »

I have just added a new section detailing the security tables (t_secuser, t_secgroup, etc.). You will find this useful whenever you have to deal with repositories where security is turned on.

q.

g.makulik · « **Reply #5 on:** April 21, 2012, 03:40:13 am »

Oh that's so nice

!!!
Leanpub automatically notices me that there's a new version available for download.
Thanks for your book, it was already helpful so far. I'm willing to contribute any additional information I'll gather in future.

Best regards,
Günther

qwerty · « **Reply #6 on:** April 25, 2012, 06:38:50 pm »

I have just added two sections about SQL quirks and the SQL Search Builder.

Subscribers receive the update for free.

q.

kepNCI · « **Reply #7 on:** April 26, 2012, 02:24:55 am »

Just bought/downloaded your book. Looking forward to reading it.

Karl

qwerty · « **Reply #8 on:** May 01, 2012, 04:38:00 am »

I have just extended the SQL Query Builder section with a couple of example SQL statements provided courtesy of Helmut Ortmann.

q.

qwerty · « **Reply #9 on:** May 14, 2012, 05:14:24 am »

Just updated the e-book with a couple of new sections:
- Added chapters for
-- t_attribute, its tags and GUI
-- t_operation, its tags and GUI
-- t_connectortag
- A nice trick to comment SQL in the search builder (from Helmut Ortmann)

Subscribers receive a free update as always.

q.

Bill McCracken · « **Reply #10 on:** May 20, 2012, 02:33:55 pm »

Just bought and it looks great so far.

Bill McCracken · « **Reply #11 on:** May 20, 2012, 03:36:19 pm »

I would work with EA to resolve the ?! items you have in the book - it makes the book seem incomplete or half baked. I think they are easy answer fill-ins.

Would be even better if you had a logical data model 'map'.

qwerty · « **Reply #12 on:** May 21, 2012, 11:41:21 am »

If you have easy answers just give me a hint. I did not dive deep into some of these ?! tables/columns for various reasons. But I'd be glad to add any further information you have.

Can you elaborate on the logical map?
q.

KP · « **Reply #13 on:** May 21, 2012, 12:16:02 pm »

Quote

Would be even better if you had a logical data model 'map'.

Bill, you can create your own: Project Browser > Right-click > Code Engineering > Import DB Schema from ODBC

albert · « **Reply #14 on:** May 30, 2012, 06:49:23 pm »

I just buy your book, thanks for the job, really valuable.

Just some remarks :

- insideEA.pdf, page 19, 4.4 : t_connectortag in place of t_operationtag
- when using the sample queries in EA Model Search Builder, the columns with 'AS' (like o.ea_guid As CLASSGUID) is not appearing in the report

One trick, I discover based on your e-Book :
- when you are querying in tagged values "value" column, if this column is containing the "<memo>" string, that means that the content of the tag value is in the note column.

Thx

Sparx Systems Forum

News: