What is a star schema?

What is meant by star schema?

A star schema is a database organizational structure optimized for use in a data warehouse or business intelligence that uses a single large fact table to store transactional or measured data, and one or more smaller dimensional tables that store attributes about the data.

What is star schema give one example?

The star schema separates business process data into facts, which hold the measurable, quantitative data about a business, and dimensions which are descriptive attributes related to fact data. Examples of fact data include sales price, sale quantity, and time, distance, speed and weight measurements.

What is difference between star and snowflake schema?

A star schema contains both dimension tables and fact tables in it. A snowflake schema contains all three- dimension tables, fact tables, and sub-dimension tables. It is a top-down model type.

Why do we use star schema?

One of the most popular ways to organize a reporting schema is with a star schema. Star schemas are organized into fact and dimension tables. Looking at the pharmaceutical sales example, facts are measurable data about the event. In this case the sale, e.g. quantity and price.