ISO/IEC 13249-1:2016

INTERNATIONAL ISO/IEC
STANDARD 13249-1
Fourth edition
2016-06-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 —
Partie 1: Cadre général
Reference number
©
ISO/IEC 2016
© ISO/IEC 2016, Published in Switzerland
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized otherwise in any form
or by any means, electronic or mechanical, including photocopying, or posting on the internet or an intranet, without prior
written permission. Permission can be requested from either ISO at the address below or ISO’s member body in the country of
the requester.
ISO copyright office
Ch. de Blandonnet 8 • CP 401
CH-1214 Vernier, Geneva, Switzerland
Tel. +41 22 749 01 11
Fax +41 22 749 09 47
copyright@iso.org
www.iso.org
ii © ISO/IEC 2016 – All rights reserved

Contents Page
Foreword .iv
Introduction .v
1 Scope . 1
2 Normative references . 1
3 Terms and definitions . 1
3.1 Terms defined in ISO/IEC 9075-1 . 1
3.2 Terms defined in ISO/IEC 9075-2 . 2
3.3 Terms defined in this part of ISO/IEC 13249 . 2
4 Concepts . 3
4.1 Concepts taken from parts of ISO/IEC 9075 . 3
4.2 Generic kinds of data and common table structures . 4
4.3 Use of parts of ISO/IEC 9075 . 4
4.3.1 User-defined types and routines . 4
4.3.2 Views and routines . 5
4.3.3 Information schema and definition schema . 5
4.4 Implementation of ISO/IEC 13249 . 6
4.5 Use of ISO/IEC 13249. 6
4.5.1 Use of user defined types . 6
4.5.2 Use of views . . 7
5 Parts of ISO/IEC 13249 . 7
6 Notations and conventions used in other parts . 7
6.1 Notation . 7
6.1.1 Notation of user-defined types and routines . 7
6.1.2 Notation for defining a format of a value . 8
6.1.3 Use of syntax elements defined in parts of ISO/IEC 9075 . 8
6.2 Conventions . 9
6.2.1 Clause structure . 9
6.2.2 Organization of specifications . 9
6.2.3 Data type, attribute, SQL-invoked routine, and view identifiers .10
6.2.4 Parameter identifiers .10
6.2.5 Meta-variables .10
6.2.6 Symbols .10
6.2.7 Exceptions .10
6.2.8 Status codes . . .10
7 Implementation requirements .11
7.1 General .11
7.1.1 Schemas .11
7.1.2 USAGE privileges on user-defined types .11
7.1.3 UNDER privileges on user-defined types .11
7.1.4 EXECUTE privileges on routines .11
7.1.5 SELECT privilege on views .12
7.1.6 DELETE, INSERT, and UPDATE privilege on views .12
8 Conformance .12
8.1 Implementations .12
8.2 Relationship to other International Standards .13
8.3 Claim of conformance .13
8.4 Extensions and options.13
Annex A (informative) ISO/IEC JTC1 formal procedures .14
© ISO/IEC 2016 – All rights reserved iii

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. In the field of information technology, ISO and IEC have established a joint technical committee,
ISO/IEC JTC 1.
The procedures used to develop this document and those intended for its further maintenance are
described in the ISO/IEC Directives, Part 1. In particular the different approval criteria needed for
the different types of document should be noted. This document was drafted in accordance with the
editorial rules of the ISO/IEC Directives, Part 2 (see www.iso.org/directives).
Attention is drawn to the possibility that some of the elements of this document may be the subject
of patent rights. ISO and IEC shall not be held responsible for identifying any or all such patent
rights. Details of any patent rights identified during the development of the document will be in the
Introduction and/or on the ISO list of patent declarations received (see www.iso.org/patents).
Any trade name used in this document is information given for the convenience of users and does not
constitute an endorsement.
For an explanation on the meaning of ISO specific terms and expressions related to conformity
assessment, as well as information about ISO’s adherence to the WTO principles in the Technical
Barriers to Trade (TBT) see the following URL: Foreword - Supplementary information
The committee responsible for this document is ISO/IEC JTC 1, Information technology, SC 32, Data
management and interchange.
This fourth edition cancels and replaces the third edition (ISO/IEC 13249-1:2007), which has been
technically revised.
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
— Part 6: Data mining
— Part 7: History
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.
iv © ISO/IEC 2016 – All rights reserved

Introduction
The purpose of this part of ISO/IEC 13249 is to define multimedia and application specific types and
their associated routines using the user-defined features in parts of ISO/IEC 9075.
This document is based on the content of parts of ISO/IEC 9075, Information technology ― Database
languages ― SQL.
The organization of this part of ISO/IEC 13249 is as follows:
1) Clause 1 specifies the scope of this part of ISO/IEC 13249.
2) Clause 2 identifies additional International 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.
3) Clause 3 specifies terms and definitions used in ISO/IEC 13249.
4) Clause 4 describes the concepts used in ISO/IEC 13249.
5) Clause 5 summarizes the content of each of the parts of ISO/IEC 13249.
6) Clause 6 defines the notation and conventions used in other parts of ISO/IEC 13249.
7) Clause 7 describes the requirements relating to the implementation of ISO/IEC 13249.
8) Clause 8 specifies the conformance requirements for all or some of the parts of ISO/IEC 13249.
9) Annex A (Informative) describes the formal procedures for maintenance and interpretation of
ISO/IEC 13249.
© ISO/IEC 2016 – All rights reserved v

INTERNATIONAL STANDARD ISO/IEC 13249-1:2016(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 and table structures common to
various kinds of data used in multimedia and application areas, to enable that data to be stored and
manipulated in an SQL database. The package in each subject area 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 parts of ISO/IEC 9075 are used
to define the user-defined types and their behaviour and views as a representation of table structures
appropriate to each subject area.
2 Normative references
The following documents, in whole or in part, are normatively referenced in this document and are
indispensable for
...