✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


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

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

Comment for "Star Schema in Data warehouse"


Post a Comment

Blog Archive