SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-35
SQL:2003
SQL:2003. The American National Standards Institute (ANSI) version of SQL (structured
query language) that includes additional object-oriented features. SQL:2003 is the
latest version of the standard. SQL:2003 enables developers to apply SQL databases
to problems that are too complex to address with the older, purely relational paradigm.
SQL/MP. The NonStop relational database management system (RDBMS) that was first
introduced in 1987. SQL/MP includes system metadata; the SQL language for
definition, retrieval, manipulation, and control of data; a programmatic interface; an
SQL conversational interface (SQLCI); and a set of utilities.
SQL/MP alias. A mapping from an ANSI-defined name to the physical names of an
SQL/MP table or view. The SQL/MP alias name is a three-part alias name and must
contain catalog and schema names that represent actual SQL/MX ANSI catalogs and
schemas. The object name for an SQL/MP alias identifies the object. The alias
information for each schema is stored in the SQL/MX metadata for that schema. See
also catalog, schema, and object.
SQL/MP conversational interface (SQLCI). See SQLCI.
SQL/MP database. A database created by SQL/MP that can be accessed by the SQL/MP
or SQL/MX engine. Each database is a collection of tables containing data, all objects
that depend on the tables, all objects that the tables depend on, all metadata in which
the tables and objects are described, and all associated file labels. More than one
database can be on a node, and each database can span more than one node.
SQL/MX. The NonStop relational database management system (RDBMS) that promotes
efficient online access to large distributed databases. SQL/MX includes user metadata;
the SQL language for retrieval, manipulation, and control of data; a programmatic
interface; an SQL conversational interface (MXCI); and a set of utilities. Release 1 of
SQL/MX can access an SQL/MP database, Release 2 of SQL/MX can access SQL/MP
and SQL/MX databases.
SQL/MX administrative command library (MACL). See MACL.
SQL/MX catalog manager. The SQL/MX component that manages the metadata and
physical structures of database objects. The SQL/MX catalog manager performs DDL
statements that create, alter, and drop SQL/MX objects. It is also responsible for
granting and revoking security privileges on SQL/MX objects.
SQL/MX connectivity services (MXCS). See
MXCS.
SQL/MX conversational interface (MXCI). See MXCI.
SQL/MX executor. See executor.
SQL/MX language manager. An application programming interface (API) that the SQL/MX
UDR server calls to load, invoke, and unload a stored procedure in Java (SPJ).
SQL/MX module. See module.