在下一专栏中，我们将关注汇总表。
他首先查看底层数据库汇总表。
汇总表是指其定义基于查询结果的表。
A summary table is a table whose definition is based on a result of a query.
这样，您不必担心需要反复构建汇总表。
That way you never have to worry about building the summary table again and again.
第一张工作表是汇总表。
一个关键设计决策是汇总表的粒度。
临床或临床前样品分析批汇总表。
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.
金字塔顶端的汇总表比较小，因此对它的查询非常快。
The summary table at the top of the pyramid is small, so queries on it are very fast.
汇总表都与速度有关。
您可以让构造汇总表和列出链接主题这样的事情自动完成。
You can automate things like building summary tables and listing linked topics.
在汇总表中，我们显示来自其他工作表的余额。
On the Summary sheet we display the balance from each of the other sheets.
从汇总表，他们可以选择打算进一步向下挖掘查看更多细节的维度。
From the summary table, they can then pick the dimensions that they want to drill down into and see more detail.
维度建模包括三个关键部分：事实表、维度表、以及汇总表。
A dimensional model has three key parts: the fact tables, the dimension tables, and the summary tables.
初步的布局汇总表中可以自订通过的配置，并在运行时通过过滤。
The initial layout of the summary table can be customized through configuration, and in runtime through filtering.
理想情况下，数据仓库的结构提供一个针对业务用户想问的所有问题的汇总表。
Ideally, the structure of the data warehouse offers a summary table for any question that business users want to ask.
汇总表存储以回答常见(或资源密集型)业务查询的方式汇总的数据。
A summary table stores data that has been aggregated in a way that answers a common (or resource-intensive) business query.
我们已经讨论过事实表和维度表，因此本专栏将关注如何设计汇总表。
We have already covered fact and dimension tables, so in this column, we will look at how to design summary tables.
通过二次开发建立标准化的数据表、设备汇总表和图形符号和标签。
Standard datasheets, equipment lists, symbols and label have been established through the secondary development.
您可能还会对该软件生成的其它输出 —例如汇总表和尾数概率 —感兴趣。
You might also be interested in other outputs that the software generates, such as summary tables and tail probability.
事实上，我们已经看到，IWA取代了我在数据仓库中设计的汇总表中的许多需求。
In fact, I see IWA replacing the need for many of the summary tables I design in a data warehouse.
通过利用索引、缓存、登录开销的减少、汇总表以及取数据的减少来减少I/O。
Reduce I/O by taking the advantage of indexes, caching, reduced logging overhead, summary tables, and reduced fetches.
我们构建了一个汇总表，汇总收入和费用细节，显示每笔交易的最终结果。
We built a summary table that aggregated the income and expense detail to show the end result for each transaction.
因此，汇总表通常包含基于其定义所基于的表中的现有数据的预计算结果。
As such, the summary table typically contains pre-computed results based on the data existing in the table or tables that its definition is based on.
事实上，我们的目标是使90%的查询都针对汇总表运行，以便用户获取非常快的响应。
In fact, the goal is to have 90 percent of your queries running against the summary tables so the user gets very fast responses.
第三种方法是在ETL流程之后使用SQLSUM和汇总函数来重构汇总表。
A third method is to have the summary tables rebuilt after the ETL process using SQL sum and aggregate functions.
另一种方法是使提取、转换和加载(etl)流程在加载事实表时更新汇总表。
Another way is to have the extract, transform, and load (ETL) process update the summary table as it loads the fact table.
在数据仓库中需要汇总表，来实现快速查询，并允许用户在事实表中钻入钻出。
Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
在数据仓库中需要汇总表，来实现快速查询，并允许用户在事实表中钻入钻出。
Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
应用推荐