Browse Prior Art Database

Put Dari Procedure for the OS/2 Database Manager

IP.com Disclosure Number: IPCOM000121718D
Original Publication Date: 1991-Sep-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 3 page(s) / 91K

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR

Abstract

Introduction A method is described which will provide a facility, for use in the homogeneous OS/2* environment, to move server procedures used in Database Application Remote Interface (DARI) to the node at which the database to be manipulated by the procedure resides. This is the node at which the procedure will be executed. This facility will be known as the Put DARI Procedure. Background

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

Put Dari Procedure for the OS/2 Database Manager

      Introduction
A method is described which will provide a facility, for use in the
homogeneous OS/2* environment, to move server procedures used in
Database Application Remote Interface (DARI) to the node at which the
database to be manipulated by the procedure resides.  This is the
node at which the procedure will be executed.  This facility will be
known as the Put DARI Procedure.
Background

      With future trends heading towards a heavy client[server
environment, it is not difficult to see that the amount of network
activity will directly affect the performance of the overall Database
Management System (DBMS).  To combat this anticipated performance
degradation and increase the throughput of the Distributed DBMS, the
OS/2 Database Manager provides a facility to execute the function on
a remote node.  This facility, known as the Database Application
Remote Interface (DARI), furnishes the means to execute a
user-generated "stored function" remotely against a specified
database.  A stored function is a program which is created by the
user and is built into a Dynamic Link Library (DLL) or a REXX command
file.

      Applications using DARI can drastically reduce network traffic
by reducing both the quantity of data and the number of trips used to
send it across the  network.  This results in improved application
throughput and user response time. Applications executing SQL
statements that can be grouped together in a server procedure will
also benefit.  With one function call, all of the SQL statements
(located at the server and contained in the server procedure) are
executed.
Problem

      In the distributed environment, the nodes which make up the
DBMS can be geographically located great distances apart.  In this
environment, how does the Administrator transport the server
procedure on the remote nodes where the database resides?
Solution

      To aid the Administrator, the Put DARI Procedure facility will
be provided.  This command line interface utility will transport the
DLL or CMD file  containing the server procedure to the node where
the data...