Q:如何知道某行所在的数据分区?
End:指定数据分区的最高范围。
End: Specifies the high end of the range for the data partition.
End:指定每个数据分区的范围上限。
End: Specifies the high end of the range for each data partition.
Start:指定数据分区的最低范围。
Start: Specifies the low end of the range for the data partition.
Start:指定每个数据分区的范围下限。
Start: Specifies the low end of the range for each data partition.
每个索引分区仅从相应的数据分区取得索引行。
Each index partition indexes rows only from the corresponding data partition.
这必然会给架构设计和数据分区策略带来变化。
This makes changes to schema designs and data-partitioning strategies necessary.
这称为数据分区。
TSName:指定存储每个数据分区的表空间。
TSName: Identifies the table space in which each data partition is to be stored.
每个数据分区的索引分区可以位于不同的表空间中。
The index partition for each data partition can be in a different table space.
然后,将工作分区分派到承载相应数据分区的位置。
Work partitions are then dispatched to the locations hosting the corresponding data partitions.
一种常见的设计是为每个月的数据创建一个数据分区。
A common design would be to create a data partition for each month's data.
附加的数据分区具有与其数据处于不同表空间中的索引。
The data partition being attached has indexes in a separate table space from the data.
然后,每个数据分区在同一时间通过流程的一个副本运行。
Then, each partition of data is run through a copy of the same process at the same time.
WFS必须是一个支持数据分区功能(DPF)的系统。
The WFS must be a data partitioning feature (DPF) enabled system.
另一方面,DPF又需要考虑将行发送到适当的数据分区。
One the other hand, DPF introduces the additional consideration of sending the rows to the proper data partition.
Q:我如何知道一个数据分区或者索引分区是否需要重组?
Q: How do I know if a data partition or an index partition needs to be reorganized?
为数据分区设计相应的方法,以尽可能地增大缓存命中率。
Devising methodologies for partitioning the data to maximize cache hits.
TP支持按照一个维将一个表分区成多个数据分区。
TP supports partitioning a table into data partitions along a single dimension.
业务逻辑可以完全并行运行,或者仅仅是数据分区的一个子集。
Business logic might be run in parallel over all or just a subset of the partitions of the data.
在具有数据分区功能的联邦系统中,只能定义用户维护的MQT。
In a federated system with the data partitioning feature, you can only define user-maintained MQTs. Here is the process for defining and using user-maintained MQTs.
默认情况下,XML数据存储到与其相应数据分区相同的表空间当中。
By default, the XML data goes in the same table space as the corresponding data partition.
现在,DB 2 9.7支持分区索引,允许每个数据分区单独索引。
With DB2 9.7, partitioned indexes are now supported, allowing each data partition to be indexed separately.
在具有数据分区功能的联邦系统中,对于昵称只支持用户维护的MQT。
In a federated system with the data partitioning feature, only user-maintained MQTs are supported for nicknames.
为了解决有问题的事务,一个数据分区可能需要与另一个数据分区联系。
In order to resolve an in doubt transaction, a data partition may need to contact another data partition.
在每个数据分区中创建一个XDA对象,用于存储该分区的XML数据。
One XDA object is created per data partition to store XML data for that partition.
数据分区提供了许多有用的好处,特别是在数据仓库和决策支持环境中。
Data partitioning provides many useful benefits, particularly when used in data warehouse and decision support environments.
Slice扩展了OpenJPA实现,使其能够无缝地支持数据分区。
Slice has extended OpenJPA implementation to support data partitions or sharding in a seamless manner.
IndexTSName:指定存储每个数据分区的分区索引的表空间。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
Q:每个分区的本地索引分区和数据分区能否处于同一表空间中?
Q: Can the local index partition and data partition be in the same table space for each partition?
应用推荐