HP 3000 Manuals

HP ALLBASE/BRW Reference Manual

Sample Databases 

HP ALLBASE/BRW is supplied with one sample database (TOYDB), an HP
TurboIMAGE/XL database.  Another database (EXDBE) is an example database
for HP ALLBASE/SQL data.  The EXDBE database is not supplied with HP
ALLBASE/BRW.


NOTE  In this manual, the term, IMAGE database, is used to represent both
      IMAGE and HP TurboIMAGE/XL databases.


The TOYDB Database 

This sample HP TurboIMAGE/XL database has been designed for use in the HP
ALLBASE/BRW training course and is the basis for many of the
example screens shown in this manual.  It is usually located in
TOYDB.PUB.ITF3000, but ask your system manager or database manager to be
sure that is the correct location for your system.

TOYDB contains three master data sets:  PRODUCTS, ORDER-MASTER, and
CUSTOMERS; and three detail data sets:  ORDER-DETAILS, ORDERS, and
INVOICES. The diagram below represents the TOYDB database.  Master data
sets are shown as triangles.  All the items in the sample are shown with
their respective types and lengths.


            

The EXDBE Database 

In this manual, a database called EXDBE is used as the basis for several
HP ALLBASE/SQL examples.  This database is an example only, and does not
exist as part of HP ALLBASE/BRW. The following figure shows the
organization of this sample database.


            

If you would like to try some sample reports from a real HP ALLBASE/SQL
database, use the PARTSDBE database provided with HP ALLBASE/SQL.

The PARTSDBE Database 

The HP ALLBASE/SQL database PARTSDBE.SAMPLEDB.SYS is composed of tables
that contain data on parts and vendors.  The database is supplied with HP
ALLBASE/SQL. It is organized like this:


            
[REV BEG]

MPE/iX 5.0 Documentation