Synonyms
Snowflake join schema
Definition
Asnowflake schema has one “central” table whose primary key is compound, i.e., consisting of multiple attributes. Each one of these attributes is a foreign key to one of the remaining tables, which may, in turn, have some of its non-key attributes each be a foreign key to yet another, different table. This continues recursively with the remaining tables, until they are exhausted, forming chains or trees of foreign key dependencies rooted at the “central” table, i.e., each table in the schema (except the “central” table) is pointed to by exactly one such foreign key. (In the above, without loss of generality, we make the assumption that all tables except the “central” table have simple primary keys. This is usually the case in almost all practical situations, and as for efficiency, these keys are often generated, surrogate keys.)
Key Points
Many data warehouses (see definitional entry for “Data Warehouse”) that represent the multidimensional...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Chaudhuri S, Dayal U. An overview of data warehousing and OLAP technology. ACM SIGMOD Rec. 1997;26(1):65–74.
Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. New York: Wiley; 2002.
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Morfonios, K., Ioannidis, Y. (2018). Snowflake Schema. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_889
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_889
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering