Jump to content

Remote Database Access

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by GreenC bot (talk | contribs) at 06:42, 5 September 2016 (WaybackMedic 2). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Remote database access (RDA) is a protocol standard for database access. Despite early efforts to develop proof of concept implementations of RDA for major commercial RDBMSs (including Oracle, Rdb, NonStop SQL and Teradata),[1] this standard has been largely ignored by commercial database vendors.[2]

Purpose

RDA describes the connection of a database client to a database server. It includes features for

  • communicating database operations and parameters from the client to the server,
  • in return, transporting result data from the server to the client,
  • database transaction management.
  • exchange of information.

RDA is an application-level protocol, inasmuch that it builds on an existing network connection between client and server. In the case of TCP/IP connections, RFC 1066 is used for implementing RDA.

History

RDA was published in 1993, as a combined standard of ANSI, ISO and IEC. The standards definition comprises two parts:

  • ANSI/ISO/IEC 9579-1:1993
  • ANSI/ISO/IEC 9579-2:1993

References

  1. ^ Arnold, D.; Cannata, P.; Glasson, L.A.; Hallmark, G.; McGuire, B.; Newman, S.; Odegard, R.; Sabharwal, H. (1991). "SQL Access: an implementation of the ISO Remote Database Access Standard". Computer. 24 (12): 74–78. doi:10.1109/2.116891. ISSN 0018-9162.
  2. ^ Jim Melton; Alan R. Simon (2002). SQL:1999: Understanding Relational Language Components. Morgan Kaufmann. p. 843. ISBN 978-1-55860-456-8. RDA, even after revision to remove the OSI dependencies (and replace them with a TCP/IP orientation), has not proven to have commercial support.

Sources