In Part 2, you'll learn how to set up the cube summary tables.
在第2部分中,您将学习如何建立多维数据集摘要表。
In Part 2 of this series, we'll focus on how to set up the cube summary tables.
在本系列的第2部分中,我们将主要关注如何建立多维数据集摘要表。
You can automate things like building summary tables and listing linked topics.
您可以让构造汇总表和列出链接主题这样的事情自动完成。
A dimensional model has three key parts: the fact tables, the dimension tables, and the summary tables.
维度建模包括三个关键部分:事实表、维度表、以及汇总表。
The following sections introduce you to these two types of MQTs, as well as summary tables and staging tables.
下面的几个小节将介绍这两种类型的MQT,另外再介绍总结表和staging表。
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
第三种方法是在ETL流程之后使用SQLSUM和汇总函数来重构汇总表。
We have already covered fact and dimension tables, so in this column, we will look at how to design summary tables.
我们已经讨论过事实表和维度表,因此本专栏将关注如何设计汇总表。
You might also be interested in other outputs that the software generates, such as summary tables and tail probability.
您可能还会对该软件生成的其它输出 —例如汇总表和尾数概率 —感兴趣。
In fact, the goal is to have 90 percent of your queries running against the summary tables so the user gets very fast responses.
事实上,我们的目标是使90%的查询都针对汇总表运行,以便用户获取非常快的响应。
Transactional database systems in general are not very good at generating summary tables from log tables, because in this case row locking is almost useless.
传统的数据库一般地在从日志表中生成摘要表这方面的表现不怎么好,因为在这种情况下,行记录锁几乎没用。
A well-designed data warehouse has a pyramid of summary tables, each one containing more detail until you arrive at the fact table, at the bottom of the pyramid.
一个设计良好的数据仓库拥有由大量汇总表,形成一个“金字塔”,每个汇总表都包含更多细节,直到金字塔底部的事实表。
Another benefit of summary tables is that they let you compare results from two different fact tables (maybe even in separate data marts) that have different grains.
汇总表的另一个好处是支持对有不同粒度的两个事实表(甚至可能位于单独的数据市场中)进行比较。
While the format will be tool-dependent, it will most often consist of summary tables and graphs from which it is possible to drill down into the supporting detail data.
尽管具体的格式依赖于工具,但是结果常常由汇总表和图组成,可以从这些图表向下钻取到详细数据。
Summary tables of analytical runs of clinical or preclinical samples.
临床或临床前样品分析批汇总表。
Summary tables containing information on sample processing and storage.
含有样品处理和存储信息的汇总表。
Summary tables are an important part of creating a high-performance data warehouse.
汇总表是创建高性能数据仓库的重要部分。
Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
在数据仓库中需要汇总表,来实现快速查询,并允许用户在事实表中钻入钻出。
Materialized Query Tables (MQTs), formerly known as Automatic Summary Tables (ASTs), can be defined to locally cache the result of queries that reference relational and non-relational nicknames.
可以通过定义物化查询表(Materialized QueryTables, MQT)——以前称为自动总结表(Automatic Summary Tables,AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
Materialized Query Tables (MQTs), formerly known as Automatic Summary Tables (ASTs), can be defined to locally cache the result of queries that reference relational and non-relational nicknames.
可以通过定义物化查询表(Materialized QueryTables, MQT)——以前称为自动总结表(Automatic Summary Tables,AST)——来在本地缓存引用关系和非关系昵称的查询的结果。
应用推荐