再次查询总结表,仍然没有返回任何数据。
Another query against the summary table returns no data as well.
清单3展示了一个简单的创建总结表的例子。
Listing 3 shows a simple example of creating a summary table.
不出所料,此时对总结表的查询没有返回任何数据。
Not unexpectedly, a query against the summary table at this point returns no data.
清单4展示了一个使用有关联总结表的staging表的例子。
Listing 4 shows an example of using a staging table with a summary table.
下面的几个小节将介绍这两种类型的MQT,另外再介绍总结表和staging表。
The following sections introduce you to these two types of MQTs, as well as summary tables and staging tables.
这张总结表的主要功能是提醒厂方在以后的大货生产中要更加注意此类问题的再次发生。
The major function of this summary is reminding the factory must pay more attention to avoid these issues occur again in the future production.
再次查询总结表,又是没有返回数据,但是当执行了REFRESHtable语句之后,查询得以成功运行。
Another query against the summary table returns no data, but after the REFRESH table statement executes this time, the query runs successfully.
总结表名为EMP _ SUMMARY,它基于SAMPLE数据库中的底层表employee。
The summary table, which is named EMP_SUMMARY, is based on the underlying table EMPLOYEE in the SAMPLE database.
类似地,在对底层表执行update或delete操作之后,也可以在总结表中观察到相应的变化。
Similar behavior can be observed in response to update or delete operations against the underlying SALES table.
研究信息BE表格中汇总的是关于研究类型和场所位置的信息,应(与其它BE总结表一起)放在ANDA模块2.7中。
The Study Information BE table compiles importantinformation about study type and site locations and should be placed in Module 2.7 of the ANDA (along with the other BE summarytables).
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.
您应该记得,总结表是一种特殊类型的MQT,它们的fullselect包含一个GROUPBY子句,该子句总结fullselect中所引用表中的数据。
You will recall that a summary table is a specialized type of MQT whose fullselect contains a GROUP BY clause summarizing data from the tables that are referenced in the fullselect.
可以通过定义物化查询表(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.
表3.1总结了以上所给信息。
表3总结了每种解决方案的优点及缺点。
Table 3 summarizes the advantages and disadvantages of each approach.
表3总结了此应用程序的停顿时间和吞吐量结果。
Table 3 summarizes the pause time and throughput results for this application.
表1总结了可用的脚本 。
下面的表总结了我们对环境的所有更改。
The following table summarizes all the changes that we made in our environment.
下面的表总结了DB 2中可以的身份验证类型。
The following table summarizes the available DB2 authentication types.
表1总结在典型的UNIX系统上可用的进程间通信形式。
Table 1 below summarizes the forms of interprocess communication available on a typical UNIX system.
表1总结了本文进行的比较。
表4总结本节讨论的虚拟空间平台。
Table 4 summarizes the virtual Spaces platforms that were discussed in this section.
表3总结了条件和生成的样式。
The conditions and resulting style are summarised in Table 3.
表2总结了所选SAE工具的功能。
业务情景总结如表1中所示。
The business scenarios are summarized as follows in Table 1.
表1总结了不同的SA社区角色。
表3总结了这些特性之间的比较。
作为总结,表1列出了有关滚入的最佳实践。
表1总结死锁分析。
表1总结不同的JRules调用方法。
应用推荐