Browse Prior Art Database

Automating Database Implementation

IP.com Disclosure Number: IPCOM000115297D
Original Publication Date: 1995-Apr-01
Included in the Prior Art Database: 2005-Mar-30
Document File: 2 page(s) / 73K

Publishing Venue

IBM

Related People

Bryans, GE: AUTHOR

Abstract

A program is disclosed that automates the implementation of an Oracle Parallel Server* (OPS) database on an IBM* Scalable Parallel** (SP2) computer system.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Automating Database Implementation

      A program is disclosed that automates the implementation of an
Oracle Parallel Server* (OPS) database on an IBM* Scalable Parallel**
(SP2) computer system.

      An OPS SP2 system can best be described as a shared-everything
system where OPS datafiles are presented across the entire SP2
system.  The vehicle for this presentation is the IBM Virtual Shared
Disk** device driver.  The following diagram shows the relationship
between an OPS object and a disk datafile:

      The implementation of an OPS database requires the issuance of
hundreds and sometimes thousands of AIX**, SP2, VSD, and OPS
commands, following evaluation of the target computer's configuration
and extensive analysis of the database to be implemented.

      These commands are usually created in advance of the
implementation, and grouped into files to ease the implementation
process.  Commands must address the implementation of each SP2 member
computer (node), disk drive, disk subsystem, VSD, and OPS object.
Typically, the process of creating these files takes more than 3 man
days to complete.

      Even when performed by skilled and experienced personnel, there
is a high probability that analytic and/or typographic errors will
negatively impact the implementation process in terms of both
accuracy and timeliness.

      This program performs the required analysis and command
generation, usually in less than 30 seconds.  The program reads 4
datafiles provided by the implementer which describe:
  o  the hardware platform and it's disk resources;
  o  the database objects to be implemented;
  o  the size and class of each database object; and
  o  the desired distribution of each database object.

      The hard...