Star Schema : It is simplest data warehouse schema. It is called star because it resembles the star with points radiating out of the center. Fact tables is the center of the star and dimensions sit at the points.
Usually the fact table in the star schema is in 3rd normal form and dimensions are usually de-normalized. It is most simplest and most commonly used schema.
If you do not understand the basic concepts of data warehousing, please visit my previous article.
If we consider the data warehousing scenario detailed here, below is how a star schema would look like.
Although, star schema require just one fact table at the center, but you could surely have multiple stars in your design.
Characteristics of star schema
Usually the fact table in the star schema is in 3rd normal form and dimensions are usually de-normalized. It is most simplest and most commonly used schema.
If you do not understand the basic concepts of data warehousing, please visit my previous article.
If we consider the data warehousing scenario detailed here, below is how a star schema would look like.
Although, star schema require just one fact table at the center, but you could surely have multiple stars in your design.
Characteristics of star schema
- Simplest design
- Better query performance.
- A little extra time to load the data into dimension because of de-normalization.
- More space because of redundancy in dimensions.
Thank you so much for providing information about how star schemas are the best design that can be applied to while solving complex IT problems.
ReplyDeletePowerbi Read Rest
IOT analyticshelps iot developers and businesses to collect and analysis data from connected devices, let them see the value of data generated from connected devices and enable them to take timely decisions on the business. iot analytics is the platform that simplifies analytics for iot devices.
ReplyDelete