Workload partitioning gives businesses the flexibility
of assigning data ownership at the table-partition level, rather than
within an application.
The following figure illustrates workload partitioning. Figure 1: Workload
Partitioning in a Primary-Target Replication System
The replication model matches the partition model for the employee tables. The Asia-Pacific database server owns the partition and
can therefore update, insert, and delete employee records for personnel
in its region. The changes are then propagated to the US and European
regions. The Asia-Pacific database server can query or read the other
partitions locally, but cannot update those partitions locally. This
strategy applies to other regions as well.
