Remote database access (RDA) is a protocol standard for

database In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases spa ...

access produced in 1993 by the International Organization for Standardization (

ISO ISO is the most common abbreviation for the International Organization for Standardization. ISO or Iso may also refer to: Business and finance * Iso (supermarket), a chain of Danish supermarkets incorporated into the SuperBest chain in 2007 * Is ...

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

Oracle An oracle is a person or agency considered to provide wise and insightful counsel or prophetic predictions, most notably including precognition of the future, inspired by deities. As such, it is a form of divination. Description The wor ...

, Rdb,

NonStop SQL NonStop SQL is a commercial relational database management system that is designed for fault tolerance and scalability, currently offered by Hewlett Packard Enterprise. The latest version is SQL/MX 3.4. The product was originally developed by Tand ...

and

Teradata Teradata Corporation is an American software company that provides cloud database and analytics-related software, products, and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers at Caltech 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 Client(s) or The Client may refer to: * Client (business) * Client (computing), hardware or software that accesses a remote service on another computer * Customer or client, a recipient of goods or services in return for monetary or other valuabl ...

to a database

server Server may refer to: Computing *Server (computing), a computer program or a device that provides functionality for other programs or devices, called clients Role * Waiting staff, those who work at a restaurant or a bar attending customers and su ...

. 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 repr ...

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 set of communication protocols used in the Internet and similar computer networks according to functional criteria. The foundational protocols in the suit ...

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 non-profit organization that oversees the development of voluntary consensus standards for products, services, processes, systems, and personnel in the United States. The organ ...

(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