Book a Demo

Author Topic: Star Schema / Dimensional Database  (Read 4339 times)

lfgcasey

  • EA User
  • **
  • Posts: 33
  • Karma: +0/-0
    • View Profile
Star Schema / Dimensional Database
« on: June 08, 2018, 09:49:44 pm »
I see this in the Q&A section of several Database Engineering Webinars:

Q: Does Enterprise Architect support dimensional models?
A: No. Enterprise Architect supports physical data modeling for relational and geospatial databases.

Is this still true? If so, how would one go about modeling a data mart implemented using a star schema?

Richard Freggi

  • EA User
  • **
  • Posts: 498
  • Karma: +18/-7
    • View Profile
Re: Star Schema / Dimensional Database
« Reply #1 on: June 08, 2018, 10:42:41 pm »
*Drops monocle*
I thought star schema is just a style of schema implementable in any relational database?  Should be OK unless you need to forward engineer to a RDBMS that EA does not have DDL generation for

SamSepi0l

  • EA Novice
  • *
  • Posts: 10
  • Karma: +0/-0
    • View Profile
Re: Star Schema / Dimensional Database
« Reply #2 on: June 08, 2018, 11:23:47 pm »
Richard, you are right.

Although star schema is a methodology and can be implemented in any relational database, I've seen in other data modeling tools that you can define your data model as a dimensional model, this allows you to identify the tables as fact or dimension and also allows you to maintain the data lineage.

I believe that's why in the answer posted by lfgcasey says "Enterprise Architect supports physical data modeling for relational...", but at the end I see that EA does not support dimensional models.