A data design where a central fact table is surrounded by multiple dimension tables.
A denormalized data model where multiple dimension tables connect directly to a central fact table. Because the dimension tables aren't normalized, they carry redundant data, but the tradeoff is a shallow join hierarchy that keeps analytical queries fast and simple to write.
© 2026 ITBGM