Codes & Standards - Purchase
CAN/CSA-ISO/IEC 9579-2-95 (R2000)
Information Technology - Open Systems Interconnection - Remote Database Access - Part 2: SQL Specialization (Adopted ISO/IEC 9579-2:1993)
SKU: 2410246
Published by CSA Group
Publication Year 1995
Reaffirmed in 2000
59 pages
Withdrawn
Product Details
Scope
This part of ISO/IEC 9579 specifies the functionality of a database server within a distributed open systems environment and specifies the communication service and protocol for accessing its capabilities. The communications capabilities are positioned in the Application Layer of the Reference Model of Open Sy stems Interconnection (OSI).
This part of ISO/IEC 9579 complements ISO/IEC 9579-1 (RDA Generic) in order that the two parts together:
(a) define the capabilities of an RDA SQL database server supporting dialogues with clients.
(b) define a model of dialogues between the RDA SQL database server and remote users.
(c) define a model of a dialogue between an RDA client and an RDA server.
(d) define an abstract service for the RDA SQL ASE, which models the communications facilities supporting interaction between the RDA client and RDA server.
(e) define the RDA SQL ASE protocol to support the RDA SQL Service.
(f) define the characteristics of application-contexts which include the RDA SQL ASE.
(g) define application-contexts that support remote database access using SQL:
(1) RDA Basic application-context
(2) RDA TP application-context
This part of ISO/IEC 9579 does not specify individual implementations or products, nor does it constrain the implementation of entities and interfaces within a computer system.
This part of ISO/IEC 9579 does not define a programmatic interface. The RDA server includes a database capability as defined in ISO/IEC 9075 (Database Language SQL).
NOTES
1 The RDA client may contain an SQL application program but there is no requirement that the RDA client shall be an application program written to the ISO/IEC 9075 (Database Lang uage SQL) application program interface.
2 ISO/IEC 9075:1989, the former International Standard for Database Language SQL, has been replaced by ISO/IEC 9075:1992. Both the current and former standards contain conformance rules, and the RDA SQL Specialization allows an RDA client to specify the desired level of conformance which it expects the RDA Server to support. Throughout this part of ISO/IEC 9579, SQL refers to the language statements permitted by the appropriate standard at the requested level of conformance.
This part of ISO/IEC 9579 specifies the functionality of a database server within a distributed open systems environment and specifies the communication service and protocol for accessing its capabilities. The communications capabilities are positioned in the Application Layer of the Reference Model of Open Sy stems Interconnection (OSI).
This part of ISO/IEC 9579 complements ISO/IEC 9579-1 (RDA Generic) in order that the two parts together:
(a) define the capabilities of an RDA SQL database server supporting dialogues with clients.
(b) define a model of dialogues between the RDA SQL database server and remote users.
(c) define a model of a dialogue between an RDA client and an RDA server.
(d) define an abstract service for the RDA SQL ASE, which models the communications facilities supporting interaction between the RDA client and RDA server.
(e) define the RDA SQL ASE protocol to support the RDA SQL Service.
(f) define the characteristics of application-contexts which include the RDA SQL ASE.
(g) define application-contexts that support remote database access using SQL:
(1) RDA Basic application-context
(2) RDA TP application-context
This part of ISO/IEC 9579 does not specify individual implementations or products, nor does it constrain the implementation of entities and interfaces within a computer system.
This part of ISO/IEC 9579 does not define a programmatic interface. The RDA server includes a database capability as defined in ISO/IEC 9075 (Database Language SQL).
NOTES
1 The RDA client may contain an SQL application program but there is no requirement that the RDA client shall be an application program written to the ISO/IEC 9075 (Database Lang uage SQL) application program interface.
2 ISO/IEC 9075:1989, the former International Standard for Database Language SQL, has been replaced by ISO/IEC 9075:1992. Both the current and former standards contain conformance rules, and the RDA SQL Specialization allows an RDA client to specify the desired level of conformance which it expects the RDA Server to support. Throughout this part of ISO/IEC 9579, SQL refers to the language statements permitted by the appropriate standard at the requested level of conformance.