再次查询总结表,仍然没有返回任何数据。
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总结了每种解决方案的优点及缺点。
Table 3 summarizes the advantages and disadvantages of each approach.
表3总结了此应用程序的停顿时间和吞吐量结果。
Table 3 summarizes the pause time and throughput results for this application.
下面的表总结了我们对环境的所有更改。
The following table summarizes all the changes that we made in our environment.
表2总结和比较了带注释的XML模式和用于分解的xmltable函数。
TABLE 2 summarizes and compares the usage of annotated XML schemas with the XMLTABLE function for shredding.
表2总结了可以应用于线程的各种COBOL语言元素的范围。
Table 2 summarizes the scope of various COBOL language elements that can be used with multithreading.
下面的表总结了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总结了这两个通信渠道之间的主要区别。
Table 1 provides a summary of the key differences between the two communication channels.
表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工具的功能。
表5总结了URI模式和HTTP方法,以及发出了的哪些事件。
Table 5 summarizes the URI pattern and HTTP method, as well as which event gets emitted.
业务情景总结如表1中所示。
The business scenarios are summarized as follows in Table 1.
表1总结了不同的SA社区角色。
表3总结了这些特性之间的比较。
作为总结,表1列出了有关滚入的最佳实践。
表1总结了这些转储文件类型的区别。
Table 1 summarises the differences among the dump-file types.
应用推荐