From the course: Introduction to Data Warehouses
Join today to access over 25,300 courses taught by industry experts.
Snowflake schema
From the course: Introduction to Data Warehouses
Snowflake schema
- [Instructor] A snowflake schema is a multi-dimensional data model that is used in data warehousing. It's called a snowflake schema because of its unique structure that looks like a snowflake. Unlike the star schema, which is also a multi-dimensional data model, a snowflake schema is more normalized and has a more complex structure. So why use a snowflake schema? Because they're efficient at storing and retrieving data and querying. A snowflake schema provides a clear and organized structure for data warehousing and makes it easier to handle large amounts of data. It also helps eliminate data redundancy and increase consistency. Here's how a restaurant can apply this concept. The main fact table in our restaurant would be the order table, which stores information about each order placed. The dimension table in the snowflake schema would be ingredients, customers, and payments. The dimensions tables are related…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.