✍ Kashif M
Trends

Sunday, 7 July 2013


Data Modeling


By on July 07, 2013

A Datawarehouse is based on Fact and Dimension tables. Establishing relationship between various Fact 

table(s) and Dimension tables is called Data Modeling. Fact table contains numeric data that is needed in 

reports e.g. revenue, sales etc Fact table contain information about all dimension table that it is related to. This 

means FACT table has all the Dimension Keys as Foreign Keys.




Data Modeling is of two types:

1. Star Schema Design:

Dimension tables surrounds Fact table. Data is in de-normalized form.

2. Snow Flakes Schema Design:

Dimension tables surrounds Fact table. Data is in normalized form. Dimension table may be further split into a 

sub-dimension table

Kashif
mkashu: Data Modeling
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "Data Modeling"

0 comments

Post a Comment

Blog Archive