Choose Index below for a list of all words and phrases defined in this glossary.
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: dqglossary@grcdi.nl