Choose Index below for a list of all words and phrases defined in this glossary.


index | Index

Snowflaking - definition(s)

Snowflaking - Normalization applied to the dimension tables of a star schema.

The star schema is a very simple database design, which clearly presents the multidimensional character of the data and allows for rapid querying of the data in a data warehouse. In snowflaking, some of the fields of the dimension tables are split off into separate tables. This achieves a higher level of normalization, but makes the database design more complex and can reduce the performance and ease of use for Business Intelligence Tools.

[Category=Data Warehousing ]

Source: SDG Computing Inc., 12 May 2010 11:20:47, SDG Computing, now offline





Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: