Author Topic: Linked Conceptual and Physical model  (Read 577 times)

stetou

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
Linked Conceptual and Physical model
« on: September 06, 2023, 12:09:07 am »
I'm new to EA (version 16.0.1605) and starting from scratch.
We are building a Data Warehouse.
I read the doc on the different kind of models but could not find what I need.
I want to be able to have a conceptual and physical views of the warehouse. Do I need to create 2 differents models and maintain both models ?

Is there a way to work in both model and somehow keep them synchronized ?

Richard Freggi

  • EA User
  • **
  • Posts: 473
  • Karma: +18/-7
    • View Profile
Re: Linked Conceptual and Physical model
« Reply #1 on: September 06, 2023, 01:04:02 pm »
You can only do this one way, ie logical model -> physical model with forward engineering.  The procedure is described in the manual.
You can change the logical model and create a new physical model based on it.
You cannot do it the other way ie create a logical model based on physical.  The reason is that one physical model can be represented by many different logical models.
The workaround is to implement your physical model changes in a database then reverse engineer the database to a physical model, hide the datatypes in the ERD diagrams and call it a logical model.  Not perfect but it may help in some cases.

qwerty

  • EA Guru
  • *****
  • Posts: 13433
  • Karma: +390/-299
  • I'm no guru at all
    • View Profile
Re: Linked Conceptual and Physical model
« Reply #2 on: September 06, 2023, 07:27:07 pm »
Look into the example model (from the help menu). That might give you ideas on structing models. Otherwise a consultant or pretty much experience would help.

q.