inter-partition? intra-partition?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laurence - 19 Mar 2007 04:56 GMT

Hi folks,

As I konw: database partition (aka data partition?), the database can
span multiple machines; table partition, the data within a table can
seperate by certain condition.

How about inter-partition and intra-partition? Is inter-partition
database partition...?

Laurence

Reply to this Message

Knut Stolze - 19 Mar 2007 12:37 GMT

> Hi folks,
>
> As I konw: database partition (aka data partition?),

I wouldn't call that "data partitioning". It just adds confusion.

> the database can
> span multiple machines; table partition, the data within a table can
> seperate by certain condition.
>
> How about inter-partition and intra-partition? Is inter-partition
> database partition...?

Inter-/intra-partition is usually referred to in the context of parallelism,
i.e. inter-partition parallelism and intra-partition-parallelism. It
refers to how a SQL statement is executed. If a a statement is executed in
parallel across multiple database partitions, then we talk
about "inter-partition parallelism". If you have multiple
processes/threads participating in the statement execution on the _same_
database partition, then you have intra-partition parallelism. Both can be
combined, of course.

Signature

Knut Stolze
DB2 z/OS Admin Enablement
IBM Germany

Reply to this Message