Overview
The Star Schema is a mature modeling technique used to build data warehouses. It consists of one or more fact tables referencing any number of dimension tables.
Structure
- Fact Table: Central table containing quantitative data.
- Dimension Tables: Surrounding tables containing descriptive attributes.
Benefits
- Simple queries
- Fast performance
- Easy for BI tools to understand