数据库的统计值持有有关连接次数的信息,并聚合每个单独语句的额外统计值。
The database statistics hold information about connection times and aggregate additional statistics for each individual statement.
db 2提供了一个名为db 2pd的实用工具,用于收集db 2实例和数据库的统计信息。
Db2 provides a utility called db2pd for collecting for db2 instances and databases.
这些可更新的视图允许更新某些统计信息,从而研究假想数据库的性能,或者更新统计信息而不使用RUNSTATS实用程序。
These updatable views allow you to update certain statistical information to investigate the performance of a hypothetical database, or to update statistics without using the RUNSTATS utility.
数据挖掘旨在使用统计方法、人工智能和标准的数据库管理技术等等,从大型数据集中抽取模式。
Data mining seeks to extract patterns from large sets of data using, among other things, statistical methods, artificial intelligence, and standard database management techniques.
数据库管理器通过这些统计信息可以做出决策以提高SQL语句的性能。
With these statistics information database manager could make a decision that would increase the performance of an SQL statement.
高级查询统计的实现是基于查询日志数据库技术。
The implementation of advanced query statistics is based on the query log database technology.
该特性收集和存储与服务器、数据库、用户等有关的活动的统计信息。
This feature collected and stored statistics on activities involving the server, databases, users, and so on.
收集关于数据库的任何感兴趣的统计信息,并模拟一个简单的事务。
Gather any statistics about the database that are interesting, and simulate a simple transaction.
它允许捕捉请求的总数、总时间以及最差情况性能之类的统计值,还允许深入请求中数据库调用的信息。
It lets you capture statistics such as total counts, total time, and worst-case performance for requests, and it will also let you drill down into that information for database calls within a request.
某些情况下,reorgchk命令也可用来更新数据库统计,只需一个简单的命令,如清单11所示。
In some cases, the reorgchk command can also be used to update the database statistics with one simple command, as shown in Listing 11.
用于记录和报告针对Domino服务器上数据库进行的用户活动(客户机)的统计信息。
These were used to record and report statistics on user activity (clients) against databases on the Domino server.
此脚本统计当前数据库中所有文档的数量,值为字符串。
This script gets a count of all the documents in the current database as a string. Modify the script so that it looks like this
我当然不会违背每一个实例中的应用程序代码和设计,在本系列的第3部分中,我将展示监控数据库以进行性能统计的方法。
I would certainly not side against application code and design in every instance, and in Part 3 of this series, I present methods of monitoring databases for performance statistics.
一些信息放在数据库中,用来维持游戏的持久性;其他数据放在包含他的配置文件的目录或游戏统计信息数据库中。
Some information is captured in the database that maintains game persistence; other data is added into the directory that contains his profile or the game statistics database.
更新目录统计信息,这部分强调收集和维护最新数据库统计信息的重要性,缺少这项工作常常是导致许多性能问题的源头所在。
Updating catalog statistics, which emphasizes the importance of collecting and maintaining up-to-date database statistics, the lack of which is often the source of many of the performance problems.
数据库服务器不更新系统编目表中的统计信息。
The database server does not update the statistics in the system catalog tables.
例如,对于实现按需运行的报告(它从关系数据库收集统计信息,并向用户显示这些信息)来说,这就是一种好方法。
For instance, this would be a good approach to implementing a run on demand report that compiles statistics from the relational data and displays them to the user.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
A key element in the data model is the set of statistics gathered about the data contained in the database and stored in the system catalog tables.
这些数据库级的统计数字代表所有收集到的每个时间间隔内数据库调用指标的总计值。
These database-level statistics represent the aggregated values of all collected metrics for all calls to that database per interval.
每次运行数据规则时,都会测试规则定义,而且会在分析数据库中创建几个包含规则输出与规则统计信息的表。
Each time you run a data rule, a rule definition is tested, and several tables that contain the rule outputs and rule statistics are created in the analysis database.
相反,优化器将对查询中引用的每个数据库表收集最新的统计数据。
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.
它将问题分解开来,转变成离散的数据位,然后在它庞大的数据库中搜索与所处理的数据位在统计上频率最高的重合。
It decomposes the question put to it into discrete bits of data and then searches its vast data base for statistically frequent combinations of the bits it is working with.
在清单12中,您可以看到最终结果:一个将会报告所需数据库统计信息的应用程序。
In Listing 12, you can see the final result: an application that reports the desired database statistics.
但是它不能灵活地运行多个并发脚本,来在同一数据库中根据不同的表来更新统计数据。
However, it does not easily offer the flexibility of running multiple concurrent scripts to update statistics against different sets of tables in the same database.
程序会把核苷酸或者蛋白质的序列与序列数据库相比较,并计算符合的统计学意义。
The program compares nucleotide or protein sequences to sequence databases and calculates the statistical significance of matches.
然后它用它的双亲请求,根据连接的描述找到正确的数据库统计值,并根据sql键字符串找到语句统计值。
It then USES its parent request to find the right database statistics based on the connection's description, and to find statement statistics based on the SQL key string.
查询优化器使用数据库中的SYSSTAT目录视图来检索数据库对象的统计信息,并确定访问数据库的最佳方法。
The query optimizer USES the SYSSTAT catalog views in the database to retrieve the statistical information of the database objects and determine the best way to access the data.
当启用自动统计信息配置时,数据库活动的有关信息被收集并存储在查询反馈仓库中。
When automatic statistics profiling is enabled, information about database activity is collected and stored in a query feedback warehouse.
您还简要地了解了如何使用这些存储在数据库中的信息来获得统计信息,毫无疑问,这是问卷调查应用程序的关键。
You've also taken a quick look at how you can use the information that will be stored in the database to get statistical information—surely the point of a survey application.
例如,图22显示测试期间数据库的SQL活动统计数据。
For example, Figure 22 shows the SQL Activity statistics of your database during the test.
应用推荐