Data Modelling: Star x Snowflake Schemas
The formation of snowflakes is a complex and delicate process This week, I added more tables to a data schema I created a few months ago. To ensure optimal query performance when checking data quality, I took a deeper look at the differences between the two most popular schemas: star and snowflake. Now, if you are new to this, your first question may be: What is a data schema? To answer that question, let's start with the origin of the word. "Schema" comes from the Greek word σχῆμα (skhēma), which means shape or plan. A data schema is the blueprint that defines the structure of the database, including tables, columns, data types, constraints, and entity relationships. Naturally, your next question may be: What is the difference between a star and a snowflake? Well, that's a good question! I hope we can both agree that a star may look like a snowflake, but it's not a snowflake. What makes a snowflake special is its tendency to branch out at the end. Your fi...