Data warehousing snow flake scheme

Data warehousing - What is snow flake scheme design in database? - August 07, 2008 at 17:10 pm by Rajmeet Ghai

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.

E.g. Dimension tables include employee, projects and status. Status table can be further broken into status_weekly, status_monthly.

Data warehousing - What is snow flake scheme design in database? - May 11, 2009 at 14:40 pm by Vidya Sagar

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.


Write your comment - Share Knowledge and Experience

More Related Links
What is the difference between view and materialized view?

Answer - A view is created by combining data from different tables........

What is a Cube and Linked Cube with reference to data warehouse?

Answer - A data cube stores data in a summarized version which helps in a faster analysis............

What is junk dimension?

Answer - In scenarios where certain data may not be appropriate to store in....

What are fundamental stages of Data Warehousing?

Answer - Stages of a data warehouse helps to find and understand.......


Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us