Browse Prior Art Database

OS/2 EE Database Manager SQLJRA Remote Protocol

IP.com Disclosure Number: IPCOM000103572D
Original Publication Date: 1993-Jan-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 4 page(s) / 166K

Publishing Venue

IBM

Related People

Brissette, LF: AUTHOR [+5]

Abstract

Disclosed is a design of Remote Data Service Component of OS/2* Database Manager. Remote Data Service is a set of functions for OS/2 Extended Edition (EE) that allowed users to access databases not only on their local workstations but also on remote workstations. A private communication protocol (DRDA-0) was implemented in 1.3 EE to access relational database remotely. DRDA-0 is based on Distributed Relational Database Architecture (DRDA), which is the architecture for connecting database products. DRDA basically makes use of an intermediate language defined in Distributed Data Management (DDM) architecture to pass information back and forth from client to server.

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

OS/2 EE Database Manager SQLJRA Remote Protocol

       Disclosed is a design of Remote Data Service Component of
OS/2* Database Manager.  Remote Data Service is a set of functions
for OS/2 Extended Edition (EE) that allowed users to access databases
not only on their local workstations but also on remote workstations.
A private communication protocol (DRDA-0) was implemented in 1.3 EE
to access relational database remotely.  DRDA-0 is based on
Distributed Relational Database Architecture (DRDA), which is the
architecture for connecting database products.  DRDA basically makes
use of an intermediate language defined in Distributed Data
Management (DDM) architecture to pass information back and forth from
client to server.

      Performance results showed that DRDA-0 performed poorly in a
homogeneous environment (OS/2 EE client to OS/2 EE server).  The main
reason for the poor performance is because of the translation
overhead from the internal data structure to DDM commands and vice
versa.

      The design of SQLJRA remote protocol takes advantage of the
fact that the data structures built on either the client or the
server in a homogeneous environment are the same.  Therefore, the
underlying data structures are passed directly, without the
conversion step being necessary.  In summary, the SQLJRA remote
protocol has the following advantages:
(1) Much simpler design to achieve optimum performance.  Data is
passed in its native form.  Performance results showed that the
SQLJRA client and server ran four times faster than DRDA-0 client and
server.  It also achieves up to 56 percent speed-up in throughput and
36 percent speed-up in end-user response time.
(2) Smaller client and server.  Because of the simple design,
developers can implement full Remote Data Services functions with
only one fourth of the DRDA-0 code (3000 C statements versus 12,000 C
statements).  Thus, it helps reduce the RAM and disk space required
for both the client and the server.
(3) Easy vendor connection.  This protocol makes use of the published
SQLJRA interface to connect clients and servers.  The vendor can
connect to database servers or clients easily through this published
gateway interface.
(4) Portable design and implementation.  The SQLJRA control block
structure used is environment independent.  The design also uses the
OSS (Operating System Services) provided in ES 1.0 Database Manager.
OSS provides a platform-independent operating system interface for
the OS/2 Database Manager common code development.  The SQLJRA client
and server can be easily ported to other platforms (e.g., AIX*) with
OSS support.

      The precompiler in the OS/2 ES 1.0 Database Manager takes
source language SQL statements and maps those statements into
Database Manager application programming interfaces (APIs).  For each
SQL statement there are one or more procedure calls which create a
series of data structures for the database call.  These data
struct...