向下钻取数据库事务问题的详细信息。
场景2:向下钻取数据库事务问题的详细信息。
Oracle游标可以被声明、打开、取数据和关闭。
Oracle cursors can be declared, opened, fetched from, and closed.
一个从多个API拉取数据的mashup可能会要求用户名和密码。
A mashup that pulls data from multiple APIs might require user names and passwords.
数据用户主要查看汇总数据还是需要一种交互式体验(向下和向上钻取数据)?
Will users of the data mainly look at summarized data or require an interactive experience (drill up and down through the data)?
注意,对于游标声明,该值为打开游标的次数,不包括该游标取数据的次数。
Note that in case of a cursor declaration the value is the number of times the cursor was opened. It does not include the number of fetches made by the cursor.
进入AmazonSQS队列之后,可以使用有权访问该队列的应用程序拉取数据。
Once in the Amazon SQS queue, the data can be pulled down by another application with the rights to that queue.
当单独使用WebSphereDataStage来实现时,从数据源取数据集所花费的时间在作业的总体执行时间中占较大比例。
Fetching the data sets from the data sources constitutes a reasonable amount of the overall elapsed time of the job when implemented using WebSphere DataStage alone.
使用拉取方式,要想达到完整的数据一致性以及很高的网络性能是很困难的。
With the pull approach, achieving total data coherence with high network performance is very difficult.
本系列的后续文章将展示如何使用穿透钻取定义完成一些更复杂事情,比如动态调用数据挖掘。
The upcoming articles of this series show how to do more powerful things with drill-through definitions, such as invoking data mining dynamically.
之后,我们使用这个由向下钻取获得的数据项uid在恰当的类别内创建一个配置文件项。
We then create a profile item in the appropriate category using the data item UID obtained from the drill-down.
建立一个集合就像给它取个名字一样容易,如“肯最喜欢的数据分析扩展”或“万圣节主题”,当然接下来就是选择您想要收集的附加组件了。
Creating a collection of your own is as easy as giving it a name, like "Ken's Favorite Data Analysis Extensions" or "Halloween Themes", and choosing what add-ons you'd like in the collection.
向下钻取的方法是单击数据库图标,然后单击DatabaseDiagnostics,见图28。
To drill down, click the database icon, and click Database Diagnostics, as shown in Figure 28.
这里的答案是对您感兴趣的数据类别使用钻取(drilldown)资源。
The answer here is to use the drilldown resource for the data category you are interested in.
图4中的设置触发一个取元数据操作,如下所示。
The Settings in figure 4 trigger a metadata fetch as follows.
由于从数据库代理程序直接调度非预取I/O,因此非预取 I/O不受 NUM_IOSERVERS 约束。
Non-prefetch I/Os are scheduled directly from the database agents and as a result are not constrained by NUM_IOSERVERS.
PREFETCHSIZE指定在执行数据预取时将从表空间读取的页数。
PREFETCHSIZE specifies the number of pages to be read from the table space when data prefetching is being performed.
最终的结果是,应用程序永远不用等数据,因为数据总是在本地内存中等待应用程序来取。
The end result is that the application is never waiting for data as it is always available in local memory to be fetched.
您可以继续向上或向下钻取以便更好地理解您的业务数据。
You can continue drilling up and down to better understand your business data.
在连接到AMEE后,我们执行一个向下钻取的查询来获得针对我们想要存储的信息的正确的数据项。
After making the connection to AMEE, we perform a drill-down query to get the correct data item for the information we want to store.
接下来的文章将讨论一些更高级的话题,例如钻取、frameworkmanager中度量指标的使用以及从Cognos报告中动态调用数据挖掘。
The follow-up articles will discuss more advanced topics, such as drill-through, the use of metrics in the framework manager, and the dynamic invocation of data mining from Cognos reports.
数据库中的表空间仅仅配置了一个容器,以致无法进行预取。
The table spaces in the database are set up with only one container each so that prefetching cannot take place.
比如 10 米乘 10 米的网格,取每个交叉点的值(共有 100组)就形成一个光栅数据集。
Taking a 10-meter-by-10-meter grid and making one observation for each intersection (100 observations) would constitute a raster dataset.
从产生的结果数据集检索(取)数据。
平面文件适配器拾取密码文件,并将其转换为数据处理程序要求的数据结构(补充有关目标服务的信息)。
The flat file adaptor picked up the password file and converted into a data structure required by the data handler, complete with information about the target service.
如果要分析的实例数据量较小,您的向上钻取和向下钻取请求的响应性会很好。
With a small amount of instance data to analyze, your drill-up and drill-down requests will be very responsive.
定义另一个维度loanstartdate,这将有助于分析每年的数据并支持向下钻取每月和每天的数据。
Defining another dimension, the loan start date, will help analyze yearly data and enable the drill-down to monthly and daily data.
用于数据库的I/O服务器(预取器)的数目可以使用 NUM_IOSERVERS 数据库配置参数进行配置。
The number of I/O servers (prefetchers) for a database can be configured using the NUM_IOSERVERS database configuration parameter.
数据分页功能——DB 2 command类现在有一个ExecutePageReader方法,该方法使应用程序可以从数据库中取一组特定的行。
Data paging capability — the DB2Command class now has an ExecutePageReader method that enables applications to fetch a specific set of rows from the database.
当数据库管理器确定顺序I/O是适当的,并且确定预取操作可能有助于提高性能时,会使用预取操作(通常是大型表扫描)。
Prefetching is used when the Database Manager determines that sequential I/O is appropriate and that prefetching can help to improve performance (typically large table scans).
应用推荐