ISO/IEC 9579-1:1993

I N TE R NAT I O NA L ISO/IEC
S TA N DAR D 9579-7
First edition
1993-1 2-15
Information technology - Open Systems
Interconnection - Remote Database
Access -
Part 1:
Generic Model, Service and Protocol
Technologies de l'information - Interconnexion de systèmes ouverts
(OSI) -Accès aux bases de données à distance -
Pattie I: Modéle, service et protocole
Reference number
ISO/IEC 9579-1:1993(E)

---------------------- Page: 1 ----------------------
ISO/IEC 9579-1: 1993 (E)
Contents
...
Foreword .
Introduction . xiv
xlll O
Section 1: Introduction 1
Scope . 1
1.1
1.2 Normative references . 3
Definitions . 4
1.3
1.3.1 Basic Reference Model . 4
1.3.2 Reference Model - Naming and Addressing . 4
1.3.3 Service conventions . 4
1.3.4 Application Layer Structure . 5
1.3.5 Connection Oriented Presentation Service Definition . 5
1.3.6 Service Definition for the Association Control Service Element . 5
1.3.7 Specification of Abstract Syntax Notation One (ASN.1) .
1.3.8 Commitment, Concurrency, and Recovery . 6
1.3.9 Distributed Transaction Processing . 6
1.3.10 Reference Model of Data Management . 6
1.3.11 Remote Database Access . 6
1.3.11.1 database language . 6
1.3.11.2 database language command . 6
1.3.1 1.3 database language statement . 6
(D ISO/IEC1993
Ail rights reserved . Unless otherwise specified. no part of this publication may be
reproduced or utilized in any form or by any means. electronic or mechanical. including
photocopying and microfilm. without permission in writing from the publisher .
ISO/IEC Copyright Office Case postale 56 CH-1211 Genève 20 Switzerland
Printed in Switzerland
11

---------------------- Page: 2 ----------------------
ISO/IEC 9579-1: 1993 (E)
@ISO/IEC
1.3.11.4 database server . 6
1.3.11.5 data resource . 7
1.3.11.6 RDA client . 7
1.3.11.7 RDA Control service . 7
1.3.11.8 RDA dialogue . 7
1.3.11.9 RDA dialogue-state model . 7
1.3.11.10 RDA Generic Standard . 7
1.3.11.11 RDA operation . 7
1.3.11.12 RDA protocol machine . 7
1.3.11.13 RDA server . 7
e
1.3.11.14 RDA Service . 7
1.3.11.15 RDA Specialization Standard, RDA Specialization . 7
1.3.11.16 RDA transaction . 7
1.4 Abbreviations . 8
1.5 Conventions . 9
1.5.1 Service conventions . 9
1.5.2 Service parameter description . 9
Section 2: Model 11
............................ ... 12
2.1 Concepts . . .
2.1.1 Overview of the components . 12
2.1.2 Database server concepts . 12
2.1.2.1 Organization of data . 12
a
2.1.2.2 RDA transactions . 13
2.1.2.3 RDA operations . 13
2.1.2.4 Database language commands . 14
2.1.3 Communication concepts . 14
2.1.3.1 RDA dialogues . 14
2.1.3.2 Failure and recovery . 15
2.1.4 RDA application-contexts . 16
2.1.5 RDA Specialization Standards . 16
Section 3: Service
17
3.1 Services . 18
3.1.1 RDA Dialogue Management services . 19
...
111

---------------------- Page: 3 ----------------------
ISO/IEC 9579-1: 1993 (E)
@ISO/IEC
3.1.1.1 RDA Dialogue Initialization functional unit . 19
3.1.1.1.1 R-Initialbe service . 20
3.1.1.2 RDA Dialogue Termination functional unit . 23
3.1.1.2.1 R-Terminate service . 23
3.1.2 RDA Transaction Management services . 25
3.1.2.1 RDA Transaction Management functional unit . 25
3.1.2.1.1 R-BeginTransaction service . 25
3.1.2.1.2 R-Commit service . 26
3.1.2.1.3 R-Rollback service . 28
.........................................
3.1.3 RDA Control services 29
0
3.1.3.1 Cancel functional unit . 29
3.1.3.1.1 R-Cancel service . 29
3.1.3.2 Status functional unit . 31
3.1.3.2.1 R-Status service . 32
3.1.4 Resource Handling services . 34
3.1.4.1 Resource Handling functional unit . 35
3.1.4.1.1 R-Open service . 35
3.1.4.1.2 R-Close service . 38
3.1.5 Database Language services . 40
3.1.5.1 Immediate Execution DBL functional unit . 41
3.1.5.1.1 R-ExecuteDBL service . 41
3.1.5.2 Stored Execution DBL functional unit . 43
3.1.5.2.1 R-DefineDBL service . 44
e
3.1.5.2.2 R-InvokeDBL service . 46
3.1.5.2.3 R-DropDBL service . 49
................................................
3.2 Sequencing rules 51
3.2.1 RDA client sequencing rules . 51
3.2.2 RDA server sequencing rules . 54
Section 4: Protocol 57
.............................................
4.1 Server execution rules 58
4.1.1 RDA dialogue-state model . 58
4.1.1.1 RDA operation entity . 59
4.1.1.2 RDA dialogue entity . 60
iv

---------------------- Page: 4 ----------------------
@ISO/IEC
ISO/IEC 9679-1: 199s (E)
4.1.1.3 Opened data resource entity .
61
4.1.1.4 Defined DBL entity .
61
4.1.2
General server execution rules . 62
4.1.2.1 Generation of the RDA operation entity .
62
4.1.2.2 Implementor defined errors .
63
4.1.2.3 Beginning of an RDA operation . 63
4.1.2.4 Cancellation of an RDA operation .
63
4.1.2.5 Execution of an RDA operation .
63
4.1.2.6 End of an RDA operation . 64
4.1.2.7 Response to an RDA operation . 64
4.1.2.8 Failure of the RDA dialogue .
65
4.1.3 RDA Dialogue Management services . 65
4.1.3.1 RDA Dialogue Initialization functional unit . 65
4.1.3.1.1 R-Initialize service .
65
4.1.3.2 RDA Dialogue Termination functional unit . 66
4.1.3.2.1 R-Terminate service . 66
4 RDA Transaction Management services . 66
4.1.4.1 RDA Transaction Management functional unit . 66
4.1.4.1.1 R-BeginTransaction service . 66
4.1.4.1.2 R-Commit service . 67
4.1.4.1.3 R-Rollback service . 67
4.1.5 RDA Control services . 68
4.1.5.1 Cancel functional unit . 68
4.1.5.1.1 R-Cancel service . 68
4.1.5.2 Status functional unit . 69
4.1.5.2.1 R-Status service . 69
4.1.6 Resource Handling services . 71
4.1.6.1 Resource Handling functional unit . 71
4.1.6.1.1 R-Open service .
71
4.1.6.1.2 R-Close service . 72
4.1.7 Database Language services . 73
4.1.7.1 Immediate Execution DBL functional unit . 73
4.1.7.1.1 R-ExecuteDBL service . 73
4.1.7.2 Stored Execution DBL functional unit . 74
V

---------------------- Page: 5 ----------------------
ISO/IEC 9579-1: 1993 (E) @ISO/IEC
4.1.7.2.1 R-DefineDBL service . 74
4.1.7.2.2 R-InvokeDBL service . 75
4.1.7.2.3 R-DropDBL service .
76
4.2 RDA protocol machine . 77
4.2.1 Functional units . 77
Correspondence between RDA service primitives and RDA APDUs .
4.2.2 78
.............................................
4.2.3 Concatenation 78
...............................................
4.2.4 State tables 79
.........................................
4.2.4.1 Conventions 79
4.2.4.2 Actions to be taken by the RDAPM . 80
.............................................
4.2.4.3 States 81
.......................................
4.2.4.4 Incoming events 82
4.2.4.5 Outgoing actions .
84
..........................................
4.2.4.6 Predicates 85
4.2.4.7 RDAPM state tables . 86
4.2.4.7.1 RDA client state tables . 86
4.2.4.7.2 RDA server state tables . 90
4.2.4.7.3 Values of diagnosticInformation for invalidsequence error . 94
..........................................
4.2.5 Protocol procedures 94
4.2.5.1 Initialization of an RDA dialogue . 94
4.2.5.2 Termination of an RDA dialogue . 94
4.2.5.3 Initiation of an RDA transaction . 95
4.2.5.4 Termination of an RDA transaction . 95
4.3 Application-protocol-data-units . 96
..................................................
4.4 Conformance 112
4.4.1 Static conformance . 112
4.4.2 Dynamic conformance . 112
Sect ion 5: Applicat ion-context s
113
5.1 RDA Basic application-context . 114
5.1.1 Application-context name . 114
5.1.2 Purpose and scope . 114
5.1.2.1 General description . 114
5.1.2.2 RDA dialogue failure . 114
vi

---------------------- Page: 6 ----------------------
@ISO/IEC ISO/IEC 9579-1: 1993
(E)
5.1.3 SetofASEs . 114
5.1.4
SACFrules . 114
5.1.4.1 Association establishment and release . 115
5.1.4.1.1 A-ASSOCIATE .
115
5.1.4.1.2 A-RELEASE . 115
5.1.4.1.3 A-ABORT . 115
5.1.4.1.4 A-P-ABORT . 115
5.1.4.2 RDA dialogue initialization and termination . 115
5.1.4.2.1 R-Initialize . 115
5.1.4.2.2 R-Terminate .
116
5.1.4.3 Mapping rules . 116
5.1.4.3.1 ACSE APDUs . 116
5.1.4.3.2 RDA APDUs .
116
5.1.5 State transition diagrams . 116
5.1.6 Use of optional features . 119
5.1.6.1 A-ASSOCIATE . 119
5.1.6.2 A-RELEASE .
119
5.1.6.3 A-ABORT . 119
5.1.6.4 A-P-ABORT . ). . 119
5.1.7 Conformance . 119
5.1.7.1 Static conformance . 119
5.1.7.2 Dynamic conformance . 120
5.2 RDA TP application-context . 121
5.2.1 Application-context name . 121
5.2.2 Purpose and scope . 121
5.2.3 Set of ASES . 121
121
5.2.4 SACF rules .
5.2.4.1 Sequencing rules . 122
5.2.4.1.1 RDA with TP Dialogue functional unit . 122
5.2.4.1.2 RDA with TP Polarized Control functional unit . 123
123
5.2.4.1.3 RDA with TP Shared Control functional unit .
123
5.2.4.1.4 RDA with TP Handshake functional unit .
5.2.4.1.5 RDA with TP Commit and Chained Transactions functional units . 123
5.2.4.1.6 RDA with TP Commit and Unchained Transactions functional units . 124
vii

---------------------- Page: 7 ----------------------
@ISO/IEC
ISO/IEC 9579-1: 1993 (E)
5.2.4.1.7 R-Initialize . 124
5.2.4.2 Mapping rules . 124
5.2.4.2.1 TPAPDUs . 124
5.2.4.2.2 RDAAPDUs . 124
5.2.4.3 Concatenation rules . 124
5.2.4.4 Transaction states . 125
5.2.4.4.1 RDA with TP Dialogue functional unit . 125
5.2.4.4.2 RDA with TP Polarized Control functional unit . 125
5.2.4.4.3 RDA with TP Shared Control functional unit . 125
5.2.4.4.4 RDA with TP Handshake functional unit . 125
125
5.2.4.4.5 RDA with TP Commit and Chained Transactions functional units .
126
5.2.4.4.6 RDA with TP Commit and Unchained Transactions functional units .
5.2.5 State transition diagrams . 126
5.2.6 Use of optional features . 131
5.2.6.1 A-ASSOCIATE . 131
5.2.7 Conformance . 131
5.2.7.1 Static conformance . 131
5.2.7.2 Dynamic conformance . 131
Section 6: Specializations 133
6.1 RDA Specialization Standards . 134
6.1.1 General . 134
6.1.2 Model . 134
6.1.3 Service . 134
6.1.4 Protocol . 135
6.1.4.1 Server execution rules . 135
6.1.4.2 State tables . 135
6.1.4.3 Structure of RDA Specialization APDUs . 135
6.1.4.4 Conformance . 135
6.1.5 Application-contexts . 136
137
Annex A: Relationship to the Application Layer structure
A.1 Introduction . 137
137
A.2 RDA as an application-service-element .
A.3 RDA application-contexts . 137
viii

---------------------- Page: 8 ----------------------
@ISO/IEC ISO/IEC 9579-1: 1993 (E)
A.4 RDA service-provider . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 137
Index 141
ix

---------------------- Page: 9 ----------------------
@ISO/IEC
1 RDA component relationships . 12
............................................
2 Overview of RDA states 15
O
3 Structure of RDA service primitives . 19
4 Relationship of RDAPM to RDA model . 79
5 State transition diagram for RDA Basic application-context . RDA client . 117
6 State transition diagram for RDA Basic application-context . RDA server .
118
7 State transition diagram for RDA TP application-context . RDA client (Chained Transactions) . 127
8 State transition diagram for RDA TP application-context . RDA server (Chained Transactions) . 128
9 State transition diagram for RDA TP application-context . RDA client (Unchained Transactions) . . 129
10 State transition diagram for RDA TP application-context . RDA server (Unchained Transactions) . . 130
The RDA Service viewed in the RDA Basic application-context .
A.l 138
A.2 The RDA Service viewed in the RDA TP application-context . 139
0
I X

---------------------- Page: 10 ----------------------
@ISO/IEC
ISOIIEC 9579-1: 1993 (E)
Tables
1 RDA functional units and associated RDA services . 18
R-Initialize service primitives and their parameters . 20
R-Terminate service primitives and their parameters . 23
4 R-BeginTransaction service primitives and their parameters . 25
5
R-Commit service primitives and their parameters . 27
6 R-Rollback service primitives and their parameters . 28
7 R-Cancel service primitives and their parameters . 29
8 R-Status service primitives and their parameters . 32
9
R-Open service primitives and their parameters . 35
10 R-Close service primitives and their parameters . 38
11 R-ExecuteDBL service primitives and their parameters . 41
R-DefineDBL service primitives and their parameters . 44
I 12
13 R-InvokeDBL service primitives and their parameters . 46
14 R-DropDBL service primitives and their parameters . 49
~ e 15 State table for RDA client service primitives . 53
i
16 State table for RDA server service primitives . 55
17 RDA functional units and associated RDA APDUs . 77
18 States . 81
19
Incoming events: RDA Dialogue Management and RDA Transaction Management services . 82
20 Incoming events: RDA Control. Resource Handling. and Database Language services . 83
21 Outgoing actions: RDA Dialogue Management and RDA Transaction Management services . 84
22 Outgoing actions: RDA Control. Resource Handling. and Database Language services . 85
23
Predicates . 85
24
RDA client state table: RDA Dialogue Management services . 86
25 RDA client state table: RDA Transaction Management services . 87
26 RDA client state table: RDA Control and Resource Handling services . 88
xi

---------------------- Page: 11 ----------------------
ISO/IEC 9579-1: 1993 (E)
@ISO/IEC
27 RDA client state table: Database Language services . 89
28 RDA server state table: RDA Dialogue Management services . 90
29 RDA server state table: RDA Transaction Management services . 91
30 RDA server state table: RDA Control and Resource Handling services
.................. 92
31 RDA server state table: Database Language services . 93
32 diagnosticInformation for invalidsequence error . 94
xii

---------------------- Page: 12 ----------------------
@ISO/IEC ISO/IEC 9579-1: 1993 (E)
Foreword
IS0 (the International Organization for Standardization) and IEC (the Interna-
tional Electrotechnical Commission) form the specialized system for worldwide
standardization. National bodies that are members of IS0 or IEC participate in
the development of International Standards through technical committees estab-
lished by the respective organization to deal with particular fields of technical
activity. IS0 and IEC technical committees collaborate in fields of mutual inter-
est. Other international organizations, governmental and non-governmental, in
liaison with IS0 and IEC, also take part in the work.
In the field of information technology, IS0 and IEC have established a joint
technical committee, ISO/IEC JTC 1. Draft International Standards adopted by
the joint technical committee are circulated to national bodies for voting. hbli-
cation as an International Standard requires approval by at least 75 % of the na-
tional bodies casting a vote.
International Standard ISOAEC 9579- 1 was prepared by Joint Technical Com-
mittee ISOAEC JTC 1, Information technology, Subcommittee SC 21, Open
systems interconnection, data management and open distributed processing.
ISO/IEC 9579 consists of the following parts, under the general title Information
technology - Open Systems Interconnection - Remote Database Access:
- Part I: Generic Model, Service and Protocol
- Part 2: SQL specialization
Annex A of this part of ISO/IEC 9579 is for information only.

---------------------- Page: 13 ----------------------
@ISO/IEC
ISO/IEC 9579-1: 1993 (E)
. Introduction
The Remote Database Access (RDA) standard is one of a set of International Standards produced to facilitate the
interworking of computer systems. It is positioned in the Application Layer of the Reference Model of Open Systems
Interconnection (OSI) and is related to other OS1 standards, as defined in IS0 7498.
The goal of Remote Database Access is to allow, with a minimum of technical agreement outside the interconnection
standards, the interconnection of applications and database systems:
0 from different manufacturers;
0 under different managements;
0 of different levels of complexity;
0 exploiting different technologies.
An application may itself be a database system and therefore RDA can be used to support multi-database system
interworking.
ISO/IEC 9579 defines a service provided to application programs which represents a boundary between the local
processing of an application and that part concerned with communications. There is a mapping between the RDA
Service elements defined in ISO/IEC 9579 and the services provided by lower layers of the Reference Model of Open
Systems Interconnection. This RDA Service, and the lower layer services, may be used to carry database language
statements and data between a client application and a database server to enable an application to read and update
data in a remote database.
This part of ISO/IEC 9579 is to be used together with an RDA Specialization Standard (specified in some other part of
ISO/IEC 9579) to define an RDA application providing interworking with a database management system supporting
a specific database language.
xiv

---------------------- Page: 14 ----------------------
INTERNATIONAL STANDARD OISO/IEC ISO/IEC 9579-1: 1993 (E)
Information technology - Open Systems Interconnection -
Remote Database Access -
Part 1:
Generic Model, Service and Protocol
Section 1: Introduction
1.1 Scope
ISO/IEC 9579 specifies the OS1 Remote Database Access (RDA) Service in terms of
a) the behaviour, as perceived from the OS1 environment, of an application-process, called a database server, that
provides database storage facilities and database processing services (that is, provides a database management
system) to other application-processes; and
b) the behaviour, as perceived from the OS1 environment, of an application-process, called an RDA client, that
accesses remote database facilities.
e
This part of ISO/IEC 9579, called the “RDA Generic Standard”, specifies the general capabilities of an RDA Service.
These generic capabilities are intended to be used for interaction with many different database management systems.
Other parts of ISO/IEC 9579, called “RDA Specialization Standards”, pertain to particular database languages, and
augment the RDA Generic Standard by specifying how the generic capabilities of RDA are specialized for each of
those database languages.
Thus a complete RDA Service is specified, for a given database language, by the combination of two parts of
ISO/IEC 9579, one (this part) for the generic capabilities of RDA and a second (another part) for that particu-
lar database language.
The resulting specification is an OS1 Application Layer standard.

---------------------- Page: 15 ----------------------
@ISO/IEC
ISO/IEC 9579-1: 1993 (E)
This part of ISO/IEC 9579 describes the generic capabilities of
a) the model of Remote Database Access (section 2, Model);
b) the RDA Service that supports interaction between the RDA client and the database server - specifically, its
communicating part, called the RDA server (section 3, Service);
c) the RDA Protocol by which the RDA client and the database server - specifically, the RDA server - communicate
with each other (section 4, Protocol); and
d) the application-contexts of which the RDA Service is a part, including additional rules and the mapping onto
underlying services (section 5, Application-contexts).
This part of ISO/IEC 9579 also specifies the rules for defining a specialized RDA Service and constructing an RDA
Specialization Standard for it (section 6, Specializations).
ISO/IEC 9579 does not specify individual implementations or products, nor does it constrain the implementation of
entities and interfaces within a computer system.
2

---------------------- Page: 16 ----------------------
@ISO/IEC ISO/IEC 9579-1: 1993 (E)
1.2 Normative references
The following standards contain provisions which, through reference in this text, constitute provisions of this part of
ISO/IEC 9579.
At the time of publication, the editions indicated were valid. All standards are subject to revision, and parties to
agreements based on this part of ISO/IEC 9579 are encouraged to investigate the possibility of applying the most recent
editions of the standards listed below. Members of IEC and IS0 maintain registers of currently valid International
Standards.
IS0 7498: 1984, Information processing systems - Open Systems Interconnection - Basic Reference Model.
IS0 7498-3: 1989, Information processing systems - Open Systems Interconnection - Basic Reference Model - Part
3: Naming and Addressing.
IS0 8327: 1987, Information processing systems - Open Systems Interconnection - Basic connection oriented session
protocol specification.
IS0 8327: 1987/Add. 2: -I, Information processing systems - Open Systems Interconnection - Basic connection
oriented session protocol specification - Addendum 2: Unlimited user data.
IS0 JTR 8509: 1987, Information processing systems - Open Systems Interconnection - Service conventions.
IS0 8649: 1988, Information processing systems - Open Systems Interconnection - Service definition for the Associa-
tion Control Service Element.
IS0 8650: 1988, Information processing systems - Open Systems Interconnection - Protocol specification for the
Association Control Se rvice Element.
IS0 8822: 1988, Information processing systems - Open Systems Interconnection - Connection oriented presentation
service definition.
IS0 8823: 1988, Information processing systems - Open Systems Interconnection - Connection oriented presentation
protocol specification.
IS0 8823: 1988/Amd. 2: -I, Information processing systems - Open Systems Interconnection - Connection oriented
presentation protocol specification - Amendment 2: Unlimited user data.
ISO/IEC 8824: 1990, Information technology - Open Systems Interconnection - Specification of Abstract Syntax
Notation One (ASN.1).
IS0 JIEC 9545: 1989, Information technology - Open Systems Interconnection - Application Layer structure.
ISO/IEC 9804: 1990, Information technology - Open Systems Interconnection - Service definition for the Commitment,
Concurrency and Recovery service element.
ISO/IEC 10026-1: 1992, Information technology - Open Systems Int
...