The concept of range partitioning is orthogonal to the database partitioning.
范围分区的概念与数据库分区的概念是一种正交关系。
Database PARTITIONING - distributing data by key hash across logical nodes of the database (DPF).
DATABASE PARTITIONING——按照键散列将数据分布在数据库的多个逻辑节点上(DPF)。
DB2 9.7 extends the DB2 database partitioning feature (DPF) to support both XML and relational data.
DB 2 9.7扩展了DB 2数据库分区特性(DPF),支持XML和关系数据。
Mount the exported file system on the other database partitioning servers with the following command.
用以下命令在其他数据库分区服务器上挂载导出的文件系统。
Federated objects such as NICKNAMEs as well as the database partitioning feature (DPF) are not supported.
不支持联邦对象(比如nickname)以及数据库分区特性(DPF)。
Sharding, an offshoot of database partitioning, isn't a native database technique - it happens at the level of the application.
切分是数据库分区的一个分支,但是它不是本地数据库技术—切分发生在应用程序级别。
In a database partitioning environment, you need to create three groups and user IDs for DB2. They are shown in the table below.
在数据库分区环境中,需要为DB 2创建三个组和用户ID,如下表所示。
Each entry represents a database partition on a particular server that participates in the database partitioning of the instance.
每个条目表示一个特定服务器上的一个数据库分区,该分区参与了该实例的数据库分区。
Once the instance-owner directory has been made available, you can import the directory to the remaining database partitioning servers.
instance - owner目录可用之后,便可以将该目录导入其他数据库分区服务器。
Database partitioning is an inherently relational process of dividing a table's rows by some logical piece of data into smaller groups.
数据库切分是一个固有的关系流程,可以通过一些逻辑数据块将一个表的行分为不同的小组。
The software includes database partitioning for flexible management of personnel and built-in LDAP connection to easily import personnel records.
该软件为方便人员灵活管理建立了数据库分区,还内置了LDAP连接以方便导入人事记录。
For best performance and minimal space consumption, we recommend using database partitioning, range partitioning, compression, and multi-dimensional clustering.
为了获得更好的性能和最小化空间消耗,我们建议使用数据库分区、范围分区、压缩和多维集群。
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.
当一个数据库由两个或更多数据库分区组成,并且每个数据库分区存储位于其中的每个表的一部分表数据时,就属于数据库分区的情况。
If database partitioning and range partitioning are used together, the rows in a table are first hashed across the database partitions and then range-partitioned within each database partition.
如果数据库分区和范围分区一同使用,那么表内的行首先会跨数据库分区做散列处理,然后再在每个数据库分区中执行范围分区。
Partitioning maps are a flexible way of controlling where data is stored in a partitioned database.
分区映射是在分区数据库中控制数据存储位置的一种灵活的方式。
That number is used as an index into the partitioning map to select the database partition for that row.
这个号码将用于作为分区映射的一个索引,以选择那一行所在的数据库分区。
The partitioning key for each table in a tablespace that is associated with a database partition group determines if the tables are collocated.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
You can store data in different partitions in the same table of a database using table partitioning.
您可以使用表分区将数据存储在同一个数据库表的不同分区中。
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.
跨多个分区划分数据库将允许您根据环境中分区数目的因数来增加表的最大大小。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
如果数据库设计者已在表上创建了主分区索引,那么查询应当与分区列结合。
While horizontal partitioning splits one or more tables by row, it is usually within the same database instance.
虽然水平分区会根据行来分割一个或多个表,但这通常是在相同的数据库实例中进行的。
When a database partition group is created or modified, a partitioning map is associated with it.
当创建或修改一个数据库分区组时,就会有一个与之关联的分区映射。
For a data partitioning configuration, you must have a file system that is available to all participating machines that participate in your partitioned database system.
对于一个数据分区配置,必须有一个可供所有参与分区数据库系统的机器使用的文件系统。
Database sharding refers to the horizontal partitioning of a database with each individual partition called a shard.
数据库分片是指对数据库进行水平分区,其中每个分区称为一个碎片。
Allow for horizontal partitioning so we can add more database hardware as the corpus grows.
支持数据水平分割,这样在数据量增加的情况下可以使用更多数据库硬件。
In a non-partitioned database, no partitioning key or partitioning map is required.
在一个非分区数据库中,不需要分区键或分区映射。
These recommendations address the database schema, the choice between XML and relational storage, definition of indexes, and physical data organization with partitioning and clustering options.
这些建议涉及了数据库模式、XML与关系存储之间的选择、索引的定义以及带有分区和集群选项的物理数据组织。
Create a database partition group that specifies the database partitions that will participate in the partitioning.
创建一个数据库分区组来指定要参加分区的那些数据库分区。
Choosing appropriate partitioning keys is essential for optimizing database performance in a partitioned environment based on DB2 software.
选择适当的分区键对于优化基于DB 2软件的分区环境中的数据库性能非常关键。
Some, such as partitioning techniques, have made their way into other IBM database offerings.
一些技术,比如说分区技术,以它们自己的方式融入到IBM数据库产品。
应用推荐