Star Schema vs Snowflake Schema vs Fact Constellation Schema

Star Schema


The Star Schema is the simplest data warehouse scheme. When we data warehousing with the star schema, database diagram resembles a star design. That is why this schema called as star schema. One fact table surrounded by dimension tables and if all the dimension tables are parent table then it's star schema data warehouse model. In this schema, Continue reading...