InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Explain snowflake schema database design. |
|
Answer» A snowflake schema is a schema that has one or more dimension tables that do not connect directly to the fact table but should be interacting with it via other dimension tables. The process of normalizing dimension tables in STAR schema to resemble a snowflake-like structure with the fact table at the centre is called snowflaking. It is represented in the image below: The tables in the snowflake schema are normalized to 3NF form and each dimension LEVEL in the schema represents one level in the hierarchy. The central fact table is linked to multiple dimension tables that can be linked to other dimension tables via many-to-many or many-to-one relationships. The schema is USEFUL for enhancing the query performance as there are minimum disk requirements and the JOINING of smaller LOOKUP tables. |
|