SQL/MP Glossary

Glossary
Compaq NonStop™ SQL/MP Glossary—429832-001
Glossary-6
Data Build product
Data Build product. A Compaq product for converting other vendors’ data to Compaq
database structures.
data consistency. The condition of a database when data values agree with one another
according to user-defined criteria. Consistency is one aspect of data integrity.
Data Control Language. See DCL (Data Control Language)
.
data control statement. See DCL statement
.
Data Definition Language. See DDL (Data Definition Language)
.
data definition statement. See DDL statement
.
data dictionary. The set of all related catalogs on a node or on all the nodes in a network and
the corresponding set of file labels; the dictionary for a database. See also distributed
dictionary.
data independence. The ability to change the definition of a database without changing the
applications that use the database. Contrast with program independence
.
data integrity. The condition of a database when its data values are accurate, valid, and
consistent according to rules established for changing the database. Data consistency is
one aspect of data integrity. Contrast with definitional integrity
. See also constraint and
integrity constraint.
Data Manipulation Language. See DML (Data Manipulation Language)
.
data manipulation statement. See DML statement
.
Data Status Language. See DSL (Data Status Language)
.
data status statement. See DSL statement
.
data type. A set of valid values with an associated data format and, for character data, an
associated character set or collation; in relational terminology, a domain. All values in a
column must conform to the format of the column’s data type. Expressions, functions,
host variables, literals, and parameters also have data types.
NonStop SQL/MP provides data types for single-byte and double-byte character strings
of fixed and varying length, binary and decimal numbers, date-time values, and date and
time intervals. See also approximate numeric type
, collation, data-type attribute, date-
time data type, exact numeric type, and NATIONAL CHARACTER data type.
data validation. Checking that data is compatible with a data type, including any format,
character set, and collation associated with the data type.
database. See NonStop SQL/MP database
.
database administrator. See DBA (database administrator)
.