A snowflake schema is a variant of the star schema used in data warehouses, in which dimension tables are normalized. This means that dimension tables are divided into smaller, more detailed tables to avoid excessive data duplication and ensure better organization. This normalization may include separating dimension attributes into different hierarchy levels, allowing for more detailed data analysis. The snowflake schema is used in situations where there is a need to reduce data redundancy and optimize query performance, but it can be more complex to manage than the traditional star schema.
Słownik