DSQL - Distributed SQL
Version 3
Scientific Computing Technology Development Group
Genentech, Inc.
DSQL is a simple client/server protocol to support remote access of SQL
databases. DSQL was designed to be easy to implement, yet provide most
of the functionality needed to support distributed applications which
require access to centralized databases. DSQL was designed in response
to a perceived need at Genentech to provide graphical front-ends on
Macintosh computers to our Informix relational databases running on
Unix servers. As a result, the protocol is tailored to the execution
of simple SQL queries resulting in textual data. Version 3 of the protocol
also supports creation and access to SQL cursors.
The DSQL protocol is simple to implement, easily portable across
platforms and architectures, but does not provide explicit support for
some of the "tough" issues in distributed databases such as
cross-machine joins, a transaction processing model, and an
architecture-neutral binary data format. Version 3 of DSQL does
provide the client with access to host files, and a simple facility for
remote execution. In addition to some limited access to
getting/setting environment variables on the host.
DSQL version 3 is distributed with 2 server implementations and four
client library implementations. The API for the client libraries has
been standardized, and the client code is divided into portable and
architecture-specific portions. Currently servers exist for
Unix/Informix and VMS/Oracle. Client implemetations exist for Unix,
Macintosh, MS-DOS, and MS-Windows. In addition, a set of Hypercard
XCMDs has been written allow use of the Macintosh DSQL client from
Hypercard.
DSQL is NOT public domain, although Genentech provides DSQL free-of-charge
and with no use restrictions. DSQL may be obtained via anonymous ftp from
cgl.ucsf.edu (128.218.14.2).
Original Authors:
David Mischel
Scooter Morris
Terry Oberzeir
Kathryn Woods
Current DSQL Team:
Jim Fitzgerald
David Mischel
Scooter Morris
Terry Oberzier
VMS/Oracle support provided by:
Dan Lamb
|