topic How ER Modelling is different from Star Schema? in QlikView

How ER Modelling is different from Star Schema?

Anonymous — Sun, 02 Mar 2014 03:10:36 GMT

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

Re: How ER Modelling is different from Star Schema?

maxgro — Sun, 02 Mar 2014 08:04:10 GMT

search this (google, ....)

a-dimensional-modeling-manifesto

site is kimballgroup

Re: How ER Modelling is different from Star Schema?

maxgro — Sun, 02 Mar 2014 08:04:36 GMT

A Dimensional Modeling Manifesto - Kimball Group

Re: How ER Modelling is different from Star Schema?

its_anandrjs — Sun, 02 Mar 2014 08:24:44 GMT

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

Re: How ER Modelling is different from Star Schema?

Anonymous — Sun, 02 Mar 2014 11:01:13 GMT

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

Re: How ER Modelling is different from Star Schema?

its_anandrjs — Sun, 02 Mar 2014 11:33:15 GMT

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