In computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. … The star schema is an important special case of the snowflake schema, and is more effective for handling simpler queries.

What is star schema and snowflake schema in data warehouse?

Star schema is the type of multidimensional model which is used for data warehouse. … This schema forms a star with fact table and dimension tables. Snowflake Schema: Snowflake Schema is also the type of multidimensional model which is used for data warehouse.

What are the three main components of star schema?

The basic star schema has four components: facts, dimensions, attributes, and attribute hierarchies.