What is Star Schema?
A data warehouse design pattern with a central fact table connected to dimension tables, resembling a star shape.
Why It Matters
Star schemas make analytical queries simpler and faster by organising data around measurable facts.
Real-World Example
A sales fact table at the centre, connected to dimension tables for date, product, customer, and store.
“Understanding terms like Star Schema matters because it helps you have better conversations with developers and make smarter decisions about your software. You do not need to be technical. You just need to know enough to ask the right questions.”
Related Terms
Snowflake Schema
A variation of the star schema where dimension tables are further normalised into sub-dimensions.
Data Warehouse
A large database optimised for storing and analysing historical data from multiple sources.
Data Modelling
The process of designing how data will be structured, stored, and related in a database.
OLAP (Online Analytical Processing)
Database systems optimised for complex analytical queries across large volumes of historical data.
Learn More at buildDay Melbourne
Want to understand these concepts hands-on? Join our one-day workshop and build a real web application from scratch.
Related Terms
Data Warehouse
A large database optimised for storing and analysing historical data from multiple sources.
OLAP (Online Analytical Processing)
Database systems optimised for complex analytical queries across large volumes of historical data.
Data Modelling
The process of designing how data will be structured, stored, and related in a database.
Snowflake Schema
A variation of the star schema where dimension tables are further normalised into sub-dimensions.
Database
An organised collection of data that your application can store, retrieve, and update
SQL
A language for communicating with databases, used to create, read, update, and delete data