📄️ Star schema
A star schema links a central fact table of events to descriptive dimension tables, enabling efficient storage and analytics in data warehouses.
📄️ Dimensions
Dimensions in a star schema provide the descriptive context, such as date, product, customer, and location, that surrounds fact-table events.
📄️ Facts
Fact tables in a star schema store the observations and events, such as sales orders, inventory, and general ledger transactions, that you analyze.
📄️ Keys
Keys link fact tables to dimensions in a star schema and ensure relationships are built on integer columns for efficient joins.
📄️ Considerations
Modeling guidance for star schemas: keep models simple, avoid snowflakes, multiple date dimensions, bi-directional relationships, and non-type-1 SCDs.