Relational Architectural Overview
The following diagram illustrates the architectural components of PSQL’s Relational Engine for the server version. The SQL Connection Manager starts and runs in the same process address space as the MicroKernel Engine and the Relational Engine.
PSQL Relational Architecture: Server
The SQL Connection Manager supports up to 2000 simultaneous connections and uses the ODBC Driver Manager to make calls to the Relational Engine (SRDE), which in turn rests on top of the MicroKernel.
Figure 2 illustrates the client/server relational architecture of PSQL. The client talks to the SQL Connection Manager on the server through TCP/IP. This architecture applies to the server engine and to the Workgroup engine (in the case where a client DSN is used to connect from the local Workgroup engine to the remote Workgroup engine).
Figure 2 Client/Server Relational Architecture
 
 
Figure 3 illustrates the Workgroup relational architecture when a DSN is used to connect from the local Workgroup engine to the remote database, assuming that a remote Workgroup engine is acting as a Gateway to the remote data.
Figure 3 Workgroup Relational Architecture