Browse Prior Art Database

Parallel Database Manager Environment Functions

IP.com Disclosure Number: IPCOM000112163D
Original Publication Date: 1994-Apr-01
Included in the Prior Art Database: 2005-Mar-26
Document File: 2 page(s) / 87K

Publishing Venue

IBM

Related People

Chang, DY: AUTHOR [+2]

Abstract

Disclosed is a method to create the database environment in the parallel database manager. The database environment functions include Create/Drop Database, Start Using Database, and Stop Using Database.

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

Parallel Database Manager Environment Functions

      Disclosed is a method to create the database environment in the
parallel database manager.  The database environment functions
include Create/Drop Database, Start Using Database, and Stop Using
Database.

      A parallel database manager can be composed of many computers.
The only limit to the number of computers is the hardware
configuration such as the maximum number of the communication
channels.

      The parallel database process model is a message driven
architecture.  There are two message queues in the parallel database
process model: the Database Manager(DBM) queue and the Parallel
Database (PDB) queue.  The DBM queue allows the application processes
to drop the database application requests to the parallel database
server.  The PDB queue receives the internal parallel database
requests from the other parallel database server computers.  A single
pool of SQL agent processes serves both the DBM queue and the PDB
queue.  The agent process which serves the database application
requests is called a coordinate agent process.  The agent process
which serves the parallel database requests is call a subordinate
agent process.  The parallel database server computer which contains
the coordinate agent process of the database application is called
the coordinate node to the database application.  The database server
computers which contain the subordinate agent processes of the
database application are called the subordinate nodes to the database
application.  The Fast Communication Manager(FCM) process is a
special process to send or receive messages between parallel database
server computers.

      The major data structures in the Parallel Database Process
Model are Application Control Block(ACB), Application State Anchor

Block (ASAB), and Kernel Control Block(KRCB).  Each database
application process has an ACB in the system shared memory when it
calls the Start Using Database function.  The ACB data structure
contains the working data as well as the the state data of each
database component for the application process.  The ASAB data
structure saves the global variables of the database manager for the
application process between each database application r...