These operations work together to form a series of computations from source data to produce the result of a query.
这些操作共同构成了从源数据开始的一系列计算,最终得到查询结果。
We'll talk about where your data, query database, and authentication source should reside for various types of workloads and requirements.
讨论对于不同类型的工作负载和需求,应该把数据、查询数据库和身份验证源驻留在什么地方。
A query to this database could determine what source modules and data files must change if an existing data element is altered or a new data element is added.
如果现有数据元素发生了变化或添加了新数据元素,可通过查询此数据库来确定必须更改哪些源模块和数据文件。
Select the ID query item as the data item source, and click OK.
选择ID查询项作为数据项来源,然后单击ok。
Designing reports without data allows authors to add all the items required for the report before submitting a query to the data source.
无数据设计报表能让设计人员在向数据源提交查询之前添加报表所需的所有项目。
Select the SKILL_CAT query item as the data item source, and click OK.
选择SKILL_CAT查询项作为数据项来源,然后单击ok。
This package is used to query for data in the source system during the Load operation.
在Load操作过程中,此包用于查询源系统中的数据。
Choose the Profession query item as data item source, and select OK.
选择profession查询项作为数据项源,并选择OK。
You set up a data source object, provide the connection string and query text, and assign the id of the data source to the DataSourceId property of the GridView.
您只需建立一个数据源对象,提供连接字符串和查询文本,为GridView的DataSourceId属性分配数据源id。
Select Data Source (Manually build a SQL query), give the query a name, and click OK.
选择Data Source (ManuallybuildaSQLquery),指定查询名称并单击ok。
In the example above an MDX query (green nodes) is sent to an MDX data source for execution.
在上述示例中一个MDX查询(绿色节点)被发送到一个MD x数据源以便执行。
The query is compiled and execution of the query at the data source starts.
该查询首先经过编译,然后在那个数据源上开始执行。
It permits the use of 64 bit data source drivers and can leverage the 64 bit address space for query processing, metadata caching and data caching.
它允许使用64位数据源驱动程序,且可以利用64位满足查询处理、元数据缓存和数据缓存的空间。
We also needed to determine how to break up our one logical query into individual data retrieval activities for each data source.
我们还需要确定如何将一个逻辑查询拆散成针对每个数据源的单独数据检索活动。
Recall that each SHIP operator indicates a point in the execution plan at which a query or request is sent to a remote data source.
还记得吗,每个ship操作符都意味着在执行计划中有一个地方要将一个查询或请求转发到一个远程数据源。
These unmodified data source query subjects can then be referenced by other query subjects, calculations, and filters within the model.
这些保持不变的数据源查询对象可被模型中的其他查询对象、计算器、以及过滤器所引用。
The user or administrator can limit the degree to which asynchrony is used at a query or data source level, in order to limit its impact on local and remote resources.
用户或管理员可以在查询级或数据源级限制使用异步的程度,以限制异步对本地和远程资源所造成的影响。
The default allows a maximum of one SHIP/RPD for any data source within a single query to be asynchronous.
这个缺省值允许一个查询中的任何数据源最多只有一个SHIP/RPD为异步的。
It provides a DB2 relational model for the remote data and assists the federated engine in query processing by sending sub-queries to the remote data source.
它提供了远程数据的DB 2关系模型,并通过向远程数据源发送子查询以帮助联邦引擎实现查询处理。
The query optimizer will try to reduce the number of messages sent to the data source.
查询优化器将尝试减少发送到数据源的消息的数量。
If a back-end data source that provides data to a query is down and the optimizer chooses to satisfy the query using MQTs, the query will be executed.
如果向查询提供数据的后端数据源断开了,并且优化器选择使用MQT来满足查询,那么查询将会执行。
Check to see if each remote operator contains the maximum portion of the query that can theoretically be evaluated by a given data source.
检查每个远程操作符是否包含在理论上可由给定数据源计算的查询中的最大部分。
To process the query, the DB2 query compiler consults information in the DB2 federated database system catalog and the data source wrapper modules.
为了处理该查询,DB 2查询编译器查阅DB 2联邦数据库系统编目中的信息以及数据源包装器模块中的信息。
Defining a nickname over a remote view is useful in cases where you want to push down the query defining the remote view to the data source.
如果您想将定义远程视图的查询下推到数据源,那么定义远程视图的昵称会比较有用。
This server option specifies the maximum number of concurrent requests that can be simultaneously active on behalf of a single federated query to the given data source.
该服务器选项指定可代表一个联邦查询向特定数据源同时激活的并发请求的最大数量。
When this option is set, the query optimizer chooses the query execution plan that pushes the most work down to the data source as indicated by the PDA component.
当设置了该选项时,查询优化器选择按照PDA的指示将大部分工作下推到数据源的查询执行计划。
The query optimizer also tries to reduce the number of messages sent to the data source if the network is slow.
如果网络较慢,查询优化器还尝试减少发送到数据源的消息数量。
In other words, I create the query at one point, but I don't actually evaluate it (capture input values and query underlying data source) until I start to use the query results.
也就是说,我在某时创建了一个查询,但是我并没有真正地计算它(获取输入的值并查询背后的数据源),直到我开始使用这个查询的计算结果。
Give the query a name, "Query1" is used in this example, and select the data source you created earlier (for example, Tax1120DataSource).
为查询指定一个名称,本例中命名为“Query1”,并选择前面创建的数据源(比如Tax1120DataSource)。
The time taken by the federated system is comparable to the time taken when the query is executed directly against the data source for single-source queries.
联邦服务器所花费的时间是否与直接在数据源(涉及单个数据源的查询中的数据源)上执行查询时所花的时间相当。
应用推荐