Author Topic: Report Diagram/model changes when SQL schema updates  (Read 1578 times)

Miso2018

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Report Diagram/model changes when SQL schema updates
« on: February 09, 2018, 11:57:29 am »
I have been requested to model relationship between User Interface (screens, fields) and SQL DB Schema, and to be able to show which elements are affected when the SQL schema is updated.
Is there a way to report (or highlight it in the diagram) the UI elements with changed/affected relationships?   

Helmut Ortmann

  • EA User
  • **
  • Posts: 924
  • Karma: +39/-1
    • View Profile
Re: Report Diagram/model changes when SQL schema updates
« Reply #1 on: February 12, 2018, 08:56:26 pm »
Hello,

If I have understood you right, you want to model and visualize the relationship between a UI element and the database model modelled in EA.

In my opinion, the best way to visualise such relationships are:
- Matrix  (Relationship Matrix in EA with or without overlay, something like a CRUD Matrix)
- ModelViews (SQL results visualized as a table)

To edit or visualise particular parts you can use Diagrams which contains:
- Tables, Columns or so
- UI Elements or so
- Dependencies to connect UI Elements with Columns or so

With EA Matrixes you can also edit relationships between SQL schema and UI.

The relationships you can easily see in the diagram and you can highlight them with EA Filtering.

I would recommend a stereotyped dependency to model the relationships. To define such stereotypes, I would use a UML profile, distributed by an MDG.

Regarding Diagrams:
Diagrams are a view of something you like to show someone else. It's up to the modeller or to standards to define diagrams and their meaning.

Best regards,

Helmut

Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)

Sunshine

  • EA User
  • **
  • Posts: 685
  • Karma: +46/-3
  • Emoji's make you look younger
    • View Profile
Re: Report Diagram/model changes when SQL schema updates
« Reply #2 on: February 14, 2018, 08:14:19 pm »
Just a thought you could look into baseline then comparing updated model with baseline.
I think there is  some function to compare current diagram with baseline too via the diagram context menu. Not tried it myself but worth having a look at that.
Let us know if that works for you.

Miso2018

  • EA Novice
  • *
  • Posts: 18
  • Karma: +0/-0
    • View Profile
Re: Report Diagram/model changes when SQL schema updates
« Reply #3 on: February 15, 2018, 07:55:59 am »
Hi Helmut,

thank you for your suggestion regarding the Relationship Matrix and a Diagram as "a window" into the EA DBase, however I am still not sure how to show the impact on UI elements when the SQL schema change.  I thought to create a baseline and add a new version to compare/show differences, but still don't know how to find affected relationships.   

Helmut Ortmann

  • EA User
  • **
  • Posts: 924
  • Karma: +39/-1
    • View Profile
Re: Report Diagram/model changes when SQL schema updates
« Reply #4 on: February 15, 2018, 06:16:02 pm »
Hi,

well, I don't know your Use Case of:
- updating your metamodel
- modelling the dependency between metamodel and UI

So I assume:
-  You update your metamodel at some time
-  You mark deleted and/or modified metamodel items somehow (name, tagged value,..)
-- Modified elements you may find via modified date.
-  You have modelled the dependencies between metamodel and your UI by means of dependency or so

With that you can write an SQL query:
- Find all metamodel items that are modified in your last metamodel update
- Find all UI Elements with a connector of type <<dependency>> to the found changed metamodel items
- Find all UI Elements with a connector of type <<dependency>>which are linked to deleted metamodel items

If you have modelled:
- Metamodel
- UI dependency to metamodel
- The change you have done to the metamodel (new, modified, delete)

finding the impact is an SQL and using EA <<ModelViews>>.

If your issue is finding changes to the changed metamodel (update, new, delete) you have to think about other solutions.

Best regards,

Helmut



Coaching, Training, Workshop (Addins: hoTools, Search&Replace, LineStyle)