Explain the Snowflake Schema in Brief.

1.	Explain the Snowflake Schema in Brief.
Answer» A snowflake schema is a logical ARRANGEMENT of tables in a multidimensional database that matches the snowflake shape (in the ER diagram). A Snowflake Schema is an enlarged STAR Schema with additional dimensions. After the DIMENSION tables have been NORMALIZED, the data is separated into new tables. Snowflaking has the potential to improve the performance of certain queries. The schema is organized so that each fact is surrounded by its related dimensions, and those dimensions are linked to other dimensions, forming a snowflake pattern.

Answer»

A snowflake schema is a logical ARRANGEMENT of tables in a multidimensional database that matches the snowflake shape (in the ER diagram). A Snowflake Schema is an enlarged STAR Schema with additional dimensions. After the DIMENSION tables have been NORMALIZED, the data is separated into new tables.

Snowflaking has the potential to improve the performance of certain queries. The schema is organized so that each fact is surrounded by its related dimensions, and those dimensions are linked to other dimensions, forming a snowflake pattern.

Discussion

No Comment Found

Related InterviewSolutions

What is the difference between Spark and MapReduce?
What is Apache Spark?
What is the difference between HDFS block and InputSplit?
What is the Replication factor?
What is Hadoop Streaming?
Name the XML configuration files present in Hadoop.
Explain the Snowflake Schema in Brief.
Explain the Star Schema in Brief.
What is the relevance of Apache Hadoop's Distributed Cache?
What is COSHH?