DB2 V9.5 introduces base table row storage of XML data.
DB 2V9.5引入了XML数据的基础表行存储。
An index is an ordered set of Pointers to rows in a base table.
索引是一个指向基础表的有序指针集。
Insufficient base table information for updating or refreshing.
缺少用于更新或刷新的基本表信息。
Unload the data from the customer base table using the query in Listing 9.
使用清单9中的查询卸载customer基表中的数据。
A probe scan is used to directly look up rows in an index or base table.
探测扫描用于直接在索引或基表中查找行。
TargetTable: Identifies the base table where the partition's data is to be stored.
TargetTable:指定存储分区数据的基表。
As the data for the base table (s) changes, the MQT needs to be updated accordingly.
当基本表中的数据发生改变时,需要相应地更新MQT。
Access to the data could then be governed through the view, instead of the base table.
于是,通过这个视图就可以控制对数据的访问,而不必使用基表。
Number of unrestricted full scans. These can either be base table or full index scans.
扫描聚集索引,可以扫描全部内容,也可以只扫描一个范围。
Large object (LOB) inlining - Small LOBs can be stored in the formatted rows of the base table.
大对象(lob)内联—小的LOB可存储在基表的格式化行中。
Number of probe scans. A probe scan is used to directly look up rows in an index or base table.
探测扫描的数目。探测扫描用于直接在索引或基表中查找行。
DB2 10 also removes restrictions on the online reorganization of base table Spaces that use LOB columns.
DB 210还消除了对使用lob列的基表空间的在线重组限制。
However, the design of an MQT can be affected by which partitioning features are used on the base table.
然而,MQT的设计却可能受到基本表上使用的分区特性的影响。
Base table fields have been changed and no longer match view fields. View field properties cannot be set.
基表字段已被更改,不再匹配视图字段,因此不能设置视图字段属性。
While loading, if the target base table is fragmented, the load happens in parallel under the PDQ environment.
加载时,如果目标基表被碎片化(fragmented),加载过程将在PD Q环境下并行发生。
External tables can be created with the columns of all the data types supported by the regular base table in IDS.
外部表可以使用IDS中的常规基表支持的所有数据类型的列创建。
Before an existing base table can be added (attached) to a partitioned table, the following conditions must be met.
只有满足以下条件,现有基表才能被添加(附加)到分区表。
The use of partitioning features on the base table does not need to take into account whether MQTs will be built upon this table.
基本表上分区特性的使用不需要考虑将来是否会在这个表上创建MQT。
To load data from the data file /data/americascust.dat (created above) into the base table customer, use the INSERT statement as follows
要将数据文件 /data/americascust.dat(此前已创建)中的数据加载到基表customer,可以使用INSERT 语句(如下所示)
For example, if the base table is DPF partitioned, the design of the MQT should consider whether to replicate the MQT across the data partitions.
例如,如果基本表使用了DPF进行分区,那么MQT的设计就应该考虑是否要在各个数据库分区上复制MQT。
The optimization techniques, such as system installation, table space, construction design of base table and free space are discussed in this paper.
分析讨论了就系统安装、表空间及基表的结构设计、自由空间等方面的优化方法。
Selecting from an external table reads the data from the data file(s) and provides it in the form of rows and columns as if it was read from the normal base table.
从外部表选择可从一个或多个数据文件读取数据,并以行和列的形式提供该数据,就好像从常规基表读取数据一样。
You can also perform operations such as filtering, using WHERE conditions, ORDER BY, GROUP BY, and other operations that would be possible with a regular base table.
还可以通过使用WHERE条件、ORDER BY、GROUP BY 子句执行过滤操作,或者执行常规基表适用的其他操作。
If the base table to which the data is loaded from the external table is defined to be a RAW table without indexes, the IDS server USES light appends to load the data.
如果将从外部表加载数据所到的基表定义为不带索引的raw表,则IDS服务器将使用“轻追加法”加载数据。
If some or all of your XML documents are small enough to fit into their corresponding row on the base table page in the DAT object, they can be inlined into the relational row.
如果某些或所有XML文档足够小,可以放置到DAT对象的基本表页面的对应行中,那么可以将它们内联为关系行。
This new command allows you to collect statistics and build an index in a single pass of the base table, instead of two passes with the previous implementation of these features.
这条新命令允许您在对基表的一次扫描中收集统计数据,并构建索引,而不像这些特性的以前实现那样需要进行两遍扫描。
This scenario would occur most likely if we needed a broker flow to run for a maintenance purpose, such as processing or clearing rows that have accumulated in a data base table.
如果我们需要出于维护目的而运行代理流(如处理或清除在数据基表中积累的行),则很可能出现这种情况。
The ideal situation for base table row storage of XML data is when the table has only one column of XML type and the maximum size of the XML document doesn't exceed the page size.
使用XML数据基础表行存储的理想情形是,当表只有一个xml类型列并且XML文档的最大值没有超过页面大小时。
If the base table on which the view is defined contains not just an XML column but also relational columns with indexes, you should include those relational columns in the view definition.
如果定义视图所用的基表不仅包含一个xml列,还包含有索引的关系列,那么应该将那些关系列包含在视图定义中。
This paper describes the base table. the event which causes a trigger to fire and the action of the trigger. It also gives examples to state the whole process. of programming trigger.
阐述了触发器的基表、触发事件和触发器的动作设置,并用具体实例说明了触发器的设计过程。
应用推荐