Distributed Relational Database Architecture (DRDA) is a database interoperability standard from The Open Group. The Open Group is an industry Consortium to set vendor- and technology-neutral open standards for Computing infrastructure
DRDA describes the architecture for distributed data. Distributed computing deals with Hardware and Software Systems containing more than one processing element or Storage element concurrent It defines the rules for accessing the distributed data, but it does not provide the actual application programming interfaces (APIs) to perform the access. Data access typically refers to software and activities related to storing retrieving or acting on Data housed in a Database or other repository
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 called the Application Support Protocol which handles data representation conversion. In computing, a protocol is a convention or standard that controls or enables the connection Communication, and Data transfer between two computing Data conversion is the conversion of one form of computer data to another--the changing of Bits from being in one format to a different one usually for the purpose
- 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 protocol called the Database Support Protocol. In computing, a protocol is a convention or standard that controls or enables the connection Communication, and Data transfer between two computing
Databases supporting DRDA
- Apache Derby (a.k.a. Java DB and Cloudscape)
- DB2
- Informix Dynamic Server v11. DB2 is one of IBM 's families of Relational database management system (RDBMS (or as IBM now calls it data server software products within IBM's broader Information Informix Dynamic Server also known as IDS is an extensible Relational Database Management System originally developed by Informix Software Inc 10
- Oracle Transparent Gateway for IBM DRDA
External links
- The OpenGroup
- Article on DRDA by Craig Mullins
- IBM Redbook: SG24-4249, Chapter 5. DRDA and two-phase commitment control