Each index partition indexes rows only from the corresponding data partition.
每个索引分区仅从相应的数据分区取得索引行。
TSName: Identifies the table space in which each data partition is to be stored.
TSName:指定存储每个数据分区的表空间。
One XDA object is created per data partition to store XML data for that partition.
在每个数据分区中创建一个XDA对象,用于存储该分区的XML数据。
Q: How do I know if a data partition or an index partition needs to be reorganized?
Q:我如何知道一个数据分区或者索引分区是否需要重组?
The dynamic data partition and schedule strategy based on view point is presented.
提出了基于视点的场景数据动态分块调入与释放策略。
By default, the XML data goes in the same table space as the corresponding data partition.
默认情况下,XML数据存储到与其相应数据分区相同的表空间当中。
PartitionName: Identifies the unique name to be assigned to the data partition to be created.
PartitionName:指定分配给要创建的数据分区的惟一名称。
HPF(High Performance Fortran)is a parallel language based on data partition specification.
是基于数据划分说明的并行语言。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q:每个分区的本地索引分区和数据分区能否处于同一表空间中?
In order to resolve an in doubt transaction, a data partition may need to contact another data partition.
为了解决有问题的事务,一个数据分区可能需要与另一个数据分区联系。
Clustering analysis is a major field in data mining, which is an important method of data partition.
聚类分析是数据挖掘中的一个重要研究领域,是一种数据划分或分组处理的重要手段和方法。
With DB2 9.7, partitioned indexes are now supported, allowing each data partition to be indexed separately.
现在,DB 2 9.7支持分区索引,允许每个数据分区单独索引。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName:指定存储每个数据分区的分区索引的表空间。
One the other hand, DPF introduces the additional consideration of sending the rows to the proper data partition.
另一方面,DPF又需要考虑将行发送到适当的数据分区。
The DB2 Optimizer is data-partition aware, and only relevant data partitions are scanned during query execution.
DB 2优化器能够感知分区,在执行查询时只扫描相关的数据分区。
With TP, the user can manually define each data partition, including the range of values to include in that data partition.
通过TP,用户可以手动地定义每个数据分区,包括将被包括到那个分区的值的范围。
Then, the principles, types and methods of data partition are given in the context of the distributed spatial databases.
给出分布式空间数据库的空间数据划分原则、分布式空间数据分段的类型和空间数据关系的分段操作方法。
"7-data partition Recovery" is particularly designed to recover data from lost, deleted or damaged partitions by accident.
“7数据分区恢复”是特别设计来恢复数据丢失,删除或损坏的分区事故。
Clustering is an important area for research in data Mining, and also an important method in data partition or data grouping.
聚类分析是数据挖掘中的一个重要研究领域,是一种数据划分或分组处理的重要手段和方法。
A: the DATAPARTITIONNUM function returns the sequence number (SYSDATAPARTITIONS.SEQNO) of the data partition in which the row resides.
A:函数DATAPARTITIONNUM能够返回行所在数据分区的序号(SYSDATAPARTITIONS . SEQNO)。
ColumnName: Identifies one or more columns (up to 16) by name, whose values are used to determine which data partition a particular row is to be stored in.
ColumnName:用名称指定一个或多个列(最多16列),这些列的值用来决定数据行应该存储在哪个数据分区中。
Once the database is created, you should ensure that each data partition should also have its own log local directory. You can use the following command.
创建数据库之后,应该确保每个数据分区还有它自己的日志本地目录。
A: Yes, in fact this is the default case and many customers choose to do so. The local index will be in a different table space from the associated data partition when.
A:可以,事实上默认情况下就是如此,并且很多用户都会选择这样做。
SQL20153N would only occur if db2inidb is issued sequentially on each data partition, whereas SQL1391N can occur when db2inidb is run in parallel across all data partitions.
SQL20153N只在连续地在每个数据分区上发出db2inidb 的情况下出现,而 SQL1391N在并行地在所有数据分区上运行 db2inidb时出现。
This paper presents an optimized query algorithm, which adopts direct-join using data partition and parallel processing. It can reduce the response time of query process.
本文利用数据分片和并行处理策略,提出一种采用直接连接的查询优化算法,能有效地缩减查询处理的响应时间。
One way to think about the WebSphere profile is to consider it as the "user data partition," the equivalent of the user's home directory in UNIX/Linux operating system environments.
可以认为WebSphere概要文件是"用户数据分区",等同于UNIX/Linux操作系统环境中用户的主目录。
Another advantage of using partitioned tables is that new data can be easily added to a table (as another data partition) while old or obsolete data can be easily removed and archived.
使用分区表的另一个优点是,可以轻松地在表中添加新数据(作为新的数据分区),同时可以轻松地删除并存档老数据。
Hence, while you can specify the table space where the index object containing all the indexes for a data partition go, it is not possible to specify a table space for each individual index.
因此,在索引对象包含数据分区的全部索引的情况下,指定表空间时,就无法为每个单独的索引指定表空间。
A data partition, also referred to as a range (currently DB2 supports only a range partitioning scheme), contains a subset of rows that are stored separately from other sets of rows in the table.
数据分区也称为范围(当前DB 2只支持范围分区方案),一个数据分区包含一个行子集,这些行存储在与表中其他行集不同的地方。
Traditional data partition ways are not suitable to pointer array whose member points to an array, so this paper presents a new mode to solve this problem, named array-vector data partition mode.
传统数据划分模式不适合指向数组的指针数组的数据划分,论文提出了解决该类指针数组数据划分的划分模式,文中称为数组向量的数据划分。
应用推荐