时间维度表。
一个数据库选项,用来决定此应用程序是否应在时间维度表首次启动被创建时完全填充此表。
A database option that determines if the application should fully populate the time dimension table when the table is created on first startup.
下面的步骤将介绍如何创建一个简单的多事实模型,其中包括一个基于底层数据库的时间维度表手动创建的时间维度。
The following steps will illustrate how to build a simple multi-fact model that incorporates a manually created time dimension based on a time dimension table found in the underlying database.
如果计费系统事实表包含项目数量、支付的金额、到期金额,其相关的维度表可能包含产品信息、客户信息、以及时间或日期信息。
If a billing system fact table contains item quantity, amount paid, and amount due, its related dimension tables might include product information, customer information, and time or date information.
本图是简单星型模型设计图,中间是一张事实表,还有其相关维度,本例中是促销活动、产品、时间。
The diagram shows a simple star schema design with one fact table in the middle and its related dimensions, in this case, promotions, products, and time.
在这种情况下,列维度被设置为一个时间表。
In this case, the column dimension has been set as a timescale.
伪事实表将会用在连接中代替实际的事实表,从而提升单独从维度查询的响应时间。
The fake fact table will be used in the joins instead of the actual fact table, thereby improving response times when querying solely from the dimensions.
伪事实表将会用在连接中代替实际的事实表,从而提升单独从维度查询的响应时间。
The fake fact table will be used in the joins instead of the actual fact table, thereby improving response times when querying solely from the dimensions.
应用推荐