包括事实表和维表的设计,元数据结构的设计,及统计库功能模块的设计和实现。
The works include the design of fact tables and dimension tables; the design of metadata; and the design and development of function modules of the StatDB.
py程序使用开源库J FreeChart为统计结果绘制图表。
Dbstats.py program USES open source library JFreeChart to draw charts from statistics results.
例如,对于实现按需运行的报告(它从关系数据库收集统计信息,并向用户显示这些信息)来说,这就是一种好方法。
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.
这些可更新的视图允许更新某些统计信息,从而研究假想数据库的性能,或者更新统计信息而不使用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.
该特性收集和存储与服务器、数据库、用户等有关的活动的统计信息。
This feature collected and stored statistics on activities involving the server, databases, users, and so on.
如果没有这些统计信息,数据库管理器可能会做出对sql语句的性能产生不利影响的决定。
Without these statistics, the database manager could make a decision that would adversely affect the performance of an SQL statement.
更新目录统计信息,这部分强调收集和维护最新数据库统计信息的重要性,缺少这项工作常常是导致许多性能问题的源头所在。
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.
世卫组织通过全球卫生观察站网络门户以及负责提供大量疾病和卫生指标的统计数据库,公布其数据和分析结果。
WHO makes its data and analyses accessible through the Global Health Observatory portal as well as databases that provide statistics on a wide range of diseases and health indicators.
相反,优化器将对查询中引用的每个数据库表收集最新的统计数据。
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query.
一些信息放在数据库中,用来维持游戏的持久性;其他数据放在包含他的配置文件的目录或游戏统计信息数据库中。
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.
它编制统计数据,出版文集以及促进数据库、地图和其他资源的使用。
It compiles statistics, publishes papers and facilitates access to databases, maps and other resources.
数据库管理器通过这些统计信息可以做出决策以提高SQL语句的性能。
With these statistics information database manager could make a decision that would increase the performance of an SQL statement.
这些数据库级的统计数字代表所有收集到的每个时间间隔内数据库调用指标的总计值。
These database-level statistics represent the aggregated values of all collected metrics for all calls to that database per interval.
在清单12中,您可以看到最终结果:一个将会报告所需数据库统计信息的应用程序。
In Listing 12, you can see the final result: an application that reports the desired database statistics.
收集关于数据库的任何感兴趣的统计信息,并模拟一个简单的事务。
Gather any statistics about the database that are interesting, and simulate a simple transaction.
然后它用它的双亲请求,根据连接的描述找到正确的数据库统计值,并根据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.
高级查询统计的实现是基于查询日志数据库技术。
The implementation of advanced query statistics is based on the query log database technology.
影响sql语句性能的另一个重要因素是数据库统计。
Another important factor that affects SQL statement performance is database statistics.
其中包括统计数据库和图书馆数据库。
These include statistical databases and the library database.
数据库的统计值持有有关连接次数的信息,并聚合每个单独语句的额外统计值。
The database statistics hold information about connection times and aggregate additional statistics for each individual statement.
例如,图22显示测试期间数据库的SQL活动统计数据。
For example, Figure 22 shows the SQL Activity statistics of your database during the test.
启动时,动态统计数据集合可通过确保您拥有最新表统计信息来帮助提高数据库性能。
When enabled, automatic statistics collection helps improve database performance by ensuring that you have up-to-date table statistics.
在版本4.1.0.1中,您可以收集详细的数据库细目统计信息,不仅针对事务,也可针对单个sql语句。
In Version 4.1.0.1, you can gather detailed database breakdown statistics, not just for the transaction but for individual SQL statements.
当启用自动统计信息配置时,数据库活动的有关信息被收集并存储在查询反馈仓库中。
When automatic statistics profiling is enabled, information about database activity is collected and stored in a query feedback warehouse.
因此,获得最佳计划的准确性完全取决于关于查询中所涉及的数据库对象的最新统计信息。
So, the accuracy of getting an optimal plan is entirely dependant on the up-to-date statistical information about the database objects involved in the query.
查询优化器使用数据库中的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.
提示:定期更新数据库统计数据。
统计数据库还用于生成惟一的交易id。
The statistics database is also used to generate unique trade IDs.
这份记录其实也并不完善,特别是对于1988年EM- DAT数据库建立之前的统计。
The records are also incomplete, particularly for years prior to EM-DAT's establishment in 1988.
后库和货架管理:自动地统计存货并通知相关人员及时补充(后库或店面内的)货架,以避免库存耗尽现象。
Backroom and shelf management: Automating inventory count and notifying staff to refill shelves (back room or in store) to avoid out-of-stock situations.
应用推荐