Introduction to NonStop SQL/MP

Contents
iv 113425 Tandem Computers Incorporated
Section 2 How to Use NonStop SQL/MP
Querying the Database 2-1
Sources of Queries 2-1
Writing Queries 2-1
Selecting Data 2-2
Joining Tables 2-4
Using the UNION Operator 2-5
Using Views 2-5
Shorthand Views 2-6
Protection Views 2-7
Modifying Data 2-8
Concurrent Updates and Locking 2-8
Transaction Management 2-9
Summary 2-9
Section 3 NonStop SQL/MP Architecture
Physical Database Structure 3-1
Logical Schema 3-1
Physical Structure 3-1
Table Organization 3-3
Indexes 3-4
Partitions 3-7
What Happens When a Query Is Submitted? 3-9
The SQL Compiler and SQL Optimizer 3-10
The SQL Executor 3-13
Parallel Execution 3-15
The Master Executor and ESPs 3-16
Parallel Index Maintenance 3-18
Other Architectural Features 3-18
The Data Access Manager (DP2 Disk Process) 3-18
Sequential Block Buffering 3-21
Cache Optimizations for Sequential Access 3-23
Summary 3-23
Index Index–1