Introduction to NonStop SQL/MP

Contents
113425 Tandem Computers Incorporated v
Figures Figure 1-1. A Table in a Relational Database 1-2
Figure 1-2. Comparing Traditional DBMS Architecture With
NonStop SQL/MP Architecture 1-6
Figure 1-3. NonStop SQL/MP Processing a Local and a Remote Request in a
Scalable Network 1-9
Figure 1-4. Distributed Data Dictionary 1-13
Figure 2-1. Personnel Database Example 2-2
Figure 2-2. A Simple Query 2-3
Figure 2-3. Selecting Data From Two Tables 2-4
Figure 2-4. A Shorthand View Derived From Two Tables 2-6
Figure 2-5. A Protection View 2-7
Figure 3-1. Database Structure 3-2
Figure 3-2. An Index for Faster Sorted Access 3-6
Figure 3-3. A Partitioned Table 3-8
Figure 3-4. Components of NonStop SQL/MP 3-10
Figure 3-5. Selecting an Access Plan With the Lowest Execution Cost 3-12
Figure 3-6. NonStop SQL/MP Components That Execute a Query 3-14
Figure 3-7. Parallel Execution of a Query Using an Aggregate Function 3-17
Figure 3-8. Single-Table Query Evaluation Performed by the Data Access
Manager 3-20
Figure 3-9. Virtual Sequential Block Buffering (VSBB) Access 3-22
Tables Table 2-1. Comparison of Protection Views and Shorthand Views 2-8