SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-19
NonStop SQL/MP conversational interface
All NonStop SQL/MP components on the same node must have the same software
version.
NonStop SQL/MP conversational interface. See SQLCI (SQL conversational interface)
.
NonStop SQL/MP database. A database created by NonStop SQL/MP software. Each
NonStop SQL/MP database is a collection of tables containing data, all objects that
depend on the tables, all objects that the tables depend on, all catalogs in which the
tables and objects are registered, and all associated file labels. More than one database
can be on a node, and each database can span more than one node.
NonStop SQL/MP executor. See executor
.
NonStop SQL/MP optimizer. See optimizer
.
NonStop SQL/MP software. The set of software components that make up
NonStop SQL/MP. See NonStop SQL/MP component
.
NonStop SQL/MP software version. See software version
.
NonStop SQL/MP system version. See software version
.
NSSQL/MP (NonStop SQL/MP). The Compaq relational database management system
(RDBMS) that promotes efficient online access to large distributed databases.
NonStop SQL/MP includes a data dictionary; the SQL language for definition, retrieval,
manipulation, and control of data; a programmatic interface; a conversational interface;
a report writer; and a set of utilities.
null value. A value that represents a missing or unknown value in a column of a table.
null-augmented row. In a left join operation, a row that has been extended with null values
so that data from the table on the left of the keywords LEFT JOIN is preserved in the
result table. These rows fail to satisfy the specified search condition but are preserved
through the process of null augmentation.
numeric data type. A data type for data composed of numbers, stored either in binary form
or as ASCII characters. Contrast with character data type
.
numeric literal. Data composed of numbers. A numeric literal has the data type NUMERIC.
OBEY command file. An EDIT file containing statements or commands you can execute by
specifying the file in an SQLCI OBEY command.
object. A database entity that is created, manipulated, or dropped by SQL statements and that
is described in an SQL catalog. SQL objects are tables, views, indexes, collations, and
constraints. (SQL programs and catalogs are not objects.)
object version. A version indicating the oldest version of NonStop SQL/MP software that
can support the object. The object version is determined by the features associated with
the object and any dependent objects.