A partitioning key consists of one or more columns defined at table creation.
一个分区键由在表创建时定义的一个或多个列组成。
This routine creates a copy of your existing table with the new partitioning key and loads it partially or fully with the data from the original table.
这个例程用新的分区键创建了现有表的一个副本并用来自原始表的数据对它进行部分或全部加载。
The topic of partitioning and filesystems is a contentious one among system administrators.
分区和文件系统是系统管理员们争论的主题之一。
The data model and the business relationship between tables can provide a more stable way of selecting a partitioning key than specific SQL statements.
这个数据模型以及表间的业务关系可以提供一种比sql语句更为稳定的选择分区键的方式。
In physical partitioning, each partition might run the same operating system or a different version of the same operating system.
在进行物理分区时,每个分区可能运行相同的操作系统、或者相同操作系统的不同版本。
The idea behind partitioning is to spread a table's data across multiple partitions, storing some of its rows in one partition and other rows in other partitions.
分区背后的思想就是将一个表的数据分布在多个分区中,将该表中的一部分行存储在一个分区中,而将其他行存储在其他分区中。
DB2 V9 introduced a table partitioning feature that can increase the potential size of a single table, and significantly reduce the maintenance effort required to manage very large databases.
DB 2V 9引入了一个表分区特性,它能够增加一个表的可能大小,同时能够显著减少管理大型数据库所需要的维护。
Database sharding refers to the horizontal partitioning of a database with each individual partition called a shard.
数据库分片是指对数据库进行水平分区,其中每个分区称为一个碎片。
The MBR partitioning system is a hodge-podge of data structure patches applied to overcome earlier limits.
mbr分区系统是一个数据结构补丁的大杂烩,用于克服早期的限制。
Each entry represents a database partition on a particular server that participates in the database partitioning of the instance.
每个条目表示一个特定服务器上的一个数据库分区,该分区参与了该实例的数据库分区。
This provides greater computer utilization and operating system isolation, but is really more of a partitioning technology rather than a virtualization solution.
这提供了更高的计算机利用率和操作系统隔离,但是它实际上更像一种分区技术,而不像一种虚拟化解决方案。
In addition to the hardware costs, the horizontal partitioning feature requires Enterprise or Datacenter licenses which have a retail price of 27,495 and 54,990 per processor.
除了硬件成本之外,水平分区特性和需要企业版或者数据中心版本的许可,这两个版本对于每个处理器的零售价分别是27,495和54,990美元。
The above partitioning of functionality ensures that exception logging and resolution takes place in a consistent fashion.
以上的功能划分确保了异常记录和解决风格一致。
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只支持范围分区方案),一个数据分区包含一个行子集,这些行存储在与表中其他行集不同的地方。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
表的主键和所有惟一索引都必须是相关分区键的超集。
A new routine in DB2 9.7 named ADMIN_MOVE_TABLE allows you to automatically change the partitioning key of a table while keeping the table fully accessible for reads and writes.
在DB 2 9.7内有一个名为admin_move_table的新例程,可用来自动更改表的分区键,同时又能保持表对读写的完全可访问性。
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 you choose a partitioning key based on your query workload, the partitioning key should typically consist of either a joined column or a set of columns that is frequently used in many queries.
如果基于查询工作负载选择一个分区键,那么此分区键通常应该包含一个合并列或常被用于很多查询的一组列。
The hashing algorithm is applied to the value of the partitioning key, and generates a partition number between zero and 4095.
散列算法应用于分区键的值,产生 0 到 4095之间的一个分区号。
Logical Unit: Used when referring to a logical Unit as a tool for physically partitioning the logical contents of models.
逻辑单元:当把逻辑单元作为一个物理上划分模型的逻辑内容的工具的时候被使用。
Coping with complexity led to structured languages such as Pascal and c, which created hierarchical structures of state variables that provided a useful partitioning of the state space.
为了解决复杂性,而产生了结构化的语言,例如Pascal和c,生成了提供状态空间的有用分割的状态变量的层次结构。
Listings 1 and 2 show the translation of a range partitioning clause by MTK.
清单1和清单2显示了MT K对一个范围分区子句的转换。
A MapSet groups together a number of BackingMaps in an ObjectGrid that require the same partitioning and replication Settings.
在需要相同分区和复制设置的ObjectGrid中,MapSet组合了大量的BackingMap。
Partitioning maps are a flexible way of controlling where data is stored in a partitioned database.
分区映射是在分区数据库中控制数据存储位置的一种灵活的方式。
You can store data in different partitions in the same table of a database using table partitioning.
您可以使用表分区将数据存储在同一个数据库表的不同分区中。
Also, you will see later in this article how and why we use DB2 range partitioning to separate the first (default) model of a protein from its variations.
而且,在本文稍后的部分,您将会了解到使用DB 2范围分区来将蛋白质的第一个(默认)模型从其他变体中分离出来的方法以及原因。
Dynamic logical partitioning (DLPAR) provides a great deal of flexibility to your computing environment.
动态逻辑分区(DLPAR)为您的计算环境提供了大量的灵活性。
It is useful when a table has a finite set of values for the fragment key (or partitioning key) and queries on the table have an equality predicate on the fragment key.
如果表格有一定数量的片段键(或者分区键)值,而且在片段键上有同等谓词的表格上查询时,它会很有用处。
It does this by using a process called early allocation of paging space, by partitioning segments into pages.
使用一个称为分页空间预分配的过程,通过将段划分为页面,可以完成这项任务。
Sharding, an offshoot of database partitioning, isn't a native database technique - it happens at the level of the application.
切分是数据库分区的一个分支,但是它不是本地数据库技术—切分发生在应用程序级别。
应用推荐