操作完成之后,关闭查询表测试窗口。
这种物化查询表中的数据是由用户维护的。
The data in this type of materialized query table is maintained by the user.
这种物化查询表中的数据是由系统维护的。
The data in this type of materialized query table is maintained by the system.
为了支持这样的场景,现在可以创建查询表。
请参阅关于物化查询表的小节。
下一步是定义查询表。
定义补充表和查询表属性。
HTM为此提供两个内置特性:定制的属性和查询表。
HTM offers two built-in features to this end: custom properties and query tables.
然后,管理员把查询表定义部署到服务器上。
The administrator then deploys the query table definition onto the server.
使用查询表添加元数据
这里会生成一条sql语句,用于查询表中被选中的列。
A SQL statement is generated for querying the selected columns in the table.
查询表定义已经创建了,在本文的项目交换文件中提供。
The query table definitions have been created already and are part of the project interchange file provided by this article.
另一种方法是使用查询表策略,这依赖于编码表。
An alternative approach is to use a lookup table strategy that relies on code tables.
但是,在访问在线服务之前,在查询表中应该准备一些关键字。
But before accessing the online service, some keywords should be prepared in the query table.
该表强调了任务数据和使用查询表的补充数据的连接。
This table also highlights the join of task data with supplemental data using a query table.
这个测试案例使用两个用户来模拟查询表申明方法中的并发存取。
This test case uses two users to simulate concurrent access in the query table claim method.
首先创建一个补充查询表,供随后创建的复杂查询表引用。
A supplemental query table is created first, and is referenced by the composite query tables created thereafter.
通过查询emp物化查询表发现,它现在已经填入了数据。
A query executed against the EMP materialized query table shows that it is now fully populated with data.
例如,屏幕标签查询表的XML文件的格式可能像下面这样。
For example, the format of an XML file of screen labels lookup table might be the following.
不支持范围簇表(RCT)、物化查询表(MQT)和有类型的表。
Not supported are range clustered tables (RCT), materialized query tables (MQT), and typed tables.
物化查询表可以显著提高查询的性能,尤其是提高复杂查询的性能。
Materialized query tables can significantly improve the performance of queries, especially complex queries.
另外,支持基于查询表的属性、多次出现的属性、属性组和关系属性。
Furthermore, support for lookup table-based attributes, multi-occurrence attributes, attribute groups, and relationship attributes comes out of the box.
BPED b表包含补充数据,说明使用查询表方法声明的分类功能。
This table contains the supplemental data to illustrate the sorting capability of the claim with the query table method.
重试仅用于查询表执行时出现并发异常且查询表需要重新申明的情况下。
The retry is used in case a concurrency exception does occur in the query table execution and the query table engine needs to retry the claim operation.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
包含在物化查询表中的数据来自定义物化查询表时所基于的一个或多个表。
The data that is contained in an MQT is derived from one or more tables on which the materialized query table definition is based.
开发人员可以使用QueryTableBuilder工具创建查询表定义。
A developer can create a query table definition using the query table Builder tool.
例如,可以添加一个查询表,把每个州和州的两位数字ZIP代码关联起来。
For example, you might add a new lookup table associating each state and its two-digit ZIP code.
应用程序不应该是一个已经实现的产品,而应该是一个说明使用查询表方法申明的样例。
The application should not be seen as a production ready implementation, but rather a sample illustrating the use of the claim with the query table method.
要改进性能,联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。
To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.
应用推荐