6th October 2019


Why do we need star schema?

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.

Beside this, what is schema in DWH?

Schemas in Data Warehouses. A schema is a collection of database objects, including tables, views, indexes, and synonyms. There is a variety of ways of arranging schema objects in the schema models designed for data warehousing. One data warehouse schema model is a star schema.

What is star schema with example?

A diagram of a star schema resembles a star, with a fact table at the center. The following figure is a sample star schema. A fact table usually contains numeric measurements, and is the only type of table with multiple joins to other tables.
Write Your Answer


80% people found this answer useful, click to cast your vote.

4 / 5 based on 3 votes.


Press Ctrl + D to add this site to your favorites!