Top Qs
Timeline
Chat
Perspective
Fact constellation
Database schema From Wikipedia, the free encyclopedia
Remove ads
A fact constellation schema, also referred to as a galaxy schema, is a model using multiple fact tables and multiple dimension tables.[1] These schemas are implemented for complex data warehouses.[1]
 | This article needs additional citations for verification. (November 2024) |
The fact constellation is a measure of online analytical processing and can be seen as an extension of the star schema.
A fact constellation schema has multiple fact tables. It is a widely used schema and more complex than star schemas and snowflake schemas. It is possible to create a fact constellation schema by splitting the original star schema into more star schemas. It has many fact tables and some common dimension tables.
Remove ads
See also
References
Wikiwand - on
Seamless Wikipedia browsing. On steroids.
Remove ads