Summary tables are all about speed.
汇总表都与速度有关。
In my next column, we will look at summary tables.
在下一专栏中，我们将关注汇总表。
In Part 2, you'll learn how to set up the cube summary tables.
在第2部分中，您将学习如何建立多维数据集摘要表。
Summary tables of analytical runs of clinical or preclinical samples.
临床或临床前样品分析批汇总表。
Summary tables containing information on sample processing and storage.
含有样品处理和存储信息的汇总表。
In Part 2 of this series, we'll focus on how to set up the cube summary tables.
在本系列的第2部分中，我们将主要关注如何建立多维数据集摘要表。
Summary tables are an important part of creating a high-performance data warehouse.
汇总表是创建高性能数据仓库的重要部分。
You can automate things like building summary tables and listing linked topics.
您可以让构造汇总表和列出链接主题这样的事情自动完成。
Before the position summary tables we include summaries of Base Pay and Total Cash.
在岗位汇总表之前，包含有基本薪酬和总现金薪酬的概要。
In fact, I see IWA replacing the need for many of the summary tables I design in a data warehouse.
事实上，我们已经看到，IWA取代了我在数据仓库中设计的汇总表中的许多需求。
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.
我们已经讨论过事实表和维度表，因此本专栏将关注如何设计汇总表。
Reduce I/O by taking the advantage of indexes, caching, reduced logging overhead, summary tables, and reduced fetches.
通过利用索引、缓存、登录开销的减少、汇总表以及取数据的减少来减少I/O。
You might also be interested in other outputs that the software generates, such as summary tables and tail probability.
您可能还会对该软件生成的其它输出 —例如汇总表和尾数概率 —感兴趣。
Summary tables are required in a data warehouse for fast query processing and to allow users to drill up and down into the facts.
在数据仓库中需要汇总表，来实现快速查询，并允许用户在事实表中钻入钻出。
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.
尽管具体的格式依赖于工具，但是结果常常由汇总表和图组成，可以从这些图表向下钻取到详细数据。
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)——来在本地缓存引用关系和非关系昵称的查询的结果。
Consider a scenario where a customer purchase order is stored in two tables: order with the order summary and ORDER_ITEMS with the list of items for each order.
考虑一个场景：一个顾客购物订单被存储在两个表中：ORDER和ORDER_ITEMS, ORDER中包含订购的总数，而ORDER_ITEMS中则包含订购的每一项商品的列表。
On the Summary page, review your choices and click Finish to generate the SQL script for creating the control tables.
在Summary页面上，查看您的选择，并单击Finish以生成用于创建控制表的sql脚本。
Summary: Roger E. Sanders explains why, where, when, and how to partition tables with DB2 for Linux, UNIX, and Windows—and shows how enhancements in DB2 9.7 make the process easier and faster.
简介：RogerE. Sanders解释使用DB2forLinux,UNIX,andWindows 进行表分区的原因、地点、时间和方式，并展示 DB2 9.7 中的增强如何使分区过程更简单快速。
Generate alternate representations of the content, such as tables of contents, indexes, and summary views.
生成内容的替代表示，如内容表、索引和摘要视图。
The fullselect that is part of the definition of a summary table contains a GROUP BY clause summarizing data from the tables that are referenced in the fullselect.
fullselect是总结表定义的一部分，它包含一个GROUPBY 子句，该子句总结 fullselect 中所引用表中的数据。
The fullselect that is part of the definition of a summary table contains a GROUP BY clause summarizing data from the tables that are referenced in the fullselect.
fullselect是总结表定义的一部分，它包含一个GROUPBY 子句，该子句总结 fullselect 中所引用表中的数据。
应用推荐