Remote Database Access
Appearance
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
- ^ 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.
- ^ 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
- "Remote Database Access". NIST SQL Project. National Institute of Standards and Technology. Archived from the original on 2016-03-03. Retrieved 2008-04-12.