🟣 Terminology: Star Schema
A data warehouse design pattern: - Central fact table = events/transactions (order_id, customer_id, product_id, date_id, amount) - Surrounding dimension tables = descriptive context (customers, products, dates, stores)
Why it works for analytics: Queries join the fact table to whichever dimensions they need. Simple, predictable, fast.
[dim_customer]
|
[dim_date] — [fact_sales] — [dim_product]
|
[dim_store]