如果数据源具有类似的数据模型,并仅需要执行简单的转换操作,那么其成本可能很低。
The costs can be low if the data sources have similar data models and only simple transformation operations are required.
这些操作共同构成了从源数据开始的一系列计算,最终得到查询结果。
These operations work together to form a series of computations from source data to produce the result of a query.
如果数据源可以处理谓词之类的基本操作,那么考虑将该选项设为'Y '。
Consider setting this option to 'Y' if the data source can handle basic operations such as predicates.
这个属性表示将在那里执行操作的服务器或数据源的名称。
This property denotes the name of the server or the remote data source where that operation will be performed.
一旦建立了数据源,就可以操作它而不用关心连接的语义了。
Once you have a data source, though, you can operate on it without regard to the connection semantics.
在一个企业程序中,数据源对象是通过JNDI查找操作来获得的。
Typically, in an enterprise application data source objects are retrieved through a JNDI lookup operation.
每一个节点上显示的数字都是优化器对基础数据源或操作节点的基数的估计。
The number shown in each node is the optimizer's estimate for the cardinality of the underlying data source or operation node.
这是一个很强大的概念,因为它使客户可以对数据进行分类,并在需要时应用新的关系,而这些根本不用操作原始数据源。
This is a powerful concept because it enables clients to categorize data and apply new relationships as needed without manipulating the original data source.
数据问题可能在客户的操作数据源中存在多年。
Data problems may have existed in the customer? S operational data sources for years.
如果有数据操作节点,则请提升数据源名称属性,因为此属性在各个环境(开发、测试、生产等)中可能并不相同。
If there are database manipulating nodes then promote the data source name property as it might not be same across various environments (development, test, production, etc).
它至少应该与源操作系统中的数据一样好。
It should be at least as good as the data in the source operational system.
支持对此集成视图的写访问时,联合服务器必须将各个源中的数据操作同步到逻辑工作单元中。
When supporting write access to this integrated view, the federation server must synchronize the manipulation of data in the various sources into a logical unit of work.
有些属性,例如 COLLATING_SEQUENCE,会影响哪些操作可以下推到数据源来执行。
Some attributes, such as COLLATING_SEQUENCE, can affect which operations can be pushed down to a data source for evaluation.
“下推”操作,即让操作发生在远程数据源,是很有益的。
"Pushing down" an operation — allowing it to take place on the remote data source — can be very beneficial.
当绑定数据源支持更新时,GridView能够自动执行数据操作,从而提供真正的出盒解决方案。
When the bound data source supports updates, the GridView can automatically perform data operations, thus providing a real solution right out of the box.
SQLRelay连接到所有数据源并在所有操作系统上具有良好的客户端库。
SQL Relay connects to all of our datasources and has good client libraries on all operating systems.
该选项表明联邦服务器是否应该考虑下推对一个关系数据源的任何SQL操作。
This option indicates whether the federated server should consider pushing down any SQL operation for a relational source.
只有运行时期间存在源数据时,才会执行任何对可选源数据进行操作的转换,否则,将不会发生转换。
Any transformations operating over optional source data will only execute if the source data exists during runtime. Otherwise, the transformation will not occur.
在这个例子中,如果目标和源数据表有匹配的行,就实行更新操作。
In this example, and update occurs if the target and source have matching row.
本文的下载小节包含一个db2脚本,该脚本创建必要的操作型(源)表和数据仓库(目标)表。
The Downloads section of this article contains a DB2 script that creates the necessary operational (source) table and data warehouse (target) tables.
系统管理数据源支持哪些操作,哪些操作必须由联合服务器提供补偿机制?
What operations are supported by the systems managing data sources and which have to be compensated by the federation server?
对于快速变化的事务数据,操作必须进入物理源中对其进行操作。
For rapidly changing transactional data, the action must go to the physical source to manipulate it.
因为联邦中的每个数据源一直在自主操作,所以维持联邦数据库与它所联邦的源之间的一致性是一个相当大的挑战。
Because each data source within a federation continues to operate autonomously, maintaining consistency between the federated database and the sources it federates is a significant challenge.
事务:为所有关键主控数据提供集中创作的操作源(记录系统)——而且主控数据始终保持一致、准确和完整。
Transaction: Provides the operational source (system of record) with central authoring for all key master data — and the master data is consistent, accurate and complete at all times.
准备数据转移操作的下一步是把源数据库SAMPLE编目为远程数据库。
The next step in preparing your data movement operation is cataloging the source database SAMPLE as remote database.
取决于操作的不同,允许在远程数据源上执行操作可能有助于查询的整体性能。
Depending on the operation, allowing it to be evaluated on a remote source might help the overall performance of the query.
根据总体查询执行计划,将随后对数据源执行各个子操作。
According to the overall query execution plan, the sub operations are then applied at the sources.
根据总体查询执行计划,将随后对数据源执行各个子操作。
According to the overall query execution plan, the sub operations are then applied at the sources.
应用推荐