Common Uses
Star and snowflake schemas are most commonly found in dimensional data warehouses and data marts where speed of data retrieval is more important than the efficiency of data manipulations. As such, the tables in these schemas are not normalized much, and are frequently designed at a level of normalization short of third normal form.
Deciding whether to employ a star schema or a snowflake schema should involve considering the relative strengths of the database platform in question and the query tool to be employed. Star schemas should be favored with query tools that largely expose users to the underlying table structures, and in environments where most queries are simpler in nature. Snowflake schemas are often better with more sophisticated query tools that create a layer of abstraction between the users and raw table structures for environments having numerous queries with complex criteria.
Read more about this topic: Snowflake Schema
Famous quotes containing the word common:
“Poetry, at all times, exercises two distinct functions: it may reveal, it may unveil to every eye, the ideal aspects of common things ... or it may actually add to the number of motives poetic and uncommon in themselves, by the imaginative creation of things that are ideal from their very birth.”
—Walter Pater (1839–1894)
“The common faults of American language are an ambition of effect, a want of simplicity, and a turgid abuse of terms.”
—James Fenimore Cooper (1789–1851)