Browse Prior Art Database

Database Administration Workbench

IP.com Disclosure Number: IPCOM000103092D
Original Publication Date: 1990-Jun-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 1 page(s) / 35K

Publishing Venue

IBM

Related People

Churchill, WE: AUTHOR

Abstract

Disclosed is a method for managing a database management system utilizing the concept of a workbench for controlling data consistency and improving the productivity of database administrators.

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

Database Administration Workbench

      Disclosed is a method for managing a database management system
utilizing the concept of a workbench for controlling data consistency
and improving the productivity of database administrators.

      The workbench utilizes a menu structure wherein a user selects
the desired function and data entry panels in which required
information is entered.  The workbench then selects the job to be
processed, retrieves information from the design data dictionary, and
generates an appropriate job stream.  Each job stream has a model
which is stored in a skeleton format.  The skeleton is modified with
information supplied by the user.  It is also modified by information
retrieved from a data dictionary as well as from constants which are
stored in the workbench.  The complete job stream then contains the
statements necessary to complete all the tasks required by the job in
either batch or on-line mode.

      In operation, the workbench collects data from the user and
verifies the data as well as verifying the user's authority to
perform the task.  The workbench then collects and assembles all
additional required data from a design data dictionary and builds the
job stream or streams to execute the task and determines the order of
execution.

      Disclosed anonymously.