所有操作符表使用的函数和操作符都必须在创建操作符表之前定义。
All the operators and functions used by an operator class must be defined before the operator class is created.
操作符表还声明索引方法在为一个索引字段选定该操作符表的时候要使用的支持过程。
The operator class also specifies the support procedures to be used by the index method when the operator class is selected for an index column.
其余的两个区域提供了关于访问计划的每个操作符以及查询所使用的表和/或索引的细节。
The remaining two sections provide details on each operator of the access plan, and the tables and/or indexes used by the query.
首先掌握一些操作符,随着经验逐渐丰富,您可以进一步扩展词汇表。
Begin with a handful of operators and expand your vocabulary as your experience grows.
表1总结了这些操作符及其语义。
该准则指定XANDOR操作符同时使用所有合适的xml索引访问给定表。
This guideline specifies that all applicable XML indexes be used together by a XANDOR operator to access the given table.
DictionaryLookup操作符为词汇表已有单词查找以下拼写
The Dictionary Lookup operator finds the following spelling for in-vocabulary words
表2列出了用来从perl脚本中调用系统命令的Perl核心函数和操作符。
Table 2 lists Perl core functions and operators leveraged to call system commands from within a Perl script.
用于取得联邦计划中的异步性的TQ操作符被称作异步表队列(Asynchronous Table Queues),在执行计划中显示为 ATQ。
The TQ operators used to achieve asynchrony in federated plans are called Asynchronous Table Queues, shown in execution plans as ATQ.
由最左边的SHIP操作符封装的远程查询被转发到存放US. sales表的远程数据源上。
The remote query encapsulated by the leftmost SHIP operator is sent to the remote data source at which the US.Sales table resides.
一个XMLRelationalMapping操作符(见图4下方的分支)的输出可以直接用于填充目标表。
The output from one of the XML Relational Mapping operators (shown on the lower branch of Figure 4) can feed the target table directly.
另一方面,如果使用EXISTS操作符,则将修改所有行,因为至少有一个itemNumber值存在于表子查询中。
On the other hand, if you use the EXISTS operator, all rows are modified because at least one of the itemNumber values exists in the table subquery.
现在通过以下步骤定义一个Targettable操作符,用于填充dwadmin. holdings表。
Now define a Target table operator to populate the DWADMIN.HOLDINGS table by completing the following steps.
表1显示了一些常用的regex操作符。
编辑XMLRelationalmapping操作符,删除目标表不需要的所有列定义。
Edit the XML Relational Mapping operator, deleting all column definitions except those required by the target table.
最后,从“FindDeviations”操作符输出端的右键菜单中选择“CreateSuitabletable…”,创建适当的目标表。
Finally, create a suitable target table by selecting "create suitable table..." from the right-click context menu of the output port of the "Find Deviations" operator.
访问计划操作符要么是必须在数据上执行的动作,要么是表或索引的输出。
The access plan operator is either an action that must be performed on data, or the output from a table or an index.
就我们此处的目的而言,只要理解异步是通过优化器明智地放置TQ(表队列)操作符而引入到联邦查询计划之中的就足够了。
For our purposes, it suffices to understand that asynchrony is introduced into a federated query plan by the optimizer's judicious placement of the TQ (Table Queue) operator.
要使用表子查询,需要使用SQL操作符将嵌入式查询与布尔表达式组合在一起。
To use a table subquery, you need to use an SQL operator to combine the embedded query with a Boolean expression.
在随后的数据流操作中,您将使用一个连接操作符确保整个XML账户记录(包含在info列中)被填充到目标数据仓库表中。
In a subsequent data flow operation, you'll use a join operator to ensure that full XML account records (contained in the INFO column) are fed into the target data warehouse table.
您可以连接表1中显示的元素(以及其他操作符)并加以组合使用,从而构建(非常)复杂的正则表达式。
You can string together the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regular expressions.
然后,它使用SHIP操作符读外表BAD_CREDIT,散列连接列的值,并检查为内表生成的查找表。
IT then reads from the outer table BAD_CREDIT using the SHIP operator, hashing the join column values, and checking in the lookup table generated for the inner table.
这个提取器操作符能从pmml模型(由associations操作符创建)提取关联规则并通过关系表结构提供这些规则。
The extractor operator will extract the association rules form the PMML model created by the Associations operator and provides them in a relational table structure.
在编辑器下方的视图中,ExecutionStatus选项卡被选中并且在这个视图的右侧,还可以看见最后一个操作符(即Targettable操作符)的表输出。
In the view below the editor, the Execution Status TAB is selected and on the right part of the view, you can see the table output of the last operator, that is, the Target table operator.
通过使用唯一的术语编号将表连接起来,为TableJoin操作符指定条件,术语编号为文本分析结果集中的SKILL_ID,和位于分类表中的TERM_ID。
Specify the condition for the table Join operator by connecting the tables using the unique term number, which is SKILL_ID in the result set of the text analysis and TERM_ID in the taxonomy table.
您可以连接和结合表1中的基本操作符(以及其他操作符)并进行组合来构建(非常)复杂的regex。
You can concatenate and combine the primitives in Table 1 (and other operators) and use them in combination to build (very) complex regexes.
其中一个操作符(图1中下方的分支)为一个GroupBy操作符提供输入,后者执行目标表的两个列所需的聚合。
One of these operators (shown on the lower branch in Figure 1) feeds a Group by operator that performs the aggregations required by two of the target table's columns.
将来自xmlRelationalmapping操作符的适当的源列映射到该表的目标列,如图22所示。
Map the appropriate source columns from the XML Relational Mapping operator to the target columns of the table, as shown in Figure 22.
例如,如上一代码清单所示,In操作符选择bigdog .products表中由QuietBeachIndustries生产的所有行。
For example, this was shown in the previous code listing, where the in operator selected all rows from the bigdog.products table that were produced by Quiet Beach Industries.
其中一个操作符(图4中下方的分支)为一个GroupBy操作符提供输入,后者执行表1中所示的聚合。
One of these operators (shown on the lower branch in Figure 4) feeds a Group By operator, which performs the aggregations shown in Table 1.
应用推荐