Nonstop Database, HiRDB Version 9 Installation and Design Guide

[Contents][Index][Back][Next]

12.3.4 Effects of table row partitioning

The effects obtained when a table is row-partitioned are discussed below.

Organization of this subsection
(1) HiRDB single server configuration
(2) HiRDB parallel server configuration

(1) HiRDB single server configuration

Improved operability
Data storage in table, table reorganization, making backups, and additional operations are available for each user RDAREA.

Key range partitioning
The user RDAREAs that contain particular table data can be determined by searching the SQL_DIV_TABLE dictionary table. This means that if an error occurs in a user RDAREA, the unavailable data can be identified. For details about dictionary table retrieval and the SQL_DIV_TABLE table, see the HiRDB Version 9 UAP Development Guide.

(2) HiRDB parallel server configuration

Improved performance
High-speed table access processing can be achieved, because table access processing can be handled in parallel over multiple user RDAREAs.
Workload of table access processing can be distributed to multiple back-end servers.

Improved operability
Same as for a HiRDB single server configuration.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2012, 2015, Hitachi, Ltd.