These database partitions can reside on the same machine to exploit all the CPU power of a multi-core system, or they can be spread across multiple machines in a shared-nothing configuration.
这些数据库分区可以位于同一台机器以充分利用多核系统的全部CPU能力,当然,在一个没有分享的配置中,它们也可以跨多个机器分布。
Table data skew refers to a difference between the number of records in a table on particular database partitions and the average number of records across all database partitions for this table.
表数据倾斜指的是特定的一些数据库分区上的某个表内的记录数与这个表所跨的所有数据库分区的平均记录数之间的差额。
A database partition group is a set of one or more database partitions.
数据库分区组是由一个或多个数据库分区组成的一个组。
This means that one or some database partitions are assigned a disproportionate number of table rows which can create a performance bottleneck.
这意味着一个或一些数据库分区承担了更重比例的表行,从而造成了性能瓶颈。
Depending on the number of database partitions, you may have one or more single-partition database partition groups, and one or more multi-partition database partition groups.
取决于数据库分区的数量,您可以有一个或多个单分区的数据库分区组,以及一个或多个多分区的数据库分区组。
There is an implicit assumption that the rows of each table are evenly distributed across all the partitions in each multiple-partition database partition group.
有一个隐式的假设:每个表中的行是均匀分布在每个多分区数据库分区组中的所有分区上的。
Since the data is divided across database partitions, you can use the power of multiple processors on multiple computers to satisfy requests for information.
由于数据被划分在多个数据库分区上,因而可以使用多台计算机上的多个处理器的处理能力来满足对信息的请求。
Note: If this is a system with multiple physical partitions (MPP), the number of partitions in the database partition group must be the same on test.
注意:如果这是具有多个物理分区(MPP)的系统,那么测试中数据库分区组中的分区数目就必须相同。
Also, the response time of complex analytical queries can be reduced by spreading the data across multiple database partitions, such that all partitions work on their assigned data in parallel.
此外,通过跨多个数据库分区分散数据以使多个分区可并行处理分配到其上的数据,也能减少复杂的分析查询的响应时间。
On the other hand, if a small part of the database requires frequent updates, consider dynamic partitions.
而如果数据库只是一小部分经常需要更新,那么就考虑动态分区。
Matching work partitions to their data partitions will increase the probability of a cache hit within the server and decrease remote accesses to the database, which introduces quite a bit of latency.
将工作分区与它们的数据分区进行匹配,这将增加服务器缓存的命中概率,并减少对数据库的远程访问,后者会引起较大的延迟。
You can define named subsets of one or more database partitions within a database.
可以在一个数据库中定义包含一个或多个数据库分区的有名称的子集。
Partitioning a database across multiple partitions lets you increase the maximum size of your table by a factor of the number of partitions in your environment.
跨多个分区划分数据库将允许您根据环境中分区数目的因数来增加表的最大大小。
To simplify administration of XML data and provide maximum scalability, DB2 9.7 enables XML data to be distributed across multiple database partitions.
为了简化XML数据管理和提供最出色的可伸缩性,DB2 9.7支持跨多个数据库分区分布 XML 数据。
DB2 can then choose to perform the join or subquery at the database partition where the data is stored, instead of having to move data between database partitions.
于是DB 2就可以在存储数据的数据库分区上执行连接或子查询,而不必在数据库分区之间移动数据。
DPF can maintain consistent query performance as the table grows by providing the capability to add more processing power in the form of additional database partitions.
DPF可以通过增加数据库分区来提高处理能力,因此,随着表的增长,仍然可以保持较高的查询性能。
Changing any one of the instance name, database name, or database path requires that the changes be made on all partitions.
无论修改实例名、数据库名,还是修改数据库路径,都需要修改所有的分区。
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.
这就意味着您需要以这样的方式设计数据库系统,即将数据库表划分成两种类型——静态和动态——的模块化、最优化部分。
In a multi-partitioned database, an attempt to suspend I/O on any of the non-catalog partitions will require a connection to the catalog node for authorization.
在多分区数据库中,要挂起任何非编目分区上的I/O,都必须有到编目节点的连接,以便进行认证。
The large number of distinct values in the pdb_id column ensures a relatively even distribution of rows over the database partitions.
pdb_id列中各异的值数量很大,这就确保了跨数据库分区可以获得相对均衡的行分布。
For example, Figure 5 shows a database partition group made of five partitions.
例如,图5展示了一个由5个分区组成的数据库分区组。
So the cluster contains a total of nine database partitions.
因此,集群总共包含了9 个数据库分区。
Using the DPF, we recommend to distribute the data in the PDBXML table and atom_site table across the database partitions by hashing on the values of the pdb_id column.
使用DPF,我们建议通过对pdb_id列的值进行散列处理来跨数据库分区分布pdbxml表和atom_site表中的数据。
The number of distinct values must be great enough to ensure an even distribution of rows across all database partitions in the database partition group.
distinct值的数量必须多到足以确保数据行均匀地分布在数据库分区组中的所有数据库分区上。
For example, assume that you have a database created on five database partitions (numbered 0-4). The partitioning map for the IBMDEFAULTGROUP database partition group of this database would be.
例如,假设您在5个数据库分区(分区号为0 - 4)上有一个数据库。
This ensures that container names are unique across partitions, by using the database partition number as part of the container name.
通过使用数据库分区号作为容器名称的一部分,可以确保容器名称在各分区当中是惟一的。
You can store data in different partitions in the same table of a database using table partitioning.
您可以使用表分区将数据存储在同一个数据库表的不同分区中。
Database partitioning occurs when a database consists of two or more database partitions, where each database partition stores a subset of table data for each table that resides within it.
当一个数据库由两个或更多数据库分区组成,并且每个数据库分区存储位于其中的每个表的一部分表数据时,就属于数据库分区的情况。
Slice introduces the abstraction of a virtual database to encompass the underlying physical database partitions or shards.
Slice引入了抽象的虚拟数据库来绕过底层的物理数据库分区或划分。
In this case, the 'database partition group 1' spans all but one of the database partitions.
在这种情况下,DatabasePartitionGroup1横跨除一个数据库分区外的所有数据库分区。
应用推荐