Data engineering·Modelling for analysis
every dimension is one join away from the fact, so no query needs more than a single hop to get a label.
Star schema
Also calledstar
A central fact table surrounded by fully denormalised dimensions, each reachable in one join. It is the default shape for analytical modelling because it is predictable to write, cheap to plan and easy for a BI tool to reason about. The redundancy inside the dimensions is the deliberate trade — you accept repeated country names in exchange for never chaining joins in a report.