请输入您要查询的百科知识:

 

词条 Fact constellation
释义

  1. See also

  2. References

Fact constellation is a measure of online analytical processing, which is a collection of multiple fact tables sharing dimension tables, viewed as a collection of stars.[1] It can be seen as an extension of the star schema.

A fact constellation schema has multiple fact tables. It is also known as galaxy schema. It is widely used schema and more complex than star schema and snowflake schema. It is possible to create fact constellation schema by splitting original star schema into more star schema. It has many fact tables and some common dimension table.

See also

  • Online analytical processing
  • Star schema
  • Snowflake Schema
{{database-stub}}

References

1. ^http://datawarehouse4u.info/Data-warehouse-schema-architecture-fact-constellation-schema.html

1 : Online analytical processing

随便看

 

开放百科全书收录14589846条英语、德语、日语等多语种百科知识,基本涵盖了大多数领域的百科知识,是一部内容自由、开放的电子版国际百科全书。

 

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间:2024/9/23 8:28:53