Star schema basics

Star Schema Basics,

It is the simplest form of database structure that we use in data warehouse. Star schema answer the basic question, what happened, who did it, how did they do it … etc.

A star schema focuses on one single business area.

A star schema is consisted of fact table with dimension tables connected to the fact table. There is always one fact table in the star schema with multiple dimension tables connected to it, called data mart. We will discuss all these things a bit latter.

Advantages star schema offers;

Separate data into two main categories,

Fact and Dimension

Fact Table: fact table is the measurement of what happened. Like product sold, costumer who bought etc. anything that is numeric and we measure

Dimension table: attributes that describe what happened. Like who sold the product, date of the selling, where the product was sold, who bought it etc.

Fig showing Star schema;