One of the most important design decisions you face is how to capture hierarchy information in a dimension table.
您所要面对的最重要的设计决策之一，是如何捕获维度表的层次结构信息。
A database option that specifies the number of days (starting from the current date) to pre-populate in the date dimension table when it creates it on first startup.
一个数据库选项，用来指定日期维度表在初次启动被创建时预填充的天数(从当前日期开始)。
The fact table only contains IDs for referencing dimensions tables, and measures for measuring the changing or performance of all dimension members.
事实表只包含用于引用维度表的ID，以及用于测量所有维度成员变化或性能的测度。
Each join reduces the size of the fact table by one-tenth due to selectivity of the table filter on each dimension table.
由于每个维度表过滤的选择度，每次连接都会减少事实表大小的十分之一。
Dimension table design is an essential part of enabling users to move easily through the data, drilling in and out to see what is going on at different levels.
维度表设计是使得用户轻松跨越数据，实现钻入和钻出，来了解在不同级别将要发生什么的必要部分。
The optimizer will recognize this index and use the filters on the dimension tables to generate a list of valid combinations of the dimension tables' keys into a temp table.
该优化器将可以识别出这个索引，在维度表上使用过滤器来在一个临时表中生成一个维度表键的有效组合列表。
In either case, consider adding additional logic in the join expressions to the fake fact table that will reduce the range of join key values that can be returned from the dimension tables.
在这两种情况下，考虑在伪事实表的连接表达式中添加额外的逻辑，这会缩小从维度表返回的连接键值的范围。
If only a few rows are selected from the dimension table so that only a few keys are pushed down, then rows of the fact table might be reduced proportionally.
如果只有几行从维度行中被选出，这样就只有几个键被下推，然后事实表的行数可能也会相应地减少。
The performance improvement depends on the selectivity of the filter on the dimension table from which the join keys are pushed down.
性能的提高取决于连接键被下推时所在维度表的过滤选择度。
Once the set of tables used by the dimension has been determined, it may be necessary to assign a unique correlation name to each table.
判断出这一维使用的表集之后，需要为每个表分配一个惟一的关联名。
The level of a dimension table corresponds to number of links it needs to connect to the central fact table.
维度表的层次与它需要连接到中心事实表的连接数目有关。
The number of rows selected from each dimension table is less than the number of rows selected from the fact table after all scan filters are applied.
所有的扫描过滤器都应用后，每个维度表选出的行数少于事实表选出的行数。
Since the interest rate is an attribute of Account table, the Account dimension table needs to be added.
因为利率是account表的一个属性，所以需要添加account维度表。
Only queries from a particular application that accesses a particular set of tables (for example, a fact table and its dimension tables)
只来自访问特定一组表（例如，一个事实表和它的维表）的一个特定应用程序的查询。
It contains a fact table of 630 million records, a customer dimension of 2.5 million customers, and three small dimension tables for organization, programs, and commodities.
该架构包含一个拥有630,000,000条记录的事实表，一个拥有2,500,000名客户的客户维度，以及三个小的维度表，分别用于组织、程序和商品。
The time_id join keys that meet the filter requirements on the Time dimension table are hashed to create a bit vector that filters rows of the Orders table from the skip scan above.
Time维度表中满足过滤条件的 time_id连接键被散列以创建一个位向量，用于过滤以上跳跃式扫描的Orders 表行。
Figure 4 illustrates the connection to Database GBPM4ETL and the running of the script GBPM4ET.sql to create dimension tables and the fact table.
图4演示了连接DatabaseGBPM 4etl并运行脚本GBPM 4et . sql来创建维度表和事实表。
Table 1 is a mockup of how we would like our table to look after a user selects "All People" for the horizontal dimension and "All questions" for the vertical dimension.
表1模拟用户对水平维度选择“AllPeople”并对垂直维度选择“Allquestions”之后的表。
For example, if you have two ways of rolling up products, then you need to support both hierarchies in the dimension tables (see Table 1).
例如，如果有两种方式实现产品回滚，那么需要在维度表（见表 1 ）中支持两种层次结构。
It typically has one large central table (called the fact table) and a set of smaller tables (called the dimension tables) arranged in a radial pattern around the fact table.
它通常有一个大型的中心表(称作事实表)和一组小型表(称作维度表)，维度表以放射模式围绕事实表。
It is made up of a facts object, which represents the fact table, and a set of dimension objects, representing the dimension tables.
它由一个事实对象(代表事实表)和一组维对象(代表维表)组成。
This is a star schema consisting of a fact table and four dimension tables.
这是一个星型模式，由一个事实表和4个维表组成。
A relational database structure in which data is maintained in a single fact table at the center of the schema with additional dimension data stored in dimension tables.
数据保存在架构中心的单个事实数据表中而其他维度数据存储在维度表中的一种关系数据库结构。
As in previous releases, administrators use the ORGANIZE BY dimension (...) clause of the CREATE TABLE statement to specify multi-dimensional clustering.
与以前的版本一样，管理员使用CREATEtable语句的ORGANIZEBYDIMENSION(…)子句指定多维聚簇。
Convert each of the attributes identified above for di into SQL expressions. Table 5 gives an example using the QUARTER_NAME attribute from the time dimension.
将上面识别出的每个di属性转换为SQL表达式。
The member key column for the lowest level of the dimension must contain the keys that relate the fact table and the dimension table.
对应着维度最低级别的成员键列必须包含关联事实表和维度表的键。
The dimension, the measure, the fact table, the muhidimension data and the data cubes of the system are also discussed in the article.
然后给出了库存数据仓库中相关的维表、度量、事实表以及整个数据立方的设计。
Specially, the paper presented the creating of dimension table, fact table of multi-dimension data model, analyzed the construction of data model, data extraction and data maintenance tools.
其中重点介绍了多维数据模型的维表、事实表的结构设计，分析了数据模型的构建、数据抽取工具和数据维护工具的设计及实现。
The third drawing and dimension in the table underneath show parameters of WNtype flanges.
第三个图纸及其下面表格里的尺寸显示的是带颈对焊法兰的参数。
The third drawing and dimension in the table underneath show parameters of WNtype flanges.
第三个图纸及其下面表格里的尺寸显示的是带颈对焊法兰的参数。
应用推荐