For data partitioning environments, DB2 requires a remote shell utility to execute commands on a remote partition.
对于数据分区环境,DB 2需要一个远程shell实用程序来在远程分区上执行命令。
In some cases, you might find that guidelines for choosing the proper partitioning key based on collocation and data balancing contradict one another.
在某些情况下,您可能会发现根据并置和数据平衡选择恰当的分区键的准则会相互矛盾。
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.
对于一个数据分区配置,必须有一个可供所有参与分区数据库系统的机器使用的文件系统。
In a federated system with the data partitioning feature, only user-maintained MQTs are supported for nicknames.
在具有数据分区功能的联邦系统中,对于昵称只支持用户维护的MQT。
Without partitioning, much overhead is incurred from getting the current data to the right place for processing, and this overhead grows exponentially -- not linearly -- as more machines are added.
没有分区,将当前数据放到可以处理的正确位置需要许多开销,这种开销是随着机器的增加呈指数(不是线性)增长的。
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 a good partitioning key is chosen, the data will be evenly distributed across the nodes, and for most, if not all, queries, the partitioning key will uniquely identify the node containing the data.
如果选定一个好的分区键,那么数据会均匀地分布在所有节点,对于大多数情况都是如此,如果不是这样,请进行查询,分区键将惟一地标识包含数据的节点。
In this kind of environment, you should examine your data model to determine the best choice for partitioning keys.
在这种环境下,应该查看数据模型来决定分区键的最佳选择。
Range partitioning addresses this administrative requirement, and DB2 9.7 extends prior support for this technology to include XML data.
范围分区可以满足这个管理需求,DB 2 9.7已经改进了对这种技术的支持,可以处理XML数据。
Devising methodologies for partitioning the data to maximize cache hits.
为数据分区设计相应的方法,以尽可能地增大缓存命中率。
These subject areas can be the basis for logically partitioning the data warehouse in several different (conceptual or even physical) databases.
这些主题领域可以是将数据仓库逻辑划分成几个不同(概念的,甚至或者是物理的)数据库的基础。
Routines that can help you estimate the data skew for new and existing partitioning keys.
可帮助您评估新的和已有分区键的数据倾斜的例程。
Stay tuned for part 2, where you'll learn to take performance baselines, to take advantage of DB2 Workload Management, and to configure monitoring in large data partitioning environments.
请继续阅读第2部分,您将会学习在大型数据分区环境中使用性能基准测试,利用DB 2WorkloadManagement,以及配置监控。
Despite their large size tables are actually pretty restrictive, for they only support a handful of data types are require developers to think about partitioning from the very beginning.
尽管Table Service可以支持大容量的数据,但由于只支持少量的数据类型,所以实际上还是有比较严格的限制,这就要求开发人员从一开始就需要考虑如何处理分区问题。
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.
在具有数据分区功能的联邦系统中,只能定义用户维护的MQT。
If collocation is not a major consideration, a good partitioning key for a table is one that spreads the data evenly across all database partitions in the database partition group.
如果不需要特别考虑并置,那么能使数据均匀地散布在数据库分区组中所有数据库分区上的分区键就是好的分区键。
The benefit of sharding (like partitioning) is that it compacts big data: individual tables are smaller in each shard, which allows for faster reads and writes, which increases performance.
切分的好处(如分区一样)在于它可以压缩大型数据:单独的数据表在每个切分中相对较小,这样就可以支持更快速的读写速度,从而提高性能。
Typically, the partitioning key is time-based, resulting in a design that directs data for a given week, month, or quarter to be stored in a certain partition.
通常,分区键是基于时间的,因此这种设计会把某一周、月或季度的数据存储在特定分区中。
Fact (or history) tables in data warehouses make excellent candidates for use with each partitioning feature, as you see in table 4 below.
数据仓库中的事实表(或历史表)非常适合使用上述每种特性,如下面的表4所示。
New routines to estimate data skews for existing and new partitioning keys.
新例程用来评估已有的和新的分区键的数据倾斜。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
Design Advisor 非常适合为数据仓库优化数据库设计,因为除了关于索引的建议之外,它还可以提供关于MQT、MDC和DPF分区键的建议。
This partitioning of data into different clusters allows them to ensure high reliability for critical jobs, while still allowing the use of Hadoop for more exploratory and analytic purposes.
将数据分割到不同的集群保证了关键性任务的高可靠性,同时还支持将Hadoop用于更为探索性和分析性的用途。
Automatic partitioning: the installer chooses the best disk-partitioning plan for your system (all data on the disk will be lost).
Automaticpartitioning:安装程序为系统选择最佳磁盘分区规划(磁盘上的所有数据都会丢失)。
In this paper, a novel data partitioning method is presented, aiming at reducing error propagation for video streaming.
提出一种有效降低误差扩散的数据分割方法。
A novel data streams partitioning method is proposed to resolve problems of range-aggregation continuous queries over parallel streams for power industry.
为了解决电力工业中并行数据流范围聚集的连续查询问题,提出一种新颖的数据流划分方法。
The purpose of the clustering algorithm is to support the data replication for improving data availability at the point of network partitioning in the MANET environment.
算法的目的是为了支持MANET环境中的数据复制,通过分簇来预测网络分割,以提高数据访问的可用性。
Each colorized pixel point maps a value, and a dimensional data is displayed in different section for partitioning section of rotundity.
圆形分段以每个彩色像素点映射一个值,并将每一维的数据在不同区域显示。
Compared with existing methods, the new method spends less time on data partitioning, and obtains less distributed transactions and faster speed on query for partitioning databases.
与现有方法相比,该方法减少了分区响应时间,保证了较少的分布式事务数量,并提高了分区事务查询速度。
For non-0/1 data block it used dimidiation technique, and for 0/1 data block it used some mark-bits to represent the times of partitioning.
首先将整个测试集划分成若干定长块,对非全0/1块,使用折半的方法划分;对全0/1块,使用标记位来表示划分的次数。
For non-0/1 data block it used dimidiation technique, and for 0/1 data block it used some mark-bits to represent the times of partitioning.
首先将整个测试集划分成若干定长块,对非全0/1块,使用折半的方法划分;对全0/1块,使用标记位来表示划分的次数。
应用推荐