How to choose Star vs. Snowflake Schema
| Star Schema Questions | Snowflake Schema Questions |
1. Question: If the client needs extremely fast query performance and simple ad-hoc reporting across broad business dimensions... Choice: Choose Star Schema | 2. Question: If the client has strict data storage limits and needs to normalize hierarchical attributes to prevent data duplication... Choice: Choose Snowflake Schema |
3. Question: If business analysts will be writing their own self-service SQL queries and need easy-to-navigate tables with minimal joins... Choice: Choose Star Schema | 4. Question: If the enterprise data warehouse requires strict referential integrity where dimension updates must happen in a single lookup table... Choice: Choose Snowflake Schema |
5. Question: If the BI reporting tool is designed for online analytical processing (OLAP) cubes that perform best with flat, denormalized dimensions... Choice: Choose Star Schema |
No comments:
Post a Comment