6th October 2019

utah
10

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.

Regarding 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.

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.
Write Your Answer

Rate

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

3 / 5 based on 2 votes.

Bookmark

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

Share