ISO/IEC 10728:1993

INTERNATIONAL
lSO/IEC
STANDARD
First edition
1993-04-15
Information technology - Information
Resource Dictionary System (IRDS)
Services Interface
Technologies de I’informa tion - Interface de Services du gestionnaire de
ressources du Systeme d’informations (IRDS)
Reference number
ISO/IEC 10728: 1993 (E)
Table of Contents
vi
Forew ord
Vii
Introduction
1 scope
Normative references
3 Definitions and abbreviations
3.1 Terms defined or referenced in the IRDS Framework (ISO/IEC 10027)
and used in this International Standard
3.2 Terms defined in this International Standard
3.3 Data Item Name abbreviations
4 Conventions
4.1 Specification of concepts and facilities
4.2 Specification of data structures
4.3 Specification of constraints - overview
4.4 Specification of Service data structures
4.5 Specification of Services
4.6 Data Structure Diagmm
4.7 Specification of constraints - detail
4.7.1 Types of constraint
4.7.2 Overview of referential constraints
4.7.3 Optional one-to-many referential constraint
4.7.4 Required uni-directional one-to-many referential constraint
Required uni-directional one-to-one referential constraint
4.7.5
Self-referencing tables
4.7.6
Required bi-directional referential constraint
4.7.7
Mutually-exclusive referential constraints
4.7.8
4.7.9 Subtables
4.7.10 Principles for expressing constraints
4.8 Working Set Diagrams
5 IRDS concepts and facilities
5.1 IRDS Environment concepts
5.2 Categories of table
5.3 Overview of IRD Definition tables
0 ISQ/IEC 1993
All rights reserved. No part of this publication may be reproduced or utilized in any form or by
any means, electronie or mechanical, including photocopying and microfilm, without Permission
.- -
in writing from the publisher.
ISOAEC Copyright Office l Case Postale 56 l CH-1 211 Genbve 20 l Switzerland
Printed in Switzerland
ISO/IEC 10728: 1993 (E)
0 ISO/IEC
5.4 Overview of IRD tables
Overview
5.4.1
Intemal and common tables
5.4.2
IRD-specific tables
5.4.3
5.5 Data and the objects to which the datarefers
Definition objects comprising data modehing facility
5.5.1
Definition objects dependent on an IRD Schema Group
5.5.2
Content of IRD tables
5.5.3
Accessibility of tables to users
5.5.4
5.6 Version Control concepts
Objects and Versions of Objects
5.6.1
Working Sets
5.6.2
Working sets and users
5.6.3
Basing one working set on another
5.6.4
Materialization of a working set
5.6.5
5.6.6 References from one working set to another
References to multiple Versions of an Object
5.6.7
5.6.8 Context
5.6.9 IRD content status
5.6.10 References in the IRD
5.6.11 Granularity of Version Control
5.6.12 Access control
5.7 Naming facilities
5.7.1 Names
5.7.2 IRDS names
Variation name
5.7.3
5.7.4 Working set name and working set version name
5.8 Definable limits and installation defaults
Implementation-defined limits
5.8.1
5.8.2 Installation defaults
5.9 Creating and dropping IRDs
5.10 IRD Schema modification
5.11 Other added value functionality
Audit attributes
5.11.1
IRDS content modules 25
5.11.2
5.11.3 System-maintained values
6 Abstract data structures
6.1 IRD Definition Level
6.1.1 IRD Definition Level data structure
6.1.2 IRD Definition Level Schema
6.1.2.1 Schema IRD Definition
6.1.3 IRD Definition Level Domains
6.1.3.1 Domain SQL Name
6.1.3.2 Domain IRDS Key
6.1.3.3 Domain Char Data
6.1.3.4 Domain Cardinal
6.1.3.5 Domain Boolean
6.1.4 IRD Definition Level Tables
6.1.4.1 Table IRD Object
6.1.4.2 Table IRD Working Set
6.1.4.3 Table IRD Object Version
6.1.4.4 Table IRD Reference Path
6.1.4.5 Table IRDS User
6.1.4.6 Table Implementation Limits
6.1.4.7 Table IRDS Dictionary
6.1.4.8 Table IRD Schema Group
6.1.4.9 Table IRD Schema
6.1.4.10 Table IRD SchemaReference
6.1.4.11 Table IRD Data Type Descriptor
6.1.4.12 Table IRD Domain
. . .
lll
0 ISO/lEc
ISO/IEC 10728: 1993 (E)
6.1.4.13 Table IRD Table
6.1.4.14 Table IRD View
6.1.4.15 Table IRD Column
6.1.4.16 Table IRD View Table Usage
6.1.4.17 Table IRD View Column Usage
6.1.4.18 Table IRD Table Constraint
6.1.4.19 Table IRD Key Column Usage
6.1.4.20 Table IRD Referential Constraint
6.1.4.21 Table IRD Check Constraint
6.1.4.22 Table IRD Check Table Usage
6.1.4.23 Table IRD Check Column Usage
6.1.4.24 Table IRD Assertion
6.1.4.25 Table IRD Module
6.1.4.26 Table IRD Content Status
6.1.4.27 Table Installation Default
6.1.4.28 Table IRD Working Set Privilege
6.1.5 IRD Definition Level Views
6.1.5.1 View All SQL Names
6.1.5.2 View IRD Object Version
6.1.5.3 View IRD Working Set
6.1.5.4 View IRD Reference Path
IRD Definition Level Change Control
6.1.6
6.1.7 IRD Definition Level Initial Contents
6.2 IRD Level
RD Level data structure
6.2.1
IRD Level Initial Contents
6.2.2
6.3 IRD General Rules
Use of primary key
6.3.1
6.3.2 References and content Status
Resolution of references
6.3.3
Resolution of references within a version path
6.3.4
References depending on a reference path
6.3.5
Reference paths and Version paths
6.3.6
Services concepts and facilities
7.1 Levels and parallelism
7.2 Access to IRDS data via Database Services Processor
7.2.1 Prevention of cinxmvention of IRDS security and integrity
7.2.2 Access to IRDS Data using a Standard Database Language
7.3 Connecting an application to the IRDS Services Interface Processor
7.3.1 Sessions and transactions
IRDS users and Privileges
7.3.2
7.4 Object selection
7.5 Sets and cufsors
7.6 Diagnos tics
7.7 Version control
7.8 Operations on Abstract Data Structures
8 Service data structures
8.1 Basic data constants
8.1.1 Name Length Limits
8.1.2 Attribute Length Limits
8.1.3 Control ldentifier Length Limits
8.1.4 Data Types
8.1.5 IRD Content Status Classes
8.1.6 Close Type Parameter
8.2 Service data types
iv
0 ISO/IEC ISO/IEC 10728: 1993 (E)
8.2.1 Column data types
8.2.2 Object Names
8.2.3 Control Identifiers
8.2.4 Diagnostics Area
8.2.5 Service Return Code
8.2.6 Column List Parameters
9 Service Formats and Descriptions
9.1 Operational Services
Create IRD Definition Service 75
9.1.1
9.1.2 Drop IRD Definition Service 75
Open IRDS Service 76
9.1.3
9.1.4 Prepare Service 77
9.1.5 Commit Service 77
9.1.6 Rollback Service 78
Close IRDS Service 78
9.1.7
Get Diagnostics Service 78
9.1.8
9.2 Level independent services
9.2.1 Set Context Service
9.2.2 Add Object Service
Open Cursor Service 81
9.2.3
Retrieve Object Service 82
9.2.4
F
92 -3 Modify Object Service
Delete Object Service 84
9’2 . . 6
b
Declassify Object Service 8s
92 .7
9’2 e I +i Reclassify Object Service
9’2 q Glose Cursor Service
Create Working Set Service 87
9:2h
9.2.11 Drop Working Set Service
9.2.1.L odify Content Status Service
9.2.13 Create Reference Path Service
9.2.M Modify Weference Path Service
9.2.15 Dmp Reference Path Service
Definition4 Level specific services
Create IRD Service
Drop RD Service 92
Deactivate IRD Service
Reactiva D Service
Validate Schema Group Service 94
9.4 Sequence sf permitted Service invocation 95
9.4.1 Specification of valid sequences of IODS Service invocations 95
9.4.2 General rules 95
10 Conformance 97
Annexes
A - State classes and subclasses
A.1 State classes
A.2 State subclasses
A.3 State record
B - User-defined tables 103
ISO/IEC 10728: 1993 (E)
0 ISO/IEC
Foreword
ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission) form the
specialized System for worldwide standardization. National bodies that are members of ISO or IEC participate in the
development of International Standards through technical committees established by the respective organization to deal
with particular Gelds of technical activity. ISO and IEC technical committees collaborate in Gelds of mutual interest. Other
international organizations, govemmental and non-govemmental, in liaison with ISO and IEC, also take part in the work.
In the field of information technology, ISO and IEC have established a joint technical committee, ISO/IEC JTC 1. Draft
International Standards adopted by the joint technical committee arc circulated to national bodies for voting. Publication as
an International Standard requires approval by at least 75 % of the national bodies casting a vote.
International Standard ISO/IEC 10728 was prepared by Joint Technical Committee ISO/IEC JTC 1, Infomtion teclz-
nology, Sub-Committee SC 21, Infomtion retrieval, transfer- and mmuzgement for open Systems interconnection (OSI).
Annex A forms an integral part of this International Standard. Annex B is for information only.
vi
ISO/IEC 10728: 1993 (E)
0 ISO/IEC
Introduction
This International Standard is one of a series of International Standards on Information Resource Dictionary Systems.
ISO/IEC 10027 defines the context within which this International Standard is to be applied.
vii
0 ISO/IEC
ISO/IEC 10728: 1993 (E)
. . .
Vlll
INTERNATIONAL STANDARD 0 ISO/IEC
ISOiIEC 10728:1993 (E)
Information technology - Information Resource Dictionary
System (IRDS) Services Interface
1 Scope Normative references
The IRDS series of International Standards specifies a The following Standards containprovisions which, through
reference in this text, constitute provisions of this
Software tool that tan be used to describe and potentially
International Standard. At the time of publication, the
control an enterprise’s information resources. It defines the
editions indicated were valid. All standards are subject to
structure and part of the content of the data to be maintained
at the IRD Definition Level, and the structure of the data revision, and Parties to agreements based on this
International Standard are encouraged to investigate the
to be maintained at the IRD Level. It also defines the
Services to be provided for maintaining and retrieving data possibility of applying the most recent editions of the
Standards listed below. Members of IEC and ISO maintain
at both levels. Further details of the IRDS series of
Standards are to be found in ISO/IEC 10027. registers of currently valid International Standards.
This International Standard specifies a Services Interface ISO 3 166: 1988; Codes for the representation of names of
that gives any program full access to all IRDS services, countries
through whatever extemal cal1 interface is provided by the
language in which the program is written. The body of this ISO 7 185: 1990; Information Technology - Programming
International Standard defines the semantics of this
languages - Pascal.
interface, and also specifies the language bindings for ISO
Pascal (ISO 7185). Language bindings for other ISO
ISO/lEC 9075: 1992; Information Technology - Database
Standard programming languages are provided as separate
Languages - SQL.
Standards.
ISO/IEC 10027: 1990; Information Technology -
This International Standard makes no assumptions about
Information Resource Dictionary System (IRDS) -
an implementation environment, and assumes no specific
Framework.
nm-time or compile-time interfaces.
ISO/IEC 10032: 1993; Information Technology -
Reference Model of Data Management

0 ISO/IEC
ISO/IEC 10728: 1993 (E)
3.2.6 context: A working set established by default or by
Definitions and abbreviations
user request within which IRDS Services are performed.
NOTE - SQL tenns a= not defiied hexe. When used in this International
Standard, they have the meanings ascribed to them in ISO/IEC 9075. All
3.2.7 controlled: A content Status class that indicates data
IRDS tenns used in this International Standard are fully defined hexe or
that is stable and not subject to Change.
in ISO/IEC 10027.
3.2.8 definition Object: An Object recorded at the IRD
definition level that controls the data which may be present
3.1 Terms defined or referenced in the IRDS
at the IRD level.
Framework (ISO/IEC 10027) and used
in this International Standard
3.2.9 dictionary: An IRD Definition or IRD
The following terms are defined (or referenced) and used
3.2.10 environment table: A table that exists once in each
in the IRDS Framework. They are used in the Same way in
IRD Definition, controlling the Services provided on that
this International Standard.
IRD Definition and any associated IRDs.
3.1.1 client
3.2.11 implementation-defined: Behaviour not defined by
this International Standard, but which shall be precisely
3.1.2 Information Resource Dictionary (IRD)
defined by any conforming implementation
3.1.3 Information Resource Dictionary System (IRDS)
3.2.12 implementation-dependent: Behaviour not defined
by this International Standard, and which an
3.1.4 IRD definition
implementation is not required to define. Further, there is
no requirement that such behaviour be consistent ffom case
3.1.5 IRD definition level
to case.
3.1.6 IRD definition Schema
3.2.13 intemal table: A table that exists once in each IRD
Definition and each IRD, rows in which cannot be accessed
3.1.7 IRD level
by the Object-related services in clause 9.
3.1.8 IRD Schema
3.2.14 IRD-specific table: A table that exists only in the
IRD Definition or a specific IRD, as part of the
3.1.9 level pair
representation of the data structuring rules of a defined data
modehing facility.
3.1.10 real System
3.2.15 IRD content Status: A user-defined attribute of a
3.1.11 Service
working set. Every value of IRD content Status belongs to
one of the three predefined content Status classes. Esch
Object version takes its IRD content Status from the
3.2 Terms defined in this International
working set that contains it.
Standard
3.2.16 IRD content Status class: One of three predefined
Where each term listed in this clause is
...