Because a federated system includes a DB2 database, you can also store local data, as well as combine information from local and remote tables.
由于联邦系统包含DB 2数据库,因此您还可以存储本地数据库,也可合并来自本地表和远程表的信息。
This means you need to design the database system in such a way that you divide the database tables into modularized and optimized partitions of two types — static and dynamic.
这就意味着您需要以这样的方式设计数据库系统,即将数据库表划分成两种类型——静态和动态——的模块化、最优化部分。
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.
数据模型中的关键元素是一组统计信息,该统计信息收集了有关数据库中所包含的数据和系统目录表中所存储的数据的信息。
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.
由于联邦系统包括一个DB 2数据库,因此还可以在其中存储本地数据以及来自本地和远程表的相关信息。
Update system catalog tables that the database server USES to optimize queries.
更新数据库服务器用于优化查询的系统编目表。
The database server does not update the statistics in the system catalog tables.
数据库服务器不更新系统编目表中的统计信息。
A set of system catalog tables is created and maintained for each database.
对于每个数据库,都创建和维护一组系统编目表。
The database manager creates and maintains two sets of system catalog views that are defined on top of the base 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.
降低磁盘资源争用的另一种可行办法是将信息传递引擎数据表和日志移动到文件系统中其他更快的驱动器上,或者使用远程消息传递数据库。
Tables or views in a relational database management system (RDBMS).
关系数据库管理系统(DBMS)中的表或视图。
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.
由于联邦系统包括一个DB 2数据库,所以还可以将本地数据存储在这个数据库中,也可以存储来自本地表和远程表的组合信息。
Using character or binary large object (CLOB or BLOB) columns of tables to store the XML data intact in a relational database management system (DBMS).
使用表的字符大对象(CLOB)或二进制大对象(BLOB)列在关系数据库管理系统(DBMS)中按原样存储XML数据。
To ensure fast recovery of the partition containing system catalog tables, avoid placing user tables on the same database partition.
为了确保包含系统编目表的分区能够快速恢复,应避免将用户表也放在那个数据库分区上。
When you run queries for very large audit log tables, you can end up with a situation where your database system has to read thousands of pages into the bufferpool to compute the result.
当您在大型审核日志表格中运行查询功能时,您可能会在您的数据库系统不得不向缓冲池读入数千页面以进行计算时而结束。
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系统编目(或简称为“编目”)由很多表和视图组成,这些表和视图由数据库管理器来维护。
Please note that you can connect and have full access to the tables in the DB2 database as any of the system users from within your application.
请注意,可以作为任何系统用户从应用程序连接DB2数据库,对其中的表有完全访问权。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
因为db2缓冲池是系统主内存的一部分,DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
The DB2 UDB system catalog is a collection of tables that describe database objects.
DB 2udb系统编目是描述数据库对象的表的集合。
Federation takes you to the next level of information integration, allowing the DB2 federated system to act as a virtual database where remote objects can be queried like local tables.
联邦技术将您带到更高级别的信息集成,它允许DB 2联邦系统充当一个虚拟的数据库,使得对远程对象的查询和对本地表的查询一样简单。
Just about every business system database and data warehouse has a large number of frequently accessed small tables that would fit on USB jump drives.
每个业务系统数据库和数据仓库经常访问许多非常小的表(往往不超过u盘的容量)。
Even if the database is newly created and still empty, system tables and views are always present, so you can use them as follows.
即使数据库是新创建且仍然为空的,也总是会带有系统表和视图,因此,您可以按以下方法使用它们。
System catalog tables reside in the same dbspace as the database itself.
系统目录表和数据库本身位于同一个dbspace中。
Temporary - to store the system temporary tables created during database processing.
Temporary——存储数据库处理过程中所创建的系统临时表。
A large table space named SYSCATSPACE, which is used to store the system catalog tables and views associated with the database.
一个名为syscatspace的大表空间,用于存储与数据库有关的系统目录表和视图。
The syscdc system database in IDS contains the change data capture functions and system tables.
IDS 中的 syscdc系统数据库包含变更数据捕捉函数和系统表。
Regular dbspaces: Regular dbspaces hold database objects like system catalog tables, user tables, and indices.
常规dbspace:常规dbspace用来存放数据库对象,如系统目录表、用户表和索引。
Rational Data Architect will go through the catalog tables, also known as system tables in some database systems, and create a data model based on that information.
RationalDataArchitect将检查编目表(在某些数据库系统中也称系统表),并根据该信息创建数据模型。
System database changes: New tables sysusermap, syssurrogategroups, and syssurrogateusers are added to the sysusers database.
系统数据库变更:在sysusers数据库中添加新的表格sysusermap、syssurrogategroups和syssurrogateusers。
In this section, you will generate the JPA entities from the members database tables that form the heart of the business logic for Acme's membership system.
在这一部分中,您将会从MEMBERS数据库中生成JPA实体,这一操作是从业务逻辑的核心部分来为Acme的成员系统所完成的。
It can store the results as a string in system memory, into a file, or into database tables.
它可以将结果作为系统内存中的字符串存储到文件或数据库表内。
应用推荐