8.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. Figure 8-2 shows multiple HiRDB/Single Servers linked with an OLTP system (OpenTP1).

Figure 8-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. Figure 8-3 shows a HiRDB/Parallel Server linked with an OLTP system (OpenTP1).

Figure 8-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). Figure 8-4 shows linking between multiple OLTPs (OpenTP1) and a single HiRDB.

Figure 8-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. Figure 8-5 shows linking between one OLTP (OpenTP1) and multiple HiRDBs.

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

[Figure]

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