NonStop Systems Introduction for H-Series RVUs

The Relational Database Management System
NonStop Systems Introduction for H-Series RVUs—540083-001
4-12
Data Distribution
•
The node that uses system B has one table partition containing rows for customers
5001 through 7500.
•
The node using system C has a single partition containing customer numbers 7501
through 10000.
The database shown in this figure illustrates these features of SQL/MX partitioned
tables:
•
Local users can add, change, or delete data in any local partition of the database.
For example, the user on the system A node could change the address of
customer 100 or customer 2600.
•
Local users can add, change, or delete data on any remote partition of the
database. For example, the user on the system A node could delete the row for
customer 6000 on the system B node or add a new row for new customer 9999 on
the system C node.
•
If some partitions of a partitioned table are unavailable because the nodes
containing those partitions are temporarily inaccessible, the local user can still work
with the data in the local partition. For example, the user on the system A node can
still access the rows for customers 1 through 5000 even if communications line
problems make rows 5001 through 7500 and 7501 through 10000 unavailable.