Distributed Relational Database Architecture (DRDA) is a database interoperability standard from

The Open Group The Open Group is a global consortium that seeks to "enable the achievement of business objectives" by developing "open, vendor-neutral technology standards and certifications." It has over 840 member organizations and provides a number of servi ...

. DRDA describes the architecture for

distributed Distribution may refer to: Mathematics *Distribution (mathematics), generalized functions used to formulate solutions of partial differential equations *Probability distribution, the probability of a particular value or value range of a varia ...

relational databases. It defines the rules for accessing the distributed data, but it does not provide the actual

application programming interface An application programming interface (API) is a way for two or more computer programs to communicate with each other. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how t ...

s (APIs) to perform the

access Access may refer to: Companies and organizations * ACCESS (Australia), an Australian youth network * Access (credit card), a former credit card in the United Kingdom * Access Co., a Japanese software company * Access Healthcare, an Indian BPO se ...

. It was first used in DB2 2.3. DRDA was designed by a work group within IBM in the period 1988 to 1994. The messages, protocols, and structural components of DRDA are defined by the

Distributed Data Management Architecture Distributed Data Management Architecture (DDM) is IBM's open, published software architecture for creating, managing and accessing data on a remote computer. DDM was initially designed to support record-oriented files; it was extended to support ...

Components

* Application Requester (AR). The AR accepts SQL requests from an application and sends them to the appropriate application servers for processing. Using this function, application programs can access remote data. * Application Server (AS). The AS receives requests from application requesters and processes them. The AS acts upon the portions that can be processed and forwards the remainder to database servers for subsequent processing. The AR and the AS communicate through a

protocol Protocol may refer to: Sociology and politics * Protocol (politics), a formal agreement between nation states * Protocol (diplomacy), the etiquette of diplomacy and affairs of state * Etiquette, a code of personal behavior Science and technology ...

called the ''Application Support Protocol'' which handles data representation conversion. * Database Server (DS). The DS receives requests from AS or other DS servers. The DS supports distributed requests and will forward parts of the request to collaborating DS in order to fulfill the request. The AS and the DS among themselves communicate through a

called the ''Database Support Protocol''.

Databases supporting DRDA

* Apache Derby (Java RDBMS) *

IBM Db2 Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON a ...

Informix Dynamic Server IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix products were originally developed by Informix Corporation, whose ...

v11.10 * Oracle Database Gateway for DRDA - enables Oracle database to act as a DRDA client, accessing remote non-Oracle databases (primarily DB2) * Oracle Database Provider for DRDA - enables Oracle database to act as a DRDA server, providing Oracle database access to remote clients (e.g. IBM i systems using DB2/400 DRDA client library)

External links

The OpenGroup - DRDA Protocol description
Open Group standards SQL data access Application layer protocols Database access protocols {{database-stub