Browse Prior Art Database

User Interface for Database Command Line Applications

IP.com Disclosure Number: IPCOM000108013D
Original Publication Date: 1992-Apr-01
Included in the Prior Art Database: 2005-Mar-22
Document File: 2 page(s) / 96K

Publishing Venue

IBM

Related People

Shrader, TJL: AUTHOR

Abstract

Disclosed is a command line interface that enhances the productivity of the database user by allowing users to connect to multiple databases at one time and easily execute commands.

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

User Interface for Database Command Line Applications

       Disclosed is a command line interface that enhances the
productivity of the database user by allowing users to connect to
multiple databases at one time and easily execute commands.

      The traditional user interface to the command line may be
suitable to a wide range of command line programs. However, using
this interface with a command line program that runs against
databases has a significant limitation; it can only execute commands
against one database at a time. This is because of the nature of the
interface and the architecture of its underlying program.

      The traditional user interface takes the command and sends it
to the system command processor.  It makes no distinction as to the
type or category of the command.  This means that once the user
connects to a database, the user can only execute commands against
the same database.  To execute a command against another database,
the user must disconnect from the current database, connect to the
new database, and then issue the command.

      To allow the user to connect to multiple databases at the same
time, the user interface must be upgraded and it must modify its
supporting code to account for its new abilities.  The new command
line user interface window will contain four panes.  The Command Pane
will be placed at the top of the window and this is where commands
may be typed and executed.  Immediately below it are the Command List
Pane and Database List Pane.  The Command List Pane sits on the left
and acts as a library.  It stores the commands that the user already
executed to allow the user to return to a previous command to modify
or reexecute it without having to retype the entire command.  Beside
it rests the Database List Pane which stores a list of databases to
which the user has connected.  At the bottom lies the Output Pane,
which displays the output of the executed command from the Command
Pane or the output of a batch of commands from the Command List Pane.

      By selecting an option from the action bar, for example, the
user can indicate that database commands will be executed.  Thus,
whenever the user issues a command to connect to a database, the
...