A design that further normalizes the dimension tables of a star schema.
A data model that further normalizes a star schema's dimension tables, resulting in a structure resembling a snowflake. It saves storage and makes keeping data consistent on update easier, but analytical queries need to join more tables than with a star schema, trading query simplicity and performance for that normalization.
© 2026 ITBGM