Data warehouse modelling with Snowflake Schema
ABSTRACT : Snowflake is a data warehouse schema design where dimension tables are normalized on top of a star schema design. Snowflake schema is generally not recommended due to its performance overhead in joining the normalized dimensions tables. However, the snowflake schema can be extended in a way to improve performance for business analysis activities in business analysis, two environments are complementary and work together to provide effective business analytics. Firstly, the data warehouse environment transforms operational data into information. Secondly, the analytical environment delivers information to end users for further data analysis and decision making. The snowflake schema bridges a gap between two environments. This schema facilitates the mapping of wide dimension structures with many dimensions attributes to analytical processing hierarchies. The snowflake schema makes navigation along hierarchies easier and support flexible analysis such as dril...