Fact constellation
 | This article needs additional citations for verification. (November 2024) |
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]
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.
See also
[edit]References
[edit]- ^ a b Turcan, G.; Peker, S. (2022). "A multidimensional data warehouse design to combat the health pandemics". Journal of Data, Information and Management. 4: 371–386. doi:10.1007/s42488-022-00082-6.
 | This database-related article is a stub. You can help Wikipedia by expanding it. |