事实表可以根据一或多个外键过滤。
The fact tables can be filtered on one or more of their foreign keys.
最后，您的事实表将拥有数十亿条记录。
Finally, your detailed fact table will have billions of records.
从事实表中选择在几个维上符合标准的行。
Select rows from a fact table that meet criteria for several dimensions.
索引下推使用下推键执行事实表外键索引的查询。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
事实表包含了所度量和记录的内容——通常是数字。
A fact table contains things that you measure and record-typically Numbers.
实际的比例取决于事实表中带有下推键的行的分布。
The actual proportion depends on the distribution of rows with the pushed-down keys in the fact table.
如果事实表数据量很大，那么响应时间会比预期长。
If the fact table is large in volume, then the response time may be longer than expected.
Orders事实表包含100,000,000行。
一旦事实表中的项目加入报表中，结果就变得有意义了。
The results become meaningful once items from the fact table are added to the report.
维度模型中的事实表与其他所有维度表之间存在单一连接。
The fact table in the dimensional model has a single join with all the other dimension tables.
这个查询对每个事实表和维度表之间的连接使用散列连接。
This query plan uses hash join for each join between the fact table and a dimension table.
维度表的层次与它需要连接到中心事实表的连接数目有关。
The level of a dimension table corresponds to number of links it needs to connect to the central fact table.
我们已经讨论过事实表，因此本专栏将关注如何设计维度表。
We have already covered fact tables, so in this column we will look at how to design dimension tables.
维度建模包括三个关键部分：事实表、维度表、以及汇总表。
A dimensional model has three key parts: the fact tables, the dimension tables, and the summary tables.
维度表需要作为主键数据的通用键；这将作为事实表的外键。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
事实表上的动态过滤减少了实际散列连接探测阶段使用的行数。
This dynamic filter on the fact table reduces the number of rows used in the probe phase of the actual hash joins.
但此选项，仍然会在边上通过连接到普通事实表来检索维度成员。
This option, however, still retrieves the dimension members on the edges through joins to a common fact table.
前面的例子只包含了一个来自底层数据库事实表的一个度量指标。
The previous example only contained a measure that was taken from one fact table in the underlying database.
当您考虑将在事实表上发生的可能汇总时，相加性就变得很重要。
Additivity becomes important when you consider the possible summarizations that will occur on a fact table.
因此，在查询中合并事实表从而生成结果所需的时间比预期要长。
Therefore the query may take longer than expected as it is also incorporating the fact table in the query to produce results.
事实表行现在表示文档，而不是关键词在文档中的出现。
Fact table rows now represent documents instead of keyword occurrences within the document.
给 Transformer建模师提供事实表中发现的外键。
Expose foreign keys found in fact tables to Transformer modelers.
如果设置了这种环境，那么只有清单中指定的表才可以作为事实表。
If this environment is set, only tables specified in the list can be used as 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.
星型模式要求生成并适当使用事实表和维表的主键或外键。
The star schemas require the generation and proper use of primary or foreign keys for the fact and dimension tables.
逻辑上，每个事实表行现在代表一个文档，而不是关键词的一次出现。
Logically, each fact table row now represents a document, not a keyword occurrence.
在清理泄漏的水银前，务必先阅读水银泄漏通用事实表中的预防措施。
Before cleaning any mercury spills, be sure to read and follow the precautions found in the general mercury spill fact sheet.
构建散列表时，连接键被下推用于过滤事实表的行，性能也显著提高。
When hash tables are built, join keys are pushed down and used to filter the rows of the fact table, and performance improves dramatically.
OLAP查询通常将事实表的许多行聚合成一个相对少量的汇总结果。
OLAP queries typically aggregate many rows of the fact table into a relatively small number of summary results.
在前面的初始星型模式中，对于每次的关键词的出现，事实表都包含一行。
In the initial star schema above, the fact table contains one row for each keyword occurrence.
应用推荐