Introduction to NonStop SQL/MP

Contents
113425 Tandem Computers Incorporated iii
About This Manual vii
Section 1 Introduction to NonStop SQL/MP
What Is a Relational Database? 1-1
Why Use NonStop SQL/MP? 1-2
Scenario: High Availability Online Transaction Processing (OLTP) 1-2
Solution 1-3
Scenario: Decision Support Systems (DSS) 1-3
Solution 1-4
Scenario: Scalable Electronic Commerce 1-4
Solution 1-5
A High Performance DBMS 1-6
Scalability 1-8
Tandem’s Parallel Hardware Architecture 1-8
Full Integration With System Software 1-9
Table Partitioning and Parallel Execution 1-10
A Highly Available Database 1-11
Availability Features of the NonStop Kernel 1-11
Availability Features of NonStop SQL/MP 1-11
Distributed Database Architecture 1-12
Support for Open Standards 1-14
Easy-to-Use ANSI SQL 1-14
Open System Services (OSS) 1-14
Accessing Data With Desktop Software 1-14
Additional Features 1-15
Cost-Based Query Optimization 1-15
Locking 1-15
Mixed Workload Environment 1-16
Support for National Languages 1-16
Active Data Dictionary 1-16
Constraints 1-17
Performance Features for DSS 1-17
Tools for Database Administration 1-17
Parallel Sorting Utility 1-18
Summary 1-18