Data warehousing snow flake scheme: What is snow flake scheme design in database?
What is snow flake scheme design in database?A snowflake Schema in its simplest form is an arrangement of fact tables and dimension tables. The fact table is usually at the center surrounded by the dimension table. Normally in a snow flake schema the dimension tables are further broken down into more dimension table.
For e.g. Dimension tables include employee, projects and status. Status table can be further broken into status_weekly, status_monthly.
What is snow flake scheme design in database?Snow flake schema is one of the designs that are present in database design. Snow flake schema serves the purpose of dimensional modeling in data warehousing. If the dimensional table is split into many tables, where the schema is inclined slightly towards normalization, then the snow flake design is utilized. It contains joins in depth. The reason is that, the tables split further.