Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
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
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		search this (google, ....)
a-dimensional-modeling-manifesto
site is kimballgroup
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 its_anandrjs
		
			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
 
					
				
		
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
		
			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
