Remote database access (RDA) is a protocol standard for

database In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...

access produced in 1993 by the International Organization for Standardization (

ISO The International Organization for Standardization (ISO ; ; ) is an independent, non-governmental, international standard development organization composed of representatives from the national standards organizations of member countries. Me ...

). Despite early efforts to develop proof of concept implementations of RDA for major commercial relational database management systems (RDBMSs) (including

Oracle An oracle is a person or thing considered to provide insight, wise counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. If done through occultic means, it is a form of divination. Descript ...

, Rdb, NonStop SQL and

Teradata Teradata Corporation is an American software company that provides cloud database and Analytics, analytics-related software, products, and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers a ...

), this standard has not found commercial support from database vendors. The standard has since been withdrawn, and replaced by ISO/IEC 9579:1999 - ''Information technology -- Remote Database Access for SQL'', which has also been withdrawn, and replaced by ISO/IEC 9579:2000 ''Information technology -- Remote database access for SQL with security enhancement''.ISO/IEC 9579:2000 Information technology -- Remote database access for SQL with security enhancement
/ref>

Purpose

The purpose of RDA is to describe 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 A database transaction symbolizes a unit of work, performed within a database management system (or similar system) against a database, that is treated in a coherent and reliable way independent of other transactions. A transaction generally rep ...

management, and * 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 The Internet protocol suite, commonly known as TCP/IP, is a framework for organizing the communication protocols used in the Internet and similar computer networks according to functional criteria. The foundational protocols in the suite are ...

connections, RFC 1066 is used for implementing RDA.

History

RDA was published in 1993 as a combined standard of

ANSI The American National Standards Institute (ANSI ) is a private nonprofit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States. The organiz ...

(International Organization for Standardization) and IEC (International Electrotechnical Commission). The standards definition comprises two parts: * ANSI/ISO/IEC 9579-1:1993 - Remote Database Access -- Part 1: Generic Model, Service and Protocol * ANSI/ISO/IEC 9579-2:1993

References

Sources

* Clients (computing) Servers (computing) Data access technologies OSI protocols Database access protocols {{network-software-stub