Star Schema in Data Warehouse

Posted on | February 2, 2010 | No Comments

Star schema contain a single or mutiple fact table surrounded by dimension table.The dimension table in star schema will be denormalized.Most of the datawarehouse are designed according to star schema.Accordingly star schema as following features

1. Single(Simple Star Schema) or multiple(Complex Star Schema) fact table
2. There are fewer number of dimension table hence lesser joines and queries execute faster
3. Considered a special case of snowflake schema.
4. Dimensional tables are generally in 2nd normal form while fact table are in third normal form

Please leave your comment and feedback in below form to improve the site

Comments

Recent Posts

• Star Schema in Data Warehouse
• grep command in unix with example
• File Compression and archival in UNIX
• Snowflake Schema in data warehouse
• ETL tools in data warehousing?

Archives

• February 2010
• January 2010
• December 2009

Categories

• Basic Concepts in Data Warehousing
• UNIX in Data Warehousing