Here are a few things to remember when creating dimension tables.
在创建维度表时，需要记住如下问题。
Large dimension tables can produce resource intensive Cartesian joins.
大型维度表可能产生资源密集的Cartesian连接。
This implies joins between several dimension tables and the fact table.
这意味着要将几个维表与事实表相联结。
Table-level predicates typically exist on some dimension tables as well.
表级谓词通常也存在于一些维度表中。
This is a star schema consisting of a fact table and four dimension tables.
这是一个星型模式，由一个事实表和4个维表组成。
The query includes one or more filters on at least one of the dimension tables.
查询至少在一个维度表上包含一个或更多的过滤器。
Some dimension tables can be quite large and are good candidates for Design Filters.
有些维度表可能非常大，而且是DesignFilters的候选项。
In the above, T1 is the fact table with FK-PK relationship with dimension tables T2 and T3.
其中，T1是与维表t2和t3有fk - PK关系的事实表。
The fact table in the dimensional model has a single join with all the other dimension tables.
维度模型中的事实表与其他所有维度表之间存在单一连接。
STEP Ea: Alter the fact table and create the proper FK relationships with the dimension tables.
第 5.1步： Alter（修改）事实表，创建正确的维度表外键（FK）联系。
We have already covered fact tables, so in this column we will look at how to design dimension tables.
我们已经讨论过事实表，因此本专栏将关注如何设计维度表。
One advantage of the snowflake dimension is the space savings, because you normalize your dimension tables.
雪花式维度的优势之一是，因为规范化了维度表而实现了空间节省。
A dimensional model has three key parts: the fact tables, the dimension tables, and the summary tables.
维度建模包括三个关键部分：事实表、维度表、以及汇总表。
The star schemas require the generation and proper use of primary or foreign keys for the fact and dimension tables.
星型模式要求生成并适当使用事实表和维表的主键或外键。
The report data comes from four dimension tables PROJECT, DEPARTMENT, ACTIVITY, D_TIME and one fact table HUMANCOST.
报告数据来自四个维度表project、DEPARTMENT、ACTIVITY、D _ TIME和一个事实表humancost。
We have already covered fact and dimension tables, so in this column, we will look at how to design summary tables.
我们已经讨论过事实表和维度表，因此本专栏将关注如何设计汇总表。
The report data comes from four dimension tables: PROJECT, DEPARTMENT, ACTIVITY, D_TIME; and one fact table: HUMANCOST.
报表数据来自四个维度表：PROJECT、DEPARTMENT、ACTIVITY、D_TIME和一个事实表HUMANCOST。
STEP A: We assume you have created a database with the default table spaces. Create the fact and dimension tables as follows.
第 1 步：我们假设已经用默认表空间创建了一个数据库，同时创建下面的事实表和维度表。
Connect to database GBPM4ETL and run script GBPM4ET.sql to create the dimension tables and fact table, as illustrated in Figure 10.
连接数据库GBPM 4etl，运行脚本GBPM 4et . sql以创建维度表和事实表，如图10所示。
It is made up of a facts object, which represents the fact table, and a set of dimension objects, representing the dimension tables.
它由一个事实对象(代表事实表)和一组维对象(代表维表)组成。
Informix serial Numbers work really well as generalized keys, and I am a fan of using a serial number column on all dimension tables.
Informix的序号很适合作为通用键，并且我非常热衷于在每个维度表中使用序号列。
Only queries from a particular application that accesses a particular set of tables (for example, a fact table and its dimension tables)
只来自访问特定一组表（例如，一个事实表和它的维表）的一个特定应用程序的查询。
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 ）中支持两种层次结构。
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来创建维度表和事实表。
A star join query typically involves a fact table and several dimension tables, with join predicates between the fact table and each dimension table.
一个星型连接查询通常包含一个事实表和几个维度表，事实表和每个维度表之间都有连接谓词。
Another design approach is a snowflake dimension, in which you normalize the dimensions to create dimension tables that link to other dimension tables.
另一个设计方法是雪花式维度，通过规范化维度，来创建关联到其他维度表的维度表。
Building bitmap join indexes of dimension tables and fact tables directly may bring a large number of useless index items that affect query efficiency.
直接建立维度表与事实表的位图连接索引会产生大量无用的索引项，影响查询效率。
Run the following command, as seen in Figure 11, to import demo data into dimension tables ACTIVITY, DEPARMENT, PROJECT, and D_TIME and fact table HUMANCOST.
运行下面的命令，如图11所示，将演示数据导入维度表activity、DEPARMENT、PROJECT和D _ TIME以及事实表humancost中。
Data in this fact table would typically be joined with data in multiple dimension tables to obtain specific details about various products, regions, and so on.
这个事实表中的数据通常与多个维表中的数据联结，从而获取关于各个产品、地区等的特定信息。
The works include the design of fact tables and dimension tables; the design of metadata; and the design and development of function modules of the StatDB.
包括事实表和维表的设计，元数据结构的设计，及统计库功能模块的设计和实现。
应用推荐