Star Schema

A star schema is a way of organizing data in a warehouse: one central fact table (such as events) in the middle, with several dimension tables (user, page, time) around it like the rays of a star.

A star schema exists so that an analytical query over large data stays both fast and comprehensible; the fact table holds additive numbers (an event count, say) and the dimension tables hold the descriptions (which user, which page), so an analyst can slice the fact by any dimension without getting lost in complexity. It is a modeling decision, not a product, and makes sense where data sits in a warehouse and someone must design its structure. For the consumer of an analytics tool, a star schema is usually behind the scenes; it is what lets a report say “break the event down by country and device” without you knowing the structure beneath. Knowing this concept becomes useful when a team wants to go beyond ready reports and model the data itself in a warehouse.