HP 3000 Manuals

GLOSSARY [ Information Access SQL/iX ] MPE/iX 5.0 Documentation


Information Access SQL/iX

GLOSSARY 

Access SQL/UX 
An application running on HP 9000 Series 600, Series 700, and Series 800
computers that gives PC users acess to ALLBASE/SQL, ORACLE, INGRES,
INFORMIX, and PROGRESS tables.

Access SQL/iX 
An application running on HP 3000 Series 900 computers that gives PC
users access to ALLBASE/SQL, ORACLE, and INGRES tables.

Access Server 
An application running under MPE V or MPE/iX on the HP 3000 that gives
Information Access users access to IMAGE data and MPE and KSAM files
formatted as relational tables.  Access Server includes the software that
interacts with Information Access, the data dictionary that defines the
Access Server environment, the two utilities used to manage the data
dictionary, and the Host Batch Facility.

ALLBASE/SQL 
The SQL database management system that resides on HP 3000 Series 900 and
HP 9000 Series 600 and Series 800 computers.

authority 
A permission granted to a user or a program to perform a specific
database operation, such as accessing certain tables.  ALLBASE/SQL uses
authorities to safeguard databases from access by unauthorized users and
programs.

CONNECT Authority 
CONNECT authority allows a user to access a DBEnvironment.  A user with
CONNECT authority has all table and view authorities that may have been
granted to the special user PUBLIC.

database 
An organized collection of related files that contain data.  The data in
a relational database is organized in tables.

DBEnvironment 
A DBEnvironment contains the DBEFiles for one or more ALLBASE/SQL
databases, plus other entities that contain information for all databases
in the DBEnvironment.

HP Information Access 
See Information Access.

HP Sockets (WSOCKETS.DLL) 
An HP version of Berkeley Sockets.

HP-UX 
HP-UX is the Hewlett-Packard version of the UNIX(R) operating system.

Information Access Server 
See Access Server.

Information Access SQL/UX 
See Access SQL/UX.

Information Access SQL/iX 
See Access SQL/iX.

INGRES Relational Database Management System [REV BEG] 
A general-purpose SQL system that resides on the HP 3000 Series 900 and
HP 9000 Series 600, Series 700, and Series 800 computers.  [REV END]

ISQL (Interactive Structured Query Language) 
A facility for interactively accessing and using ALLBASE/SQL databases
and tables.

local table 
A table of data that resides on the PC or a shared disk, as opposed to a
remote table, which resides on a remote server (such as Access SQL/iX on
the HP 3000).  (See also remote table.)

Information Access 
A graphical interface PC application running in the NewWave and Windows
environments on the HP Vectra, supported IBM PCs, or supported Compaq
PCs.  It gives PC users access to ALLBASE/SQL, ORACLE, and INGRES tables
by interacting with Access SQL/iX on the HP 3000 or with Access SQL/UX on
the HP 9000.  It also gives PC users access to IMAGE databases and MPE
and KSAM files by interacting with Access Server on the HP 3000 running
under MPE V and MPE/iX. PC users can reformat the data and output the
results to their PC.

ORACLE Relational Database Management System 
An SQL database management system that resides on the HP 3000 Series 900
and HP 9000 Series 600 and Series 800 computers.

remote table 
A table of data that resides on a remote server (such as Access SQL/iX on
the HP 3000), as opposed to a local table, which resides on a PC or a
shared disk.  (See also local table.)

SELECT Authority 
Allows a user to retrieve data from one or more tables or views.

SQL*NET 
The ORACLE communications component that allows applications to connect
to multiple ORACLE databases across a network.  Access SQL/iX supports
SQL*NET for accessing remote databases from Information Access.

WINSOCK 
WINSOCK is a Microsoft implementation of Berkeley Sockets.  It is
becoming a standard PC interface to networking services.



MPE/iX 5.0 Documentation