ISO/IEC 13249-1:2000
(Main)Information technology — Database languages — SQL multimedia and application packages — Part 1: Framework
Information technology — Database languages — SQL multimedia and application packages — Part 1: Framework
Technologies de l'information — Langages de bases de données — Multimédia SQL et paquetages d'application — Partie 1: Cadre général
General Information
Relations
Standards Content (Sample)
INTERNATIONAL ISO/IEC
STANDARD 13249-1
First edition
2000-09-01
Information technology — Database
languages — SQL multimedia and
application packages —
Part 1:
Framework
Technologies de l'information — Langages de bases de données —
Multimédia SQL et paquetages d'application —
Partie1: Cadre général
Reference number
ISO/IEC 13249-1:2000(E)
©
ISO/IEC 2000
---------------------- Page: 1 ----------------------
ISO/IEC 13249-1:2000(E)
PDF disclaimer
This PDF file may contain embedded typefaces. In accordance with Adobe's licensing policy, this file may be printed or viewed but shall not
be edited unless the typefaces which are embedded are licensed to and installed on the computer performing the editing. In downloading this
file, parties accept therein the responsibility of not infringing Adobe's licensing policy. The ISO Central Secretariat accepts no liability in this
area.
Adobe is a trademark of Adobe Systems Incorporated.
Details of the software products used to create this PDF file can be found in the General Info relative to the file; the PDF-creation parameters
were optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlikely event
that a problem relating to it is found, please inform the Central Secretariat at the address given below.
© ISO/IEC 2000
All 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 either ISO at the address below or ISO's member body
in the country of the requester.
ISO copyright office
Case postale 56 � CH-1211 Geneva 20
Tel. + 41 22 749 01 11
Fax + 41 22 749 09 47
E-mail copyright@iso.ch
Web www.iso.ch
Printed in Switzerland
ii © ISO/IEC 2000 – All rights reserved
---------------------- Page: 2 ----------------------
ISO/IEC 13249-1:2000(E)
Contents Page
Foreword.iv
Introduction.v
1 Scope .1
2 Normative references .1
3 Terms and definitions .1
3.1 Definitions taken from ISO/IEC 9075.1
3.2 Definitions provided in this part of ISO/IEC 13249.2
3.3 Definitions provided in other parts of ISO/IEC 13249 .3
4 Concepts.3
4.1 Concepts taken from ISO/IEC 9075.3
4.2 Requirements for generic kinds of data.4
4.3 Use of ISO/IEC 9075.4
4.4 Implementation of ISO/IEC 13249.5
4.5 Use of ISO/IEC 13249.5
5 Parts of ISO/IEC 13249 .6
5.1 Part 1: Framework (SQL/MM Framework) .6
5.2 Part 2: Full-Text (SQL/MM Full-Text).6
5.3 Part 3: Spatial (SQL/MM Spatial) .6
5.4 Part 5: Still Image (SQL/MM Still Image).6
6 Notations and conventions used in other parts.6
6.1 Notation .6
6.2 Conventions .6
6.2.1 Clause structure.6
6.2.2 Organization of specifications .7
6.2.3 Data type, attribute and SQL-invoked routine identifiers.7
6.2.4 Parameter identifiers .7
6.2.5 Meta-variables.7
6.2.6 Symbols .7
6.2.7 Exceptions.7
6.2.8 Status codes.8
7 Implementation requirements .8
7.1 Schemas .8
7.2 USAGE privileges on user-defined types.8
7.3 UNDER privileges on user-defined types.8
7.4 EXECUTE privileges on routines .9
8 Conformance.9
8.1 Implementations .9
8.2 Relationship to other International Standards .9
8.3 Claim of conformance .10
8.4 Extensions and options .10
Annex A (informative) ISO/IEC JTC 1 formal procedures .11
© ISO/IEC 2000 – All rights reserved iii
---------------------- Page: 3 ----------------------
ISO/IEC 13249-1:2000(E)
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 fields of technical activity. ISO and IEC technical committees
collaborate in fields of mutual interest. Other international organizations, governmental and non-governmental, in
liaison with ISO and IEC, also take part in the work.
International Standards are drafted in accordance with the rules given in the ISO/IEC Directives, Part 3.
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 are circulated to national bodies for voting.
Publication as an International Standard requires approval by at least 75 % of the national bodies casting a vote.
Attention is drawn to the possibility that some of the elements of this part of ISO/IEC 13249 may be the subject of
patent rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights.
International Standard ISO/IEC 13249-1 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information
technology, Subcommittee SC 32, Data management and interchange.
ISO/IEC 13249 consists of the following parts, under the general title Information technology — Database
languages — SQL multimedia and application packages:
� Part 1: Framework
� Part 2: Full-Text
� Part 3: Spatial
� Part 5: Still Image
Parts other than this part specify requirements, and all are dependent on various parts of ISO/IEC 9075 and also
on this part of ISO/IEC 13249.
Annex A of this part of ISO/IEC 13249 is for information only.
iv © ISO/IEC 2000 – All rights reserved
---------------------- Page: 4 ----------------------
ISO/IEC 13249-1:2000(E)
Introduction
The organization of this part of ISO/IEC 13249 is as follows:
a) Clause 1, "Scope", specifies the scope of this part of ISO/IEC 13249.
b) Clause 2, "Normative references", identifies additional standards that, through reference in ISO/IEC 13249,
constitute provisions of this part of ISO/IEC 13249, and hence to all parts of ISO/IEC 13249.
c) Clause 3, "Terms and definitions", specifies terms and definitions used in ISO/IEC 13249.
d) Clause 4, "Concepts", describes the concepts used in ISO/IEC 13249.
e) Clause 5, "Parts of ISO/IEC 13249", summarises the content of each of the parts of ISO/IEC 13249.
f) Clause 6, "Notation and conventions used in other parts", defines the notation and conventions used in other
parts of ISO/IEC 13249.
g) Clause 7, "Implementation requirements", describes the requirements relating to the implementation of
ISO/IEC 13249.
h) Clause 8, "Conformance", specifies the conformance requirements for all or some of the parts of ISO/IEC
13249.
i) Annex A is an informative Annex. It describes the formal procedures for maintenance and interpretation of
ISO/IEC 13249.
© ISO/IEC 2000 – All rights reserved v
---------------------- Page: 5 ----------------------
INTERNATIONAL STANDARD ISO/IEC 13249-1:2000(E)
Information technology — Database languages — SQL multimedia
and application packages —
Part 1:
Framework
1 Scope
ISO/IEC 13249 defines a number of packages of generic data types common to various kinds of data used in
multimedia and other subject areas, to enable that data to be stored and manipulated in an SQL database. Each
package is defined as a part of ISO/IEC 13249.
This part of ISO/IEC 13249 defines those concepts, notations and conventions that are common to two or more
other parts of ISO/IEC 13249. In particular it describes the way ISO/IEC 9075 is used in other parts to define the
user-defined types and their behaviour appropriate to each subject area.
2 Normative references
The following normative documents contain provisions which, through reference in this text, constitute provisions of
this part of ISO/IEC 13249. For dated references, subsequent amendments to, or revisions of, any of these
publications do not apply. However, parties to agreements based on this part of ISO/IEC 13249 are encouraged to
investigate the possibility of applying the most recent editions of the normative documents indicated below. For
undated references, the latest edition of the normative document referred to applies. Members of ISO and IEC
maintain registers of currently valid International Standards.
ISO/IEC 9075-1:1999, Information technology — Database languages — SQL — Part 1: Framework
(SQL/Framework).
ISO/IEC 9075-2:1999, Information technology — Database languages — SQL — Part 2: Foundation
(SQL/Foundation).
ISO/IEC 9075-4:1999, Information technology — Database languages — SQL — Part 4: Persistent Stored Modules
(SQL/PSM).
3 Terms and definitions
3.1 Definitions taken from ISO/IEC 9075
The following terms defined in ISO/IEC 9075 are used either in this part of ISO/IEC 13249 or in other parts of
ISO/IEC 13249.
a) assignment
b) attribute
c) cardinality
d) column
© ISO/IEC 2000 – All rights reserved 1
---------------------- Page: 6 ----------------------
ISO/IEC 13249-1:2000(E)
e) compilation unit
f) constructor function
g) data type
h) declared type
i) descriptor
j) external routine
k) identifier
l) implementation-defined
m) implementation-dependent
n) instance (of a value)
o) interface (of a structured type)
p) mutator function
q) null value
r) observer function
s) row
t) sequence
u) signature (of an SQL-invoked routine)
v) SQL-environment
w) SQL-implementation
x) SQL-invoked routine
y) SQL routine
z) subtype
aa) supertype
bb) table
cc) type-preserving function
dd) user-defined type
ee) white space
3.2 Definitions provided in this part of ISO/IEC 13249
For the purposes of this part of ISO/IEC 13249, the following definitions apply.
2 © ISO/IEC 2000 – All rights reserved
---------------------- Page: 7 ----------------------
ISO/IEC 13249-1:2000(E)
3.2.1
generic data type
a generic data type is a kind of data not already defined in ISO/IEC 9075 that is used in a wider context than a
single enterprise and for which there are advantages in standardizing the way it is represented
3.2.2
meta-variable
a meta-variable is a variable which is used to define implementation-dependent or implementation-defined
constants
3.2.3
multimedia
multimedia is any kind of data other than conventional data, examples being graphic, audio and visual data
3.3 Definitions provided in other parts of ISO/IEC 13249
The terms and associated definitions relating to the subject areas of ISO/IEC 13249 are provided by the part of
ISO/IEC 13249 that defines the user-defined types for that subject area.
4 Concepts
4.1 Concepts taken from ISO/IEC 9075
The following concepts defined in ISO/IEC 9075 are used either in this part of ISO/IEC 13249 or in other parts of
ISO/IEC 13249.
a) array
b) base table
c) character set
d) distinct type
e) exception condition
f) false
g) function invocation
h) host language
i) method
j) ordering function
k) predefined data type
l) privilege
m) source type
n) SQL-data
o) SQL-statement
p) structured type
© ISO/IEC 2000 – All rights reserved 3
---------------------- Page: 8 ----------------------
ISO/IEC 13249-1:2000(E)
q) transformation functions
r) true
s) unknown
t) user-defined cast
u) view
4.2 Requirements for generic kinds of data
ISO/IEC 9075 defines the Database Language SQL, which is a language used to define and manipulate SQL-data.
For the purposes of this part of ISO/IEC 13249, the SQL-data in an SQL-environment is referred to as an SQL
database.
Using the data definition facilities of ISO/IEC 9075, an enterprise may develop an SQL database based on the
kinds of data chosen for some specific purpose determined by the particular requirements of the enterprise.
Many kinds of data are used in a wider context than that of an individual enterprise, in which case there are
benefits in being able to use a generic specification for the definition and manipulation of these kinds of data.
These benefits include the enabling of the following:
a) shared understanding of this data;
b) exchange of this data;
c) provision of common manipulation facilities to process this data.
Recognition of these benefits has resulted in the development of international standards and of publicly available
specifications for generic data types in a number of subject areas. These subject areas include text, spatial,
graphic, audio and video data.
Many enterprises have requirements to use such generic data types combined with their own enterprise-specific
data types in an SQL database. These requirements include the manipulation of component elements of a generic
data type, enabling both the construction and recording of user-defined types within an SQL database, and the use
of these components in selection and retrieval of data from an SQL database. ISO/IEC 13249 addresses these
requirements.
4.3 Use of ISO/IEC 9075
ISO/IEC 9075 includes facilities for defining user-defined types. A user-defined type can be either a distinct type or
a structured type. A distinct type is based on some predefined data type. A structured type has attributes specified
as either SQL data types or other user-defined types. A structured type may be defined as a subtype of another
structured type, with inheritance of its attributes. A column of an SQL table can be defined as a user-defined type.
A user-defined type can only be manipulated by associated routines.
An attribute has automatically an associated observer and mutator function to retrieve and change its value.
Further routines may be defined in which the body of the routine, being the component that determines behaviour
on invocation of the routine, is specified either by SQL statements or by reference to an external routine prepared
in some other programming language.
Each part of ISO/IEC 13249 defines a number of user-defined types and associated routines, defined according to
ISO/IEC 9075. The types and routines of each part are intended for use with data for a specific subject area. Each
part constitutes a package that aims to satisfy the requirements for including generic data types for that
...
Questions, Comments and Discussion
Ask us and Technical Secretary will try to provide an answer. You can facilitate discussion about the standard in here.