Astronomy:Fact constellation
From HandWiki
Short description: Database schema
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
References
- ↑ 1.0 1.1 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.
 |  |
