Introduction to NonStop SQL/MP

Scalability
Introduction to NonStop SQL/MP
113425 Tandem Computers Incorporated 1–9
Figure 1-3. NonStop SQL/MP Processing a Local and a Remote Request in a Scalable Network
SQL Data Access
Manager
I/O Drivers
Application
Message System
SQL File System
003
NonStop SQL/MP
Table 1
Partition 1
NonStop SQL/MP
Table 1
Partition 2
NonStop SQL/MP
Table 1
Partition 3
Message System
SQL File System
Message System
SQL File System
SQL Data Access
Manager
I/O Drivers I/O Drivers
SQL Data Access
Manager
Full Integration With
System Software
NonStop SQL/MP is fully integrated with the NonStop Kernel operating system so
that it can take advantage of the distributed processing made possible by the Tandem
hardware architecture. Through the NonStop Kernel message system, a
NonStop SQL/MP process accesses a remote resource simply by qualifying the
resource with a node name. The NonStop Kernel, together with the TorusNet network
software, present a single system image to every process in the system. (A separate
copy of the NonStop Kernel runs in each processor.)
NonStop SQL/MP is also fully integrated with other Tandem software to ensure that
high performance as well as the integrity and availability of the data is maintained.
Integration with other parallel products is especially important in a large, distributed
system in which many NonStop SQL/MP processes execute in parallel.
For example, the NonStop Transaction Services/MP (TS/MP) application
management system ensures that application server processes are evenly distributed
among processors in a system. NonStop SQL/MP processes, which serve requests
sent by the application servers, are also distributed among processors. As system
activity changes, these products dynamically create (or delete) copies of the required
processes.