How ER Modelling is different from Star Schema?

[Anonymous]

Hello Guys, I have understanding of ER Modelliing but not able to differentiate with Star Schema. Could you guys explain how ER modelling is differ from Star Schema?

Warm Regards,

Raj

[maxgro]

search this (google, ....)

a-dimensional-modeling-manifesto

site is kimballgroup

[maxgro]

A Dimensional Modeling Manifesto - Kimball Group

[its_anandrjs]

Hi,

ER modelling is basically entity relation ship modelling in this practice we check tables relation ship between different tables and make a data model. Star schema is a good data model for BI reporting but also you learn about dimensional modelling also.

HTH

Thanks & Regards

Anand

[Anonymous]

Anand,

I understand ER modelling. As per your reply both are Data Model. Then why we don't use ER Modelling in BI Reporting instead of Star Schema.

Same concepts are into ER Modelling like entities are tables itself similiar to Dimension Table then why we use Star Schema instead of ER Modelling?

Is it because of RDBMS or Non-RDBMS concept?

Regards,

Balraj

[its_anandrjs]

Hi,

Yes you are right it is due to RDBMS concept where the table follows the relation ship that is the reason. But star schema is created with talking different tables and need to find the keys and relations among the table.

HTH

Thanks & Regards