HP 3000 Manuals

DATABASE TOOLS [ COMMUNICATOR 3000/XL Release 1.2, Version A.20.10 ] MPE/iX Communicators


COMMUNICATOR 3000/XL Release 1.2, Version A.20.10

Chapter 6  DATABASE TOOLS 

ALLBASE/NET is Available 

by Stacia Fujimoto--Data & Languages Division/DDL 

ALLBASE/NET is a new product which allows applications (such as ISQL) on
one MPE XL machine to access ALLBASE HP SQL DBEnvironments on another MPE
XL machine across a Local Area Network (LAN).

The following applications can use ALLBASE/NET to access a remote HP SQL
DBEnvironment:

 *  ISQL
 *  HP SQL Preprocessors
 *  User-written application programs
 *  ALLBASE/QUERY
 *  ALLBASE/4GL

ALLBASE/NET PRODUCT DESCRIPTION 

In ALLBASE/NET, the local machine is called a client node and the remote
machine is called a server node.  The client node is a system running an
application that accesses a remote DBEnvironment.  The server node is a
system that contains a DBEnvironment which is accessed by an application
on another machine.  A system can also serve as both a client and a
server node.  These three types of nodes are shown as nodes A, B, and C
in Figure 1 on the following page.

Node A is a client node because it is set up to access a database
remotely on a server node, Node B.

Node B is both a client and a server node.  It is a client because it
accesses a remote database on Node C. It is also a server node because it
contains a DBEnvironment which is accessed from a client node, Node A.

Node C is a server node because it contains a database which is accessed
from a client node, Node B.

[]
Figure 1: Node as Client and Server Remote database access with ALLBASE/NET offers several advantages over using a database locally: * A database can be maintained on one system while users are distributed over several systems. This improves the transaction throughput for each user by spreading the load over multiple machines. * Having the database on a single system saves disc space and avoids problems associated with keeping multiple databases on different systems current. * ALLBASE/NET allows more flexibility for database administrators. Since the location of the database (that is, which system it is physically located on) is transparent to the users, administrators can move it from one system to another without causing users to modify their applications. * Applications can be developed on a system other than the production database machine, and then moved into production upon completion without impacting database users. ADDITIONAL INFORMATION More information about ALLBASE/NET (HP30604A) is available in the ALLBASE/NET User's Guide (P/N 36216-60016).


MPE/iX Communicators