Fact constellation
 | This article needs more citations. (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]- 1 2 Turcan, G.; Peker, S. (2022). "A multidimensional data warehouse design to combat the health pandemics". Journal of Data, Information and Management. 4 (3–4): 371–386. doi:10.1007/s42488-022-00082-6. PMC 9763078.
 | This database-related article is a stub. You can help Wikipedia by adding missing information. |