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.
Data warehousing analysis service: What is analysis service?
Data warehousing analysis service - Analysis service provides a combined view of the data used in OLAP or Data mining......
Data warehousing: Explain sequence clustering algorithm.
Data warehousing sequence clustering algorithm - Sequence clustering algorithm collects similar or related paths, sequences of data containing events....
Data warehousing: Explain discrete and continuous data in data mining.
Explain discrete and continuous data in data mining - Discreet data can be considered as defined or finite data. E.g. Mobile numbers, gender.....
Post your comment

Related Content

Follow us

▲