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