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的候选项。
The fact table in the dimensional model has a single join with all the other dimension tables.
维度模型中的事实表与其他所有维度表之间存在单一连接。
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.
维度建模包括三个关键部分:事实表、维度表、以及汇总表。
One advantage of the snowflake dimension is the space savings, because you normalize your dimension tables.
雪花式维度的优势之一是,因为规范化了维度表而实现了空间节省。
We have already covered fact and dimension tables, so in this column, we will look at how to design 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。
STEP A: We assume you have created a database with the default table spaces. Create the fact and dimension tables as follows.
第 1 步:我们假设已经用默认表空间创建了一个数据库,同时创建下面的事实表和维度表。
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 )中支持两种层次结构。
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.
另一个设计方法是雪花式维度,通过规范化维度,来创建关联到其他维度表的维度表。
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 optimizer will then join that temp table to the fact table using the compound index to quickly locate the rows that satisfy the criteria on the dimension tables.
优化器然后使用复合索引将临时表连接到事实表,来快速定位在维度表中满足条件的行。
It will be more efficient to create a measures data source in Transformer that takes its keys from the actual fact table rather than from its related dimension tables.
使用事实表的键,而不是使用相关维度表的键,是一个更有效的创建Transformer度量指标数据源的方法。
The dimension tables describe each analysis entry in the fact table: the actual date, the keyword values and categories as well as corresponding document title and content.
维表描述事实表中的每个分析条目:实际日期、关键词值和类别以及相应的文档标题和内容。
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.
该优化器将可以识别出这个索引,在维度表上使用过滤器来在一个临时表中生成一个维度表键的有效组合列表。
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名客户的客户维度,以及三个小的维度表,分别用于组织、程序和商品。
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.
它通常有一个大型的中心表(称作事实表)和一组小型表(称作维度表),维度表以放射模式围绕事实表。
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 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.
如果计费系统事实表包含项目数量、支付的金额、到期金额,其相关的维度表可能包含产品信息、客户信息、以及时间或日期信息。
应用推荐