Introduction to Data Management

Glossary
15873 Tandem Computers Incorporated Glossary-13
Service. In PATHMAKER, a unit of work to be performed by a server as part of a
transaction. A service corresponds to a single SEND operation in a PATHWAY
environment.
Shorthand view. In NonStop SQL, a view that can be derived from one or more tables
or views by joining tables or views, by selecting columns, by projecting rows, or by a
combination of these operations; this kind of view can be read but not updated or
secured.
Simulation. In PATHMAKER, the displaying of sequences of screens that provide a
preview of your application in its final form. Through simulation, end users can see
what an application will look like before it is actually coded and installed.
SIO procedures. Sequential I/O procedures. A standard set of procedures for TAL
programmers, used to request I/O operations commonly required in system and
utility programs. These procedures allow these programs to treat different file types
in a consistent and predictable way; they also manage such functions as transfers
involving standard IN and OUT files, BREAK key operations from terminals, file
control block allocation, and other system operations.
Source schema. An EDIT file that contains DDL source statements that describe
records, data items, and other objects in a database. Schemas are useful for submitting
many complex data definitions to the DDL compiler at one time.
SPI. Subsystem Programmatic Interface, a set of procedures for building information
in command, response, and event-message buffers, and for retrieving information
from those buffers. SPI provides Tandem software subsystems such as PATHWAY
and EXPAND with a uniform interface to the applications that run under their
control.
SQL. Structured Query Language. An ANSI-standard and OSI-standard language
used to define, manipulate, and control relational databases. Through the NonStop
SQL software, you can embed SQL statements in programs or enter them as
commands through the SQL conversational interface.
SQL object. In NonStop SQL, any object described in an SQL catalog table, such as a
table, view, index, constraint, or column.
SQLCI (SQL Conversational Interface). In NonStop SQL, a line-oriented terminal interface
that allows a user to enter SQL statements, format and run reports, and operate
database utilities.
Structured file. A key-sequenced, relative, or entry-sequenced file. Each record in a
structured file contains a set of fields. Data transfers between an application and a
structured file are handled in terms of logical records and key fields.
Subsystem Programmatic Interface. See SPI.
SURVEYOR performance measurement tool. A performance measurement tool that accepts
data generated by the MEASURE tool; refines, reduces, and formats this data; and
stores it in a performance database. SURVEYOR allows you to do network analysis
and tuning as well as capacity planning and forecasting.