介绍一种记录系统信息表的设计方法,并根据实践经验提出优化措施。
This paper introduces a method of designing information table in recording system and gives an optimized method used in actual applications.
由于联邦系统包括一个DB 2数据库,因此还可以在其中存储本地数据以及来自本地和远程表的相关信息。
Because the federated system includes a DB2 database, you can also store local data in it, as well as correlate information from both local and remote tables.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
由于联邦系统包含DB 2数据库,因此您还可以存储本地数据库,也可合并来自本地表和远程表的信息。
Because a federated system includes a DB2 database, you can also store local data, as well as combine information from local and remote tables.
逻辑文件系统还负责管理内核的打开文件表和每个进程的文件描述符信息。
The logical file system is also responsible for managing the kernel's open file table and the per process file descriptor information.
本文介绍的样例应用程序使用RESTAPI来管理您的虚拟系统信息—表1中显示的数据。
The sample application described in this article will use the REST API to manage your virtual systems information with the data that is shown in Table 1.
表4列出了各个联邦对象以及可用于定位信息的DB 2系统编目视图。
Table 4 lists the respective federated objects and the DB2 system catalog views that can be used to locate the information.
表3显示了AIX5l如何报告系统信息。
使用以下命令,根据模拟客户信息的系统目录创建一个表。
Use the following command to create a table based on the system catalog that simulates customer information.
System——存储系统表中的目录信息。
我们将在样式表中使用扩展函数 rdf.complete来收集关于系统中所有软件的信息。
We will use the extension function rdf.complete in our stylesheet to gather information about all of the software in the system.
可以通过查询两个系统表来获得这方面的信息:systables和sysindexes。
We can get this information by querying two system tables; systables and sysindexes. Here is the query.
使用以下命令,用来自系统目录的虚构信息向customer_info表填充数据。
Use the following command to populate the CUSTOMER_INFO table with data using dummy information from the system catalog.
也可以使用系统编目视图来检索关于NOT NULL、惟一、主键、外键和表检查约束的信息。
You can also use the system catalog views to retrieve information about NOT NULL, unique, primary key, foreign key, and table check constraints. For example.
这个附加的DB2功能包括对 DB2JDBCUniversal驱动程序、改进的系统表信息和 DB2DDL生成的支持。
The additional DB2 functionality includes support for the DB2 JDBC Universal driver, improved system table information, and DDL generation for DB2.
这些系统组件在证书管理注册表中查找信息。
These system components look for information in a certificate management registry.
移动设备需要查看、更新和处理来自电子邮件系统、日程表、数据库和其他数据源的信息。
Information from E-mail systems, calenders, databases and other data sources is needed on mobile devices for review, update, and processing.
如果计费系统事实表包含项目数量、支付的金额、到期金额,其相关的维度表可能包含产品信息、客户信息、以及时间或日期信息。
If a billing system fact table contains item quantity, amount paid, and amount due, its related dimension tables might include product information, customer information, and time or date information.
由于联邦系统包括一个DB 2数据库,所以还可以将本地数据存储在这个数据库中,也可以存储来自本地表和远程表的组合信息。
Because a federated system includes a DB2 database, you can also store local data in it, as well as combine information from both local and remote tables.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
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.
接下来,收集统计信息,这样系统表中会出现一些数据。
Next, collect statistics so that the system tables will be populated.
表1展示了所测试系统的详细配置信息。
Table 1 shows the configuration details of the system tested.
数据库服务器不更新系统编目表中的统计信息。
The database server does not update the statistics in the system catalog tables.
降低磁盘资源争用的另一种可行办法是将信息传递引擎数据表和日志移动到文件系统中其他更快的驱动器上,或者使用远程消息传递数据库。
Another possible way to reduce disk contention is to move the messaging engine data tables and logs to separate, faster drives on the file system or use a remote messaging database.
按照相同的方式,您都可以使用单独的拓扑表,来将物理系统的具体硬件信息对于程序隐藏起来。
In the same way, you can use separate topology diagrams to hide the details of the physical system from the application.
当将命令参数“SETPROFILE”添加到RUNSTATS命令时,将在表描述符和系统目录中注册或存储统计信息配置文件。
A statistics profile is registered or stored in the table descriptor and system catalogs when the command parameter "SET profile" is added to the RUNSTATS command.
传统上,其特点不适合表的信息存储在文件系统中。
Traditionally, information that doesn't naturally fit into tables has been stored in a file system.
我们没有通过w3授权系统提供完整的集成,所以用户注册表返回的信息量是有限的。
We were not providing full integration with the w3 entitlement system, so the amount of information that the custom registry was returning was limited.
图1代表了建于PaaS基础上的多企业信息系统的要素,它们包括。
Figure 1 represents the elements of a Multi-Enterprise Information System built on a Platform-as-a-Service foundation. They include.
应用推荐