Introduction to NonStop SQL/MP
Why Use NonStop SQL/MP?
Introduction to NonStop SQL/MP
1–2 113425 Tandem Computers Incorporated
Figure 1-1. A Table in a Relational Database
001
Table
Name
Column
Names
Rows
Columns
ROGER
JERRY
GREEN
HOWARD
9000
1000
100
100
175500.00
137000.10
EMPNUM FIRST_NAME LAST_NAME DEPTNUM JOBCODE SALARY
EMPLOYEE Table
1
23
JESSICA CRINER 3500 300 39500.00
568
••• ••• ••• ••• ••• •••
29 JANE RAYMOND 3000 100 136000.00
Why Use
NonStop SQL/MP?
Many vendors offer relational databases. All these database systems support basic
two-dimensional tables; they differ in the additional features they offer.
NonStop SQL/MP contains features that make it especially appropriate for three
general types of applications: high availability online transaction processing (OLTP),
decision support systems (DSS), and scalable electronic commerce.
Scenario: High Availability
Online Transaction
Processing (OLTP)
Suppose your company provides financial services. Customers call your customer
service representatives to inquire about account balances, transfer funds from one
account to another, and authorize electronic payments. The account balances must be
accurate and each transaction against an account must fully complete before the
account balance can be updated.
You want to provide services whenever customers want them, not only during
traditional banking hours. Many customers call at 9 a.m., but some call at midnight.
Your services must be available 24 hours a day, 7 days a week, 365 days a year, and
you must be able to handle the peak calling loads that occur every morning.
Because your customers usually call in their requests, they want fast responses. They
cannot wait for several minutes while you process their requests. You need very fast
response time for both inquiries and updates to the database.
Because of your excellent record in customer service, your business has grown rapidly.
Originally, you had only 50 customer service representatives. You now employ over
1,000 customer service representatives who are all entering customer requests at the
same time. You need a system that can handle a large volume of simultaneous
transactions.