HP 3000 Manuals

General Information Manual

Data Management 

The HP 3000 leads the industry in providing high-performance database
management systems to deliver superior business solutions.  These DBMSs
are tightly integrated with Precision Architecture-RISC and the HP 3000
operating environment to provide the best system price/performance and
superior data integrity in the industry.

Hewlett-Packard offers compatible relational and network model databases
across the entire HP 3000 900 Series family of business systems:

   *   HP ALLBASE/SQL is HP's strategic, high-performance relational
       database management system (RDBMS) based on the ANSI and X/Open
       industry-standard SQL relational language.
   *   HP TurboIMAGE is the best-performing network model DBMS on the HP
       3000.
   *   HP ALLBASE/Turbo CONNECT provides ALLBASE/SQL users read access to
       TurboIMAGE data concurrent with OLTP applications.
   *   HP ALLBASE/NET delivers transparent and secure remote database
       access to ALLBASE/SQL data.
   *   HP ALLBASE/DB2 CONNECT links PC users and database administrators
       to both ALLBASE/SQL and IBM DB2 data in a client-server
       configuration.
   *   HP KSAM is the HP 3000's keyed file management system.
   *   Popular third-party relational DBMSs are also available.

HP ALLBASE/SQL 

HP ALLBASE/SQL is HP's industry-standard RDBMS for application solutions
in high performance OLTP environments on HP 3000 900 Series business
computers.  HP ALLBASE/SQL provides the following features:

   *   the best relational price/performance on the HP 3000
   *   open interoperability and portability with multivendor tools and
       databases
   *   superior reliability, data integrity, and supportability


          Figure 4-1.  HP ALLBASE/SQL: The Open Choice OLTP RDBMS 

Best performance.   

HP ALLBASE/SQL delivers the best-performing and lowest cost OLTP
relational database solutions on the HP 3000 .  Hewlett-Packard has
achieved superior performance through tight integration with PA-RISC and
the 900 Series operating environment and will continue to improve
performance with new releases of ALLBASE/SQL and HP 3000 systems.  This
means that you can achieve your business objectives on a smaller, more
cost-effective HP 3000 system than you could from other vendors' larger,
more costly systems.  HP was the first vendor to publish the Transaction
Processing Council's TPC-A industry-standard benchmark and continues to
lead the competition in system price/performance.  HP also offers
performance consulting to design and tune your applications for peak
performance.

Open interoperability and portability.   

HP ALLBASE/SQL delivers interoperability and application portability
through adherence to industry standards and support for a variety of
industry-leading application development toolsets.  Hewlett-Packard is a
leading proponent of SQL standards and continues to enhance ALLBASE/SQL
in compliance with ANSI and X/Open standards.  Moreover, ALLBASE/SQL
supports development tools from HP and leading multivendor third-parties,
so you can choose the application development solution that best meets
your needs.  By providing you the choice of third-generation and
fourth-generation development environments, ALLBASE/SQL protects and
leverages your existing hardware, applications, and development staff
investments.

HP ALLBASE/SQL also protects your existing investments through gateway
products such as HP ALLBASE/TurboIMAGE and HP ALLBASE/DB2 CONNECT. These
products allow your ALLBASE/SQL application to share data with other
databases and systems in your business environment.  As a founding member
of the SQL Access Group, HP is expanding ALLBASE/SQL interoperability to
include industry-standard access to Ingres, Oracle, DEC's Rdb, and the
many other relational databases whose vendors make up the SQL Access
Group.

Superior reliability, data integrity, and supportability.   

You can entrust your business-critical applications to HP ALLBASE/SQL.
ALLBASE/SQL delivers maximum reliability, superior data integrity,
and high availability through tight integration with Precision
Architecture-RISC and the HP 3000 operating system.  PA-RISC is designed
with fewer components than traditional computers, which provides higher
reliability than traditional computers.  The HP 3000 900 Series is
designed with OLTP features for reduced I/O requirements, high data
concurrency, and high system and database availability.  And an
ALLBASE/SQL solution means a single point of contact and award-winning HP
support for quick resolution of database and system difficulties.  For
information on ALLBASE/SQL utilities, please see the CASE maintenance
section later in this chapter.

Key features of ALLBASE/SQL include the following: 

   *   peak performance through features such as hashing, query
       optimization, and balanced B-tree indexes
   *   supports major, industry-leading 4GL tools from Cognos, Gateway
       Systems, Infocentre, Information Builders, and Ingres
   *   industry-standard ANSI and X/Open SQL for data definition and data
       manipulation
   *   interactive SQL (ISQL) interface for simplified query and update
       of data without programming
   *   HP NewWave Access integration for downloading data to the PC
       environment for decision support applications
   *   language preprocessors that provide application access and update
       capabilities for COBOL, C, Pascal, and FORTRAN
   *   dynamic restructuring allows the database structure, table
       capacities, and security to be changed without unloading and
       loading the database
   *   online backup, referential integrity checks, and rollforward and
       rollback recovery guarantees logical and physical data integrity
       in the event of hardware and software failures
   *   foundation for a growing number of industry-leading application
       solutions

HP TurboIMAGE 

HP TurboIMAGE is one of the most heavily used, high-performance network
database management systems for OLTP applications in the industry.  HP
continues to support and enhance TurboIMAGE as a core product of the
HP 3000 computer systems with performance improvements and new
functionality.  HP TurboIMAGE/XL is the version for the HP 3000 900
Series computers.

HP TurboIMAGE consists of three components:  a data definition language,
a data manipulation language, and database utilities.  TurboIMAGE
databases can be accessed programmatically through powerful application
interfaces, called intrinsics, or interactively from HP NewWave Access
and an integrated query tool.

Key features of HP TurboIMAGE are as follows: 

   *   HP TurboIMAGE intrinsics are callable from COBOL, C, FORTRAN,
       Pascal, RPG, BASIC, Business BASIC, and fourth-generation
       languages.
   *   HP NewWave integration for downloading data to popular PC
       applications for decision support analysis.
   *   Three logging and recovery methods (intrinsic-level, rollback, and
       rollforward) ensure logical and physical data integrity in the
       event of a system failure.
   *   Remote database access (RDBA) allows transparent access to
       TurboIMAGE databases across the network.
   *   Multiple database transactions provide the capability for a
       transaction to span two or more databases.
   *   Dynamic rollback recovery on TurboIMAGE/XL provides added
       flexibility by allowing users to roll back a transaction
       programmatically.
   *   Generic key search and generic keyword retrieval will be available
       in the near future.

HP DBChange Plus is a powerful TurboIMAGE/XL database administration tool
that simplifies the tasks of database restructuring, maintenance, and
analysis.  DBChange Plus provides superior database repair from broken
chains down to the bitmap level.  For more information, please refer to
the CASE maintenance section later in this chapter.

For customers who are interested in using relational technology while
preserving their investments in TurboIMAGE, HP ALLBASE/Turbo CONNECT
provides a standards-based, read-access interface to TurboIMAGE data,
using the ALLBASE/SQL language or commands.

HP ALLBASE/Turbo CONNECT 

HP ALLBASE/Turbo CONNECT provides coexistence between ALLBASE/SQL and
TurboIMAGE by allowing ALLBASE/SQL applications to read TurboIMAGE
databases.  With ALLBASE/Turbo CONNECT, customers can preserve and
leverage investments in TurboIMAGE/XL applications while reaping the
benefits of relational technology through ALLBASE/SQL. A single,
industry-standard SQL interface allows access to both types of data.

Key features of HP ALLBASE/Turbo CONNECT are as follows: 

   *   Flexible access to TurboIMAGE/XL data with SQL syntax
   *   Concurrent access with existing TurboIMAGE OLTP applications
   *   HP ALLBASE/NET interoperability, enabling access to TurboIMAGE
       data across the network
   *   Automatic data type conversion from TurboIMAGE to ALLBASE/SQL
   *   Optional translation of TurboIMAGE/XL databases into ALLBASE/SQL
       databases


          Figure 4-2.  HP ALLBASE/Turbo CONNECT 

HP ALLBASE/NET 

HP ALLBASE/NET provides ALLBASE/SQL users transparent access to remote
ALLBASE/SQL data as though it were stored locally.  The first step in
providing ALLBASE/SQL support for a truly distributed database
environment, ALLBASE/NET allows applications running on an HP 3000 or HP
9000 client to transparently read and write to ALLBASE/SQL tables on an
HP 3000 server across the network.  Since database access is completely
transparent to the user and the application, developers can write code
without having to know where the actual database resides.

Key features of HP ALLBASE/NET are listed below: 

   *   Transparent access to remote ALLBASE/SQL tables across a network
   *   Client-server capability, including HP 9000 HP-UX systems
   *   Flexibility to move databases across systems without requiring any
       changes to existing applications
   *   No special linking required to create applications that access
       remote data

HP ALLBASE/DB2 CONNECT 

HP ALLBASE/DB2 CONNECT extends the open interoperability of ALLBASE/SQL
and the HP 3000 to include links to IBM databases.  ALLBASE/DB2 CONNECT
allows PC end users and database administrators to access both
ALLBASE/SQL data and IBM DB2 data at the same time from a single session.

PC end users can use ALLBASE/DB2 CONNECT in conjunction with NewWave
Access to download DB2 data to the PC environment, where they can
integrate it with powerful PC productivity tools like Lotus 1-2-3, dBASE,
and HP Graphics Gallery.  Database administrators can use the same HP
Interactive SQL (HP ISQL) interface that they use with ALLBASE/SQL to
read and update IBM DB2 databases as well.

HP KSAM 

HP KSAM (keyed sequential access method) allows the creation and
maintenance of disk files whose records are accessed by the value of the
key fields within the data records.  Each data record contains one
primary key field and may include up to 15 alternate key fields.  Records
are accessed sequentially or randomly by primary or alternate key value,
by logical record number, or in chronological (physically sequential)
order.  Duplicate key values are allowed, and records can be accessed by
generic keys (partial key values) or by approximate keys.

ISV databases 

The HP 3000 operating environment also supports major multivendor
databases, including Ingres, Oracle, and Sybase.  These independent
software vendor (ISV) products provide a common development environment
across a range of platforms.

MPE/iX 5.0 Documentation