7.2.3 Example of HiRDB system configuration with OLTP linkage

This section describes a HiRDB system linked with OLTP by way of an example using OpenTP1.

Organization of this subsection
(1) Linking with HiRDB/Single Servers
(2) Linking with a HiRDB/Parallel Server
(3) Linking between multiple OLTPs (OpenTP1) and a single HiRDB
(4) Linking between one OLTP (OpenTP1) and multiple HiRDBs

(1) Linking with HiRDB/Single Servers

You can execute multiple HiRDB/Single Servers' update processing as a single transaction by linking OLTP (OpenTP1) to HiRDB/Single Servers. If you partition a database by key ranges, the OLTP system (OpenTP1) running on each server machine can distribute processing to the linked HiRDB/Single Servers. This enables transaction processing to be performed at high speed. When integrating multiple HiRDB/Single Servers, consider linking your system to an OLTP. The following figure shows linkage of a HiRDB/Single Server with an OLTP system (OpenTP1).

Figure 7-2 Linking HiRDB/Single Server with an OLTP system (OpenTP1)

[Figure]

(2) Linking with a HiRDB/Parallel Server

When a HiRDB/Parallel Server is linked with an OLTP system (OpenTP1), transaction processing can be achieved at high performance and high workload. The following figure shows linkage of a HiRDB/Parallel Server with an OLTP system (OpenTP1).

Figure 7-3 Linking HiRDB/Parallel Server with an OLTP system (OpenTP1)

[Figure]

(3) Linking between multiple OLTPs (OpenTP1) and a single HiRDB

In this type of linking, multiple OLTPs (OpenTP1) and one HiRDB communicate using the client/server method. Different OLTPs (OpenTP1) can connect to one HiRDB at the same time. To do this, you must set a unique OLTP identifier (client environment definition PDTMID) for each OLTP (OpenTP1). The following figure shows linkage between multiple OLTPs (OpenTP1) and a single HiRDB.

Figure 7-4 Linking between multiple OLTPs (OpenTP1) and a single HiRDB

[Figure]

(4) Linking between one OLTP (OpenTP1) and multiple HiRDBs

In this type of linking, one OLTP (OpenTP1) is linked to multiple HiRDBs. SQL statements can be executed by connecting to HiRDBs on different server machines at the same time. In such a case, you need to use the multi-connection facility. The following figure shows linkage between one OLTP (OpenTP1) and multiple HiRDBs.

Figure 7-5 Linking between one OLTP (OpenTP1) and multiple HiRDBs

[Figure]

For details about the multi-connection facility, see the HiRDB Version 9 UAP Development Guide.