在选择分区键时,可以画出一个数据模型,用来显示数据库内的这些表之间的关系。
When choosing partitioning keys, draw a data model that shows the relationships among the tables that are in your database.
更改此关系的惟一方式是丢弃此表并在与不同的数据库分区组相关联的一个不同的表空间内重新创建它。
The only way to change this relationship is to drop the table and recreate it in a different table space that is tied to a different database partition group.
这些建议涉及了数据库模式、XML与关系存储之间的选择、索引的定义以及带有分区和集群选项的物理数据组织。
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.
清单3创建一个包含关系和XML数据的范围分区表,滚出(分离)包含老数据的分区,滚入(附加)包含最近数据的分区。
Listing 3 creates a range-partitioned table with relational and XML data, rolls out (detaches) a partition containing old data, and rolls in (attaches) a partition containing recent data.
另外,分区键仍然必须基于关系数据。
In addition, the partitioning key must still be based on relational data.
DB 2 9.7扩展了DB 2数据库分区特性(DPF),支持XML和关系数据。
DB2 9.7 extends the DB2 database partitioning feature (DPF) to support both XML and relational data.
与管理只包含关系列的范围分区表相比,管理包含一个或多个XML 列的范围分区表的差异并不大。
Managing a range-partitioned table that includes one or more XML columns isn't much different from managing a range-partitioned table with only relational columns.
它是一个全面的组合工作产品,封装了所有的服务、提供者、规则、分区、消息、协作及其关系。
It is a comprehensive, composite work product encompassing all services, providers, specifications, partitions, messages, collaborations, and the relationships between them. It is needed to.
图3说明了给定分区的数据库对象之间的关系。
Figure 3. DB2 object-relationship diagram for a given database partition.
这个错误由显示Productline的列表分区和交叉表之间的 “主-细节” 关系 (master-detailrelationship) 导致。
The error is caused by the master-detail relationship between the list section showing Product line and the crosstab.
通常,转出涉及到以下业务规则,并关系到如何使用DB 2分区特性的问题?
Generally, roll-out is subject to one of the following business rules, which has implications for how DB2 partitioning features are used.
稍后,我们将讨论如何处理并置限制(比如,一个懒惰关系可跨分区存在或同一个项实例如何能在多片间复制)。
Later, we will discuss how to work around collocation constraint (e.g., a lazy relation can exist across partition or how the same entity instance can be replicated in multiple slices).
这个数据模型以及表间的业务关系可以提供一种比sql语句更为稳定的选择分区键的方式。
The data model and the business relationship between tables can provide a more stable way of selecting a partitioning key than specific SQL statements.
范围分区的概念与数据库分区的概念是一种正交关系。
The concept of range partitioning is orthogonal to the database partitioning.
这个只跟硬盘有关,跟操作系统是什么没有关系。主引导记录告诉机器从哪里启动系统,所以一般来说主分区是安装系统的。
This limitation is due to something called the Master Boot Record which tells the computer which partitions it can boot from, and so primary partitions are usually reserved for operating systems.
所有分区的关系都平等。
交叉表的分区将Productline查询项目放置到标头中,生成了一个“主-细节”关系。
The sectioning of the crosstab places the Product line query item into the header and generates a master-detail relationship.
阐述了DMA技术方法和分区装表计量的管网夜间流量与管网漏损的关系,介绍了DMA技术的应用技术路线和实施方案。
The DMA technology and the relationship between flow and leakage of pipeline network measured at night are described. The application and execution of DMA technology are also introduced.
我们会通过处理分析的方式,使用数据层次图的概念,以描述数据库分区结构和数据库处理的关系。
We will use the concept of a data hierarchy graph, constructed by means of transaction analysis, to characterize the relationship between a database partition scheme and database transactions.
通过地球化学分区与构造演化的关系研究,探讨了地球化学区形成的构造过程。
According to the relationship between the geochemical division and the tectonic evolution, the tectonic process during the formation of geochemical regions is discussed.
分区规划作为协调保护和利用关系的重要手段,是风景名胜区总体规划中的核心内容。
The zoning planning, an important approach to balance the relations between protection and utilization, is the core content in the overall planning of scenic areas.
并就胃肿瘤超声的特点、分区、分型及与手术的关系进行了探讨。
The ultrasonic imaging characteristics, zonation and typing of gastric tumor as well as their relations to the surgical procedures wre dis - cussed.
最后讨论了褶积滤波积分区间长度与水井含水层系统性质的关系。
Besides, the relation between the integral interval length of faltung filtering and the character of well aquifer system is discussed.
证书路径构造过程中,针对分区之间与信任域之间变动较少的情况下引入关系矩阵和证书路径库技术。
During the process of certificate path construction, relationship matrix and certificate path database are introduced in allusion to the trust areas and subareas which change smallness.
根据分期分区研究的结论,探讨磨沟墓地对齐家文化研究的作用,进而讨论齐家文化与相关考古学文化的关系。
Staging area under the study's conclusions, grinding trench burial of cultural studies on the role of regulating the family, and then explore the culture and the related archaeological Qijia culture.
根据分期分区研究的结论,探讨磨沟墓地对齐家文化研究的作用,进而讨论齐家文化与相关考古学文化的关系。
Staging area under the study's conclusions, grinding trench burial of cultural studies on the role of regulating the family, and then explore the culture and the related archaeological Qijia culture.
应用推荐