SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Introduction to SQL/MX Database Management

HP NonStop SQL/MX Installation and Management Guide—523723-004

1-7

Naming Database Objects

ANSI Logical Names

Names for SQL/MX objects are organized hierarchically. Database objects exist in

schemas, which are themselves contained in catalogs. Catalogs are collections of

schemas. Schema names must be unique within a given catalog.

You name tables, views, and other SQL/MX objects by using a three-part ANSI logical

name:

catalog-name.schema-name.object-name

In this three-part name, catalog-name is the name of the catalog, schema-name is

the name of the schema, and object-name is the simple name of the object. Each of

the parts is an SQL identifier.

NonStop SQL/MX automatically qualifies an object name with the current default

catalog and schema name unless you explicitly specify catalog and schema names

with the object name. These terminology guidelines apply to ANSI names:

•

A fully qualified or three-part ANSI name uses all three of its parts

(catalog-name.schema-name.object-name).

•

A two-part ANSI name omits the catalog name (schema-name.object-name).

•

A one-part or simple ANSI name omits the catalog and schema names

(object-name).

The two-part name schema-name.object name is qualified implicitly by the current

default catalog. The one-part name object-name is qualified implicitly by the default

schema and catalog.

For more information about ANSI names, see the SQL/MX Reference Manual.

Guardian Physical Names

The underlying Guardian physical names of SQL/MX and SQL/MP objects are qualified

with the system node, volume, and subvolume names. For example, SQL/MP tables

and views are created with Guardian physical names of the form:

[\node.] [[$volume.]subvol.]filename

In this four-part name, \node is the name of a node on an HP NonStop system,

$volume is the name of a disk volume, subvol is the name of a subvolume, and

filename is the name of a Guardian disk file or the name of an SQL/MP table or view.

SQL/MX data is stored in files with Guardian physical names. In turn, these files are

associated with ANSI names.

For information about using Guardian physical names for SQL/MP objects, see the

SQL/MP Reference Manual and the SQL/MP Installation and Management Guide.