✍ Kashif M
Trends

Sunday, 15 September 2013


Star Schema in Data warehouse


By on September 15, 2013


Star Schema  


It is simplest schema in data warehouse

It will have centralized one or more face table surrounded by its dimensionals table

In Star Schema tables will be arranged in such a manner, so that we can retrive data easily from the data warehouse.

Why it name as star schema - The schema will resemble like star

In Star schema fact table will be in center and it will link with many of its dimensional tables.

The center of the star schema are one or many fact tables and the points of star is towards its dimensional table, see below example for your better understanding.

Star Schema
Star Schema



Kashif
mkashu: Star Schema in Data warehouse
Review : Kashif | Kashif
Update: September 15, 2013 | Rating: 4.5

Comment for "Star Schema in Data warehouse"

0 comments

Post a Comment

Blog Archive