Nickname - the nickname is a local alias for the remote table in the source database.
别名-别名是源数据库中的远程表的本地别名。
A nickname can be defined over a remote view just as it can be defined over a remote table.
可以定义远程视图的昵称，就像定义远程表的昵称一样。
Defining indexes on the remote table on the data store might sometimes improve query performance.
在数据源上的远程表上定义索引有时候可以提高查询性能。
The number of distinct values, and the maximum and minimum values of each column of a remote table
远程表中每个列中不同值的个数、最大值和最小值
First a cursor is defined that reads all rows in the remote table using the nickname created above.
首先，定义一个游标，它使用上面创建的别名读取远程表中的所有行。
Click on Add, and fill in the remote schema (public) and remote table name (DELIM1), then click on OK when finished.
单击add，然后填充远程模式(public)和远程表名(DELIM1)，完成之后单击ok。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
指定了别名，就可以在目标数据库中用sql语句查询远程表，就像查询任何本地表一样。
In WebSphere Federation Server Version 9.1, a nickname cannot be created over a remote table or view that contains an XML-type column.
在WebSphereFederationServer 9.1内，昵称不能在包含xml类型列的远程表或视图之上创建。
If the relational data resided in a remote DB2 or OEM database, we would simply create a nickname for this remote table in our database.
如果关系数据驻留在远程DB 2或OEM数据库中，那么我们将简单地为我们数据库中的这个远程表创建一个别名。
The most significant of the newly-retrieved nickname statistics are the minimum and maximum values stored in each column of a remote table 1.
新获取的昵称统计信息中，最重要的是存储在远程表的每个列中的最小值和最大值1 。
A better solution is to define a nickname over each remote table, and to define views over these nicknames on the federated server if necessary.
更好的解决办法是定义每个远程表的昵称，必要的时候在联邦服务器上定义这些昵称上的视图。
Creating an "existing table" creates a proxy table, then retrieves and stores metadata from a remote table and places the metadata into the proxy table.
创建“现有表”时，首先会创建一个代理表，然后检索和存储远程表中的元数据，并将该元数据放入到这个代理表中。
Given the remote table definitions for items and suppliers, you can declare check constraints on the corresponding nicknames with the following commands.
给items和suppliers的定远程表定义，便可以用以下语句声明相应昵称上的检查约束。
In an application, a nickname brings back data from a remote table, view, or date set. However, the following conditions will cause such an application to fail.
在应用程序中，别名可以从远程表、视图或数据集中取回数据。
This statement creates both a remote table on the data source, referred to by the server name CREDIT_SERVER, as well as a nickname referring to this new remote table.
该语句在被称作CREDIT_SERVER的远程数据源上创建一个远程表，同时创建一个引用这个新的远程表的昵称。
Once the statistics are gathered for a nickname, they are not automatically modified when the remote statistics are updated on the data source for the corresponding remote table.
如果为一个昵称收集了统计信息，那么在数据源上对相应远程表的远程统计信息进行更新时，这些统计信息不会自动更新。
Please note that this table is accurate as of the time of publication, but that work to discover and collect more remote statistics is ongoing.
记住，在本文发表之际，这个表还是准确的，但是发现和收集更多远程统计信息的工作还在继续。
After this information is added successfully, the remote machine will be listed in the location table (Figure 23).
在这些信息被成功添加之后，远程机器将在位置表中被列出，如图23所示。
A nickname is a representation of a table, view, or any other form of data set residing on the remote data source.
别名是远程数据源上驻留的数据集的表、视图或任何其他形式的数据的表示。
Assume that there is a LINEITEM fact table on one remote source and a PART dimension table on another.
假设在一个远程数据源上有一个lineitem事实表，在另一个远程数据源上有一个part维表。
Table 1 provides an overview of contributors and contributed data for caching in remote caches.
表1提供了关于提供者及其提供的数据(供在远程缓存中进行缓存时使用)的概述。
Data modeling: a wrapper is responsible for mapping the data representation of remote query results into the table format as required by the federated engine.
数据建模：包装器负责将远程查询结果的数据表示映射为联邦引擎所要求的表格式。
That means these steps can generally be used to create a nickname for a table in a remote database.
这意味着这些是为远程数据库中的表创建别名的通用步骤。
The CREATE REMOTE SERVER statement stores the login data for the back-end server in the SYS_SERVER table.
CREATEREMOTESERVER语句在 SYS_SERVER表中存储后端服务器的登录数据。
The query on the remote Asia.Sales table will begin when the one on the middle leg is complete and has delivered its entire result set to the federated server.
当中间那条查询执行完毕并且已经将整个结果集提交给联邦服务器时，才开始执行对远程表 Asia.Sales 的查询。
Federated asynchrony can be recognized in execution plans by the existence of the new ATQ (Asynchronous Table Queue) operator directly above SHIP operators corresponding to remote operations.
通过对应于远程操作的SHIP操作符上的AT Q (asynchronousTableQueue)操作符，可以识别执行计划中的联邦异步。
The remote query encapsulated by the leftmost SHIP operator is sent to the remote data source at which the US.Sales table resides.
由最左边的SHIP操作符封装的远程查询被转发到存放US. sales表的远程数据源上。
By calling AirportMapping.iata , you are free to change the datasource from a local table to the remote GeoNames service while preserving the client-side interface.
而通过调用AirportMapping . iata，则就可以随意更改本地表和远程GeoNames服务中的数据源，并保证客户端界面不受影响。
This is a hash join between the CUSTOMERS table, local to the federated server, and the BAD_CREDIT nickname that references a remote Oracle table.
这是表CUSTOMERS与昵称BAD_CREDIT之间的一个散列连接(hash join)，前者在联邦服务器本地，后者引用一个远程oracle表。
The REVIEW table exists on the SQL Server 2005. Its XML data is serialized into a BLOB using the following remote view.
表review位于SQLServer 2005上，其XML数据通过如下所示的远程视图序列化进blob。
应用推荐