Author Topic: Database schema import: column visibility  (Read 3331 times)

Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +133/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Database schema import: column visibility
« on: September 17, 2020, 09:03:32 pm »
Hello,


EA's database modelling is not implemented as a UML profile with tagged values to represent what can't be expressed using the built-in metamodel, but rather as a hack which reinterprets certain properties of attributes (= columns) and uses operations in a way that I for one am unable to square with the UML.

Since this is the case, and since visibility doesn't apply to relational databases, wouldn't it be a good idea to make use of attribute visibility in imported database models?
Something along the lines of:
  • Public: foreign keys, and columns used in other tables' foreign keys
  • Protected: primary keys
  • Private: everything else
What purpose would this serve?

Well since the data modeling diagram is not a hack but just another diagram type, it has no special features to reflect the fact that its contents are tables. So you can't choose to just display foreign or primary keys, but you can restrict what "class members" are shown based on visibility.

So with this addition, you could use the "visible class members" feature to choose which categories of column to display: those relevant in the context of other tables (foreign keys and their targets), primary keys, and/or regular data columns.

I think this is a brilliant idea, and not hard to implement either.


/Uffe
My theories are always correct, just apply them to the right reality.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 11731
  • Karma: +454/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Database schema import: column visibility
« Reply #1 on: September 17, 2020, 09:12:42 pm »
Seems like a good idea.

And for those who can't wait until Sparx implements this, you can write a little script to set the visibility yourself. (which Uffe probably already did)

Geert

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8136
  • Karma: +228/-128
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: Database schema import: column visibility
« Reply #2 on: September 18, 2020, 07:51:36 am »
Seems like a good idea.

And for those who can't wait until Sparx implements this, you can write a little script to set the visibility yourself. (which Uffe probably already did)

Geert
+1

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1146
  • Karma: +35/-2
    • View Profile
    • www.umlchannel.com
Re: Database schema import: column visibility
« Reply #3 on: September 25, 2020, 05:23:55 pm »
+1
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Uffe

  • EA Practitioner
  • ***
  • Posts: 1859
  • Karma: +133/-14
  • Flutes: 1; Clarinets: 1; Saxes: 5 and counting
    • View Profile
Re: Database schema import: column visibility
« Reply #4 on: September 30, 2020, 04:43:40 pm »
Reported.

/Uffe
My theories are always correct, just apply them to the right reality.