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-10

SQL/MX Database Object Types

Table 1-2 describes SQL/MX object types. For information about SQL/MP objects, see

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

Table 1-2. SQL/MX Object Types (page 1 of 2)

SQL/MX Object

Type Description

Table A logical representation of data in which a set of records is

represented as a sequence of rows, and the set of fields

common to all rows is represented by columns. A column is

a set of values of the same data type with the same

definition. The intersection of a row and column represents

the data value of a particular field in a particular record.

Every table must have one or more columns, but the

number of rows can be zero. There is no inherent order of

rows within a table.

An SQL/MX table is described in an SQL/MX schema and its

data is stored in one or more physical files in the Guardian

environment. An SQL/MX table name must be a fully

qualified ANSI name of the form:

catalog-name.schema-name.object-name

View A table that has a logical name and an associated physical

file that resides in the Guardian environment. A view is

derived from a query that determines how to create the view

contents from other tables or views. SQL/MX views conform

to the ANSI/ISO/IEC 9075:1999 SQL standard, more

commonly referred to as SQL:1999, for their definition and

security.

Index An alternate access path to a table (alternate key) that

differs from the primary access path (clustering key) defined

when the table was created. An SQL/MX index includes

columns for the alternate key and the underlying table’s

clustering key.

Stored procedures in

Java (SPJs)

A stored procedure is an type of user-defined routine (UDR)

that operates within a database server. NonStop SQL/MX

supports stored procedures written in the Java language

(SPJs). The body of an SPJ is a static Java method, which

is stored in a class file either inside or outside a Java

archive (JAR) file in the OSS file system. An SPJ is

registered in NonStop SQL/MX and invoked by NonStop

SQL/MX when an application issues a CALL statement.

For more information about SPJs, see the SQL/MX Guide to

Stored Procedures in Java.