Introduction to Data Management

Accessing Databases With NonStop SQL
15873 Tandem Computers Incorporated 3-3
Figure 3-2. A NonStop SQL View
S8020-008
EMPLOYEE Table
EMPNUM FNAME LNAME DEPTNUM JOBCODE
1
23
29
32
..
213
234
ROGER
JERRY
JANE
THOMAS
..
ROBERT
MARY
GREEN
HOWARD
RAYMOND
RUTLOFF
..
WHITE
MILLER
9000
1000
3000
2000
..
1500
2500
100
100
100
100
..
100
100
DEPT Table
DEPTNUM DEPTNAME MGR
1000
1500
2000
2500
..
4100
9000
FINANCE
PERSONNEL
INVENTORY
SHIPPING
..
PLANNING
CORPORATE
23
213
32
234
..
87
1
MGRLIST View
FNAME LNAME DEPTNAME
JERRY
ROBERT
THOMAS
..
ROGER
HOWARD
WHITE
RUTLOFF
..
GREEN
FINANCE
PERSONNEL
INVENTORY
..
CORPORATE
Adaptabilty to
Business Needs
As your business expands, your NonStop SQL database can grow, adapting itself to
new and different business needs. Database administrators can add and alter data
definitions to meet new requirements. Programmers can add new functions to an
application without rewriting existing programs that use the same data.
All objects in a NonStop SQL database are defined by the database’s data dictionary.
This is an active dictionary. The dictionary ensures that changes to the database
become immediately available to all users, while existing applications continue to run
regardless of the changes. For instance, if you add a new column to a table and then
load that column with data, applications that need these new values can use them at
once; applications that do not need them can continue running as if the changes had
never been made.
NonStop SQL is very versatile, and is useful for large production OLTP applications
as well as small data center applications and ad hoc report generation. A single
NonStop SQL database can serve all kinds of applications, including those distributed
over large computer networks as well as those that run on one central machine.