每个索引分区仅从相应的数据分区取得索引行。
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.
然后,将工作分区分派到承载相应数据分区的位置。
Work partitions are then dispatched to the locations hosting the corresponding data partitions.
然后,每个数据分区在同一时间通过流程的一个副本运行。
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?
在SQLServer上暂时还无法实现跨多台服务器的完全数据分区。
Fully partitioning data across multiple servers isn't something that SQL server does out of the box.
PartitionName:指定分配给要创建的数据分区的惟一名称。
PartitionName: Identifies the unique name to be assigned to the data partition to be created.
管理节点具有单个数据库分区,每个数据节点都有4个数据分区。
The administration node has a single database partition, and each data node has four database partitions.
在下一篇专栏文章中,我将讲解添加(移入)和删除(移出)数据分区的过程。
In my next column, I'll walk you through the process of adding (rolling in) and removing (rolling out) data partitions.
数据分区0和1在server1上,数据分区2和3在server2上。
The data partitions 0 and 1 are on server1, and the data partitions 2 and 3 on server2.
DB 2优化器能够感知分区,在执行查询时只扫描相关的数据分区。
The DB2 Optimizer is data-partition aware, and only relevant data partitions are scanned during query execution.
创建数据库之后,应该确保每个数据分区还有它自己的日志本地目录。
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.
Constant:在使用语法的自动生成形式时,指定每个数据分区范围的宽度。
Constant: Specifies the width of each data-partition range when the automatically generated form of the syntax is used.
Constant:在使用语法的自动生成形式时,指定每个数据分区范围的宽度。
Constant: Specifies the width of each data-partition range when the automatically generated form of the syntax is used.
应用推荐