The catalog system would help us determine if we had duplicate books and even help us identify books we didn't know we had.
目录系统将帮助我们确定自己是否有重复的图书,甚至帮助确定我们还不知道自己拥有的图书。
I joined a team to prototype an online catalog for the library, sitting with librarians to learn how the card catalog system works.
我曾经加入一个团队来规划图书馆的在线编目系统,与图书管理人员坐在一起了解卡片编目系统是如何运作的。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
The system catalog does not identify which columns contain encrypted data, and the same column can include both encrypted and unencrypted values.
系统目录没有标识哪些列中包含加密的数据,同一列中可以同时包含加密和非加密数据。
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.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
In a relational language, such a query would require a join that might span several data tables and system catalog tables.
而在关系语言中,这种查询需要进行也许跨越了多个数据表和系统目录表的联接。
It USES the information from the statistics in the system catalog.
它使用来自系统编目中统计信息中的信息。
Ensure that there is sufficient free space on the system catalog and the system temporary tablespaces.
确保系统目录和系统临时表空间中具有足够的自由空间。
Reversion impact: the server takes care of dropping the system catalog changes, and the reversion goes through without any reversion messages.
降级影响:服务器终止系统目录变更,降级不显示任何降级信息就完成。
The database manager creates and maintains two sets of system catalog views that are defined on top of the base system catalog tables.
数据库管理器创建和维护两组系统编目视图,这些视图是在基本系统编目表之上定义的。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
Prior to DB2 9, most of the objects have only definer in the corresponding system catalog table or view.
在DB 29之前,大多数对象在相应的系统编目表或视图中具有惟一的定义者。
Keep DB2 statistics up-to-date: Without the statistics stored in the DB2 'system catalog, the optimizer will have a difficult time optimizing anything.
使DB 2统计信息保持最新:如果没有存储在DB 2系统目录中的统计信息,优化器在优化任何事物时都会遇到困难。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
To process the query, the DB2 query compiler consults information in the DB2 federated database system catalog and the data source wrapper modules.
为了处理该查询,DB 2查询编译器查阅DB 2联邦数据库系统编目中的信息以及数据源包装器模块中的信息。
An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists.
一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
The DB2 UDB system catalog (or simply "catalog") consists of a number of tables and views that are maintained by the database manager.
DB 2udb系统编目(或简称为“编目”)由很多表和视图组成,这些表和视图由数据库管理器来维护。
You can use the system catalog views to retrieve information about storage management objects such as table Spaces.
可以使用系统编目视图来检索关于表空间之类的存储管理对象的信息。
Update system catalog tables that the database server USES to optimize queries.
更新数据库服务器用于优化查询的系统编目表。
As the calculation of the savings is based just on statistics information in the system catalog, the calculation is fast.
由于对节省空间的计算只基于系统编目中的统计信息,所以这种计算速度很快。
To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.
为了确保包含系统编目表的分区能够快速恢复,应避免将用户表也放在那个数据库分区上。
A set of system catalog tables is created and maintained for each database.
对于每个数据库,都创建和维护一组系统编目表。
The database server does not update the statistics in the system catalog tables.
数据库服务器不更新系统编目表中的统计信息。
You can use the system catalog views to retrieve information about the dependencies that objects have on one another.
可以使用系统编目视图来检索关于对象相互之间依赖关系的信息。
This rule also applies to their definition — privileges associated with a global variable are also defined within the system catalog.
这条规则同样适用于全局变量的定义——与全局变量相关的权限也在系统编目中进行了定义。
Almost everything that is known about a database can be found in a metadata repository called the system catalog.
我们所知道的所有关于数据库的信息几乎都可以在称作系统编目的元数据存储库中找到。
In this article, I will show you, by way of working examples, how to retrieve useful information from the DB2 UDB system catalog.
在本文中,我将通过实际的例子展示如何从DB 2udb系统编目检索有用的信息。
When a database is created, SELECT privilege on the system catalog views is granted to PUBLIC (Figure 6).
在创建一个数据库时,系统编目视图上的SELECT权限便被授给PUBLIC(图6)。
The DB2 UDB system catalog is a collection of tables that describe database objects.
DB 2udb系统编目是描述数据库对象的表的集合。
Table 4 lists the respective federated objects and the DB2 system catalog views that can be used to locate the information.
表4列出了各个联邦对象以及可用于定位信息的DB 2系统编目视图。
应用推荐