• An important part of SDO is to make data manipulation easier. So once a data Graph is constructed, it is important to be able to traverse the tree and to access its elements with the SDO API.

    SDO个很重要特点就是使数据操作变得更容易了,因此一旦构造个数据重要的一点就是需要使用SDOAPI树结构访问其中元素

    youdao

  • After you collect those statistics, you get the new access plan graph shown in Figure 10.

    收集了这些统计数据之后得到如图10所示访问计划

    youdao

  • So far, you learned how to create metadata, then populate and access a data graph corresponding to the metadata.

    到目前为止已经了解了如何创建数据,然后填充访问与元数据对应数据

    youdao

  • You can obtain the statistics from the table descriptor of the table node in the underlying access path graph.

    可以基础访问路径中的节点描述符处获得统计信息

    youdao

  • There is no FETCH or table node shown in the access path graph because it is an index-only scan.

    因为一个唯一索引扫描,所以访问路径显示FETCH节点

    youdao

  • To see the table descriptor, right-click the table node in the access path graph.

    为了查看描述符请右键单击访问路径节点

    youdao

  • The rest of this section takes you through the access path graph one more time from the data flow perspective so that you can gain a full understanding of the performance aspect of query execution.

    其余部分数据观点向介绍访问路径以便可以查询执行性能方面获得充分理解

    youdao

  • This article described the basic concepts of access paths and how to read an access path graph.

    本文描述访问路径基本概念以及如何解读访问路径图。

    youdao

  • It includes how to understand the problem query better by using the visual AIDS provided by query formatting, annotation, reports, and the access plan graph.

    其中包含如何通过使用查询格式化注释报告访问计划图来更好地理解问题查询。

    youdao

  • Data flows from the bottom up (as displayed in the graph) and is processed by operation nodes in the access path graph.

    数据往上流动(访问路径)通过访问路径图上操作节点处理

    youdao

  • Designing a data graph could be the subject of another article on its own as there are many scenarios to consider when building access to a data source.

    因为建立数据源访问考虑很多种情况设计数据本身可以作为另一文章主题

    youdao

  • From the access plan graph, you can see what choices the optimizer has made regarding how the query will be processed and the rationale for those choices.

    访问计划中,可以看到优化器如何处理查询作出何种选择以及理由

    youdao

  • There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.

    访问计划索引节点上会一个RUNSTATSTIMESTAMP属性,它表示收集统计数据时间

    youdao

  • One of the powerful features of SDO is the flexibility applications have in how they access data within a graph.

    SDO强大功能之一应用程序可以图形灵活地访问数据

    youdao

  • In Figure 2, the descriptor for the table node and the descriptor for the TBSCAN node are shown to the left of the access path graph.

    2中,节点描述TBSCAN节点的描述符显示访问路径左侧

    youdao

  • After creating the three new indexes, you get the new access plan graph shown in Figure 13.

    创建三个索引之后13中的访问计划

    youdao

  • The SQL statement in Listing 5 creates the access path graph shown in Figure 5.

    清单5中的sql语句创建如图5所示访问路径

    youdao

  • The SQL statement in Listing 4 creates the access path graph shown in Figure 4.

    清单4中的sql语句创建如图4所示访问路径

    youdao

  • The SQL statement in Listing 6 creates the access path graph shown in Figure 6.

    清单6中的sql语句创建如图6所示访问路径

    youdao

  • The SQL statement in Listing 8 creates the access path graph shown in Figure 8.

    清单8中的sql语句创建如图8所示访问路径

    youdao

  • The SQL statement in Listing 3 creates the access path graph shown in Figure 3.

    清单3中的SQL语句创建如图 3所示访问路径

    youdao

  • Basically, when an SDO client needs to retrieve data, it USES the DMS to require a data graph. The DMS manages the data source access and creates a graph with the information received.

    基本上SDO客户机需要检索数据时,使用DMS请求数据,DMS负责管理数据源访问根据接收到的信息来创建个图,通常这个图是一个分层的树结构,其中包含了几个数据对象。

    youdao

  • The description of each operation includes a Query Tuner access path graph that explains its operational semantics.

    操作描述包括一个解释操作语义QueryTuner访问路径

    youdao

  • From the access plan graph in Figure 6, you can do some initial performance analysis.

    6访问计划可以一些初始性能分析

    youdao

  • Since Neo4j is a database, each access to the graph structure - read, write, and traversal - are managed by an ACID transaction system.

    由于Neo4j是个数据库,因此对图形结构访问——遍历都是通过ACID事务系统进行管理的。

    youdao

  • Similarly, the last leg in the access path graph is evaluated eight times, once for each record produced by the first NLJOIN node.

    同样访问路径最后一步要评估8通过第一NLJOIN节点产生记录都要评估次。

    youdao

  • From this new access plan graph, you can see the following.

    张新访问计划图中可以看到以下内容。

    youdao

  • So far, you've seen how you can analyze and tune a problem query with the assistance of Optim query Tuner capabilities, such as query annotation, access plan graph, and so on.

    到目前为止已经看到如何在OptimQueryTuner各项功能帮助下分析问题查询这些功能包括查询注释访问计划图等等。

    youdao

  • From the access plan graph in Figure 6, you can see the following.

    6访问计划可以看到以下内容。

    youdao

  • Applications can traverse the graph using the generic SDO API, they can access data using the object model defined by the content model, or they can use XPath to extract data from a DataGraph.

    应用程序可以使用普通SDOAPI图形它们可以使用内容模型定义对象模型访问数据或者使用XPathDataGraph提取数据。

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定