Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: bholtzman on July 27, 2019, 05:14:07 am
-
Can someone tell me the table(s) in which relationship matrix data is stored? Thanks very much.
Bill
-
t_trxtypes. See p. 36 of my Inside book.
q.
-
Thanks Tom. I looked at t_trxtypes and I saw my profiles, but I still don't see where the individual relationships between objects are stored. I noticed that in your book the table t_objecttrx has a description of ??
I did a search of all columns in the database with *TRX* but came up empty. I figured there'd be a table with columns of object_id1, object_id2, trx_id but I didn't see any. Nor, when I selected several relationships for a specific object did I find any tables with that object_id other than what I would expect. It's a puzzle.
Bill
-
Hmm. Give me a weekend and I'll look into that once again. Will be in a training camp over the next days.
q.
-
Much obliged!
-
t_trxtypes. See p. 36 of my Inside book.
q.
By coincidence I just bought the "Inside Enterprise Architect" book, after spending a couple of hours looking at Sparx documentation and googling around. My goal was to generate model reports in Excel that would require wayyyy too much tweaking of the report generator. I would recommend it! Saved me many hours of hacking around and swearing at my computer monitor.
Well written book, just a stream of useful information I can use right here and now, and great value. Thanks Mr. QWERTY!
-
Relations are stored in the table t_connector
The relationship matrix is just a view on existing relations stored there.
Geert
-
I once looked it up again and the profile is stored in t_trxtypes. Maybe you're just, as Geert said, after the relations. If you manually enter search criteria they will be an on-line view on the relations stored in t_connector. Only the profiles (Options/Profiles/Save) are stored in t_trxtypes.
q.
P.S. @Richard: Thanks a lot :-)
-
Relations are stored in the table t_connector
The relationship matrix is just a view on existing relations stored there.
Geert
Thanks Geert. What in t_connector distinguishes a relationship matrix association from an association drawn within a diagram? How is the association between a row in t_connector made with a row in t_trxtypes?
Bill
-
t_trxtypes. See p. 36 of my Inside book.
q.
By coincidence I just bought the "Inside Enterprise Architect" book, after spending a couple of hours looking at Sparx documentation and googling around. My goal was to generate model reports in Excel that would require wayyyy too much tweaking of the report generator. I would recommend it! Saved me many hours of hacking around and swearing at my computer monitor.
Well written book, just a stream of useful information I can use right here and now, and great value. Thanks Mr. QWERTY!
Richard, I second that 100%!
Bill
-
Relations are stored in the table t_connector
The relationship matrix is just a view on existing relations stored there.
Geert
Thanks Geert. What in t_connector distinguishes a relationship matrix association from an association drawn within a diagram? How is the association between a row in t_connector made with a row in t_trxtypes?
Bill
Nothing, diagrams and relationship matrix are just two different views on the same data.
Geert
-
Yes. The difference is the way you see the connectors. In diagram you can hide individual connectors (for various reasons). The RM (AFAIK) always shows all relations between the cross referenced elements. The profile itself defines the parameters for the view (so which connector shall be cross referenced).
q.
-
Thanks, all. Sorry for the delayed response as I was on a 2 week holiday!
Bill
-
You know the biggest hassle of using the Relationship Matrix? Reading the top header - the text is aligned vertically! I wind up tilting my head or taking a screen shot and rotating it...not sure of a better way, maybe some kind of cursor hover feature?
Bill
-
I've seen such matrices with a 45 degrees heading.
q.
-
Another issue with the relationship matrix - using a MySQL database on an Amazon WS server, and using different recent versions of EA, when I right-click to add a relationship I never get the "Create new relationship" option, just a small empty pop-up. Once again, use of MS Access is the workaround!
Bill
-
You know the biggest hassle of using the Relationship Matrix? Reading the top header - the text is aligned vertically! I wind up tilting my head or taking a screen shot and rotating it...not sure of a better way, maybe some kind of cursor hover feature?
Bill
bholtzman
No more tilting head or rotating screen ;D if you had PCS and prolaborate configured .
Can view the existing matrixes or create new in Enterprise Architect using prolaborate.
(https://i.ibb.co/hXJM2td/RM-understand.png)
Formore details refer https://prolaborate.sparxsystems.com/resources/documentation/enterprise-architect-relationship-matrix
BR