ISO/IEC 13249-5:2001

Information technology — Database languages — SQL multimedia and application packages — Part 5: Still Image

Technologies de l'information — Langages de bases de données — Multimédia SQL et paquetages d'application — Partie 5: Image fixe

General Information

• Status: Withdrawn
• Publication Date: 16-May-2001
• Withdrawal Date: 16-May-2001
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Current Stage: 9599 - Withdrawal of International Standard
• Start Date: 31-Oct-2003
• Completion Date: 12-Feb-2026

Relations

• Corrected By: ISO/IEC 13249-5:2001/Cor 1:2003 - Information technology — Database languages — SQL multimedia and application packages — Part 5: Still Image — Technical Corrigendum 1
• Effective Date: 06-Jun-2022
• Revised: ISO/IEC 13249-5:2003 - Information technology — Database languages — SQL multimedia and application packages — Part 5: Still image
• Effective Date: 15-Apr-2008
• Parent: ISO/IEC 13249-5:2001/Cor 1:2003 - Information technology — Database languages — SQL multimedia and application packages — Part 5: Still Image — Technical Corrigendum 1
• Effective Date: 15-Apr-2008

Standards Content (Sample)

INTERNATIONAL ISO/IEC
STANDARD 13249-5
First edition
2001-05-01
Information technology — Database
languages — SQL multimedia and
application packages —
Part 5:
Still Image
Technologies de l'information — Langages de bases de données —
Multimédia SQL et paquetages d'application —
Partie 5: Image fixe
Reference number
©
ISO/IEC 2001
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 2001
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 [e-mail]
Web www.iso.ch
Printed in Switzerland
© ISO/IEC 2001 – All rights reserved
ii
Contents Page
Foreword. vi
Introduction . vii
1 Scope. 1
2 Normative references . 3
3 Definitions, notations, and conventions. 5
3.1 Definitions. 5
3.1.1 Definitions provided in Part 1 . 5
3.1.2 Definitions provided in Part 5 . 5
3.1.3 Definitions taken from ISO/IEC 9075.6
3.1.4 Definitions taken from ISO/IEC 10918-1. 6
3.2 Notations. 7
3.2.1 Notations provided in Part 1 . 7
3.2.2 Notations provided in Part 5 . 7
3.3 Conventions. 8
4 Concepts. 9
4.1 Introduction . 9
4.2 Concepts taken from ISO/IEC 9075 . 11
4.3 Types representing digital images. 12
4.3.1 Attributes of the SI_StillImage type. 12
4.3.2 Methods of the SI_StillImage type.12
4.4 Image features. 14
4.4.1 Feature types. 14
4.4.2 Assessing the similarity of images . 15
4.5 Complementary SQL-invoked regular functions . 16
4.6 Auxiliary type SI_Color. 20
4.7 The Still Image Information Schema . 21
5 Still Image Types. 22
5.1 SI_StillImage Types and Routines. 22
5.1.1 SI_StillImage Type. 22
5.1.2 SI_StillImage Methods. 26
5.1.3 SI_setContent Method . 28
5.1.4 SI_changeFormat Method . 29
5.1.5 SI_Thumbnail Methods. 31
5.1.6 Functions Complementing SI_StillImage Methods . 33
5.1.7 SI_chgContent Function. 34
5.1.8 SI_convertFormat Function . 35
5.1.9 SI_getThumbnail Function. 36
5.1.10 SI_getSizedThmbnl Function. 37
5.1.11 Functions Complementing Observer Functions of Type SI_StillImage . 38
5.1.12 Functions not intended for Public Use . 40
6 Feature Types. 47
6.1 SI_AverageColor Type and Routines. 47
6.1.1 SI_AverageColor Type. 47
6.1.2 SI_AverageColor Methods . 49
6.1.3 SI_Score Method . 53
6.1.4 SI_fndAverageColor Function . 54
6.1.5 SI_mkAverageColor Function. 55
6.1.6 SI_ScoreByAvrgClr Function. 56
6.2 SI_ColorHistogram Type and Routines . 57
6.2.1 SI_ColorHistogram Type . 57
© ISO/IEC 2001 - All rights reserved Contents iii

6.2.2 SI_ColorHistogram Methods. 61
6.2.3 SI_Append Method. 64
6.2.4 SI_Score Method . 66
6.2.5 SI_findColorHstgrm Function. 67
6.2.6 SI_mkColorHistogrm Function . 68
6.2.7 SI_arrayClrHstgrm Function . 69
6.2.8 SI_appendClrHstgrm Function . 70
6.2.9 SI_ScoreByClrHstgr Function. 71
6.3 SI_PositionalColor Type and Routines. 72
6.3.1 SI_PositionalColor Type. 72
6.3.2 SI_PositionalColor Method . 74
6.3.3 SI_Score Method . 76
6.3.4 SI_findPositColor Function. 77
6.3.5 SI_ScoreByPositClr Function . 78
6.4 SI_Texture Type and Routines.79
6.4.1 SI_Texture Type. 79
6.4.2 SI_Texture Method . 81
6.4.3 SI_Score Method . 82
6.4.4 SI_findTexture Function . 83
6.4.5 SI_ScoreByTexture Function. 84
6.5 SI_FeatureList Type and Routines . 85
6.5.1 SI_FeatureList Type . 85
6.5.2 SI_FeatureList Method. 89
6.5.3 SI_setFeature Methods. 91
6.5.4 SI_Score Method . 95
6.5.5 SI_mkFeatureList Function. 97
6.5.6 SI_ScoreByFtrList Function. 98
6.5.7 Regular Functions Complementing SI_setFeature Methods. 99
6.5.8 Regular Functions Complementing Observer Functions of type SI_FeatureList . 101
6.6 Auxiliary Types and Routines. 105
6.6.1 SI_Color Type . 105
6.6.2 SI_RGBColor Method. 106
6.6.3 SI_mkRGBColor Function. 108
7 SQL/MM Still Image Information Schema . 110
7.1 Introduction . 110
7.2 SI_IMAGE_FORMATS view . 111
7.3 SI_IMAGE_FORMAT_CONVERSIONS view . 112
7.4 SI_IMAGE_FORMAT_FEATURES view . 113
7.5 SI_THUMBNAIL_FORMATS view. 114
7.6 SI_VALUES view . 115
7.7 Short name views. 116
8 SQL/MM Still Image Definition Schema . 118
8.1 Introduction . 118
8.2 SI_IMAGE_FORMATS base table. 119
8.3 SI_IMAGE_FORMAT_CONVERSIONS base table . 120
8.4 SI_IMAGE_FORMAT_FEATURES base table . 121
8.5 SI_THUMBNAIL_FORMATS base table. 122
8.6 SI_VALUES base table. 123
9 Status Codes . 124
10 Conformance . 127
10.1 Requirements for conformance. 127
10.2 Claims of conformance . 132
Annex A. 133
A.1 Implementation-defined Meta-variables . 134
Annex B. 135
B.1 Implementation-dependent Meta-variables . 137
Index . 138
iv Contents © ISO/IEC 2001 - All rights reserved

Tables Page
Table 1 – Method and function name correspondences. 16
Table 2 – SQLSTATE class and subclass values . 124
© ISO/IEC 2001 - All rights reserved Contents v

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-5 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 4: General purpose facilities
— Part 5: Still Image
— Part 6: Data Mining
Annexes A and B of this part of ISO/IEC 13249 are for information only.
vi Foreword © ISO/IEC 2001 - All rights reserved

Introduction
The purpose of this International Standard is to define multimedia and application specific types and their
associated routines using the user-defined features in ISO/IEC 9075.
This document is based on the content of ISO/IEC International Standard Database Language (SQL).
The organization of this part of ISO/IEC 13249 is as follows:
1) Clause 1, "Scope", specifies the scope of this part of ISO/IEC 13249.
2) Clause 2, "Normative references", identifies additional standards that, through reference in this part of
ISO/IEC 13249, constitute provisions of this part of ISO/IEC 13249.
3) Clause 3, "Definitions, notations, and conventions", defines the notations and conventions used in
this part of ISO/IEC 13249.
4) Clause 4, "Concepts", presents concepts used in the definition of this part of ISO/IEC 13249.
5) Clause 5, "Still Image Types", defines the still image user-defined types and associated routines.
6) Clause 6, "Feature Types", defines the user-defined types provided for the manipulation of still image
features.
7) Clause 7, "SQL/MM Still Image Information Schema" defines the SQL/MM Still Image Information
Schema.
8) Clause 8, "SQL/MM Still Image Definition Schema" defines the SQL/MM Still Image Definition
Schema.
9) Clause 9, "Status Codes", defines the SQLSTATE codes used in this part of ISO/IEC 13249.
10) Clause 10, "Conformance", defines the criteria for conformance to this part of ISO/IEC 13249.
11) Annex A, "Implementation-defined elements", is an informative Annex. It lists those features for
which the body of this part of ISO/IEC 13249 states that the syntax or meaning or effect on the
database is partly or wholly implementation-defined, and describes the defining information that an
implementor shall provide in each case.
12) Annex B, "Implementation-dependent elements", is an informative Annex. It lists those features for
which the body of this part of ISO/IEC 13249 states explicitly that the meaning or effect on the
database is implementation-dependent.
In the text of this part of ISO/IEC 13249, Clauses begin a new odd-numbered page, and in Clause 5, "Still
Image Types", through Clause 10, "Conformance", Subclauses begin a new page. Any resulting blank
space is not significant.
© ISO/IEC 2001 - All rights reserved Introduction vii

INTERNATIONAL STANDARD ISO/IEC 13249-5:2001(E)
Information technology — Database languages —
SQL multimedia and application packages —
Part 5:
Still Image
1 Scope
This part of ISO/IEC 13249:
a) introduces the Still Image part of ISO/IEC 13249,
b) gives the references necessary for this part of this part of ISO/IEC 13249,
c) defines notations and conventions specific to this part of this part of ISO/IEC 13249,
d) defines concepts specific to this part of this part of ISO/IEC 13249,
e) defines the still image user-defined types and their associated routines.
The still image user-defined types defined in this part adhere to the following:
– A still image user-defined type is generic to image data handling. It addresses the need to store,
manage and retrieve information based on aspects of image data such as height, width and format
and based on image features such as average color, color histogram, positional color and texture.
– A still image user-defined type does not redefine the database language SQL directly or in
combination with another still image data type.
The still image user-defined types are applicable to all different image formats. However, not all functionality
canbeusedwithallknownstillimageformats.
An implementation of this part of ISO/IEC 13249 may exist in environments that also support information and
content management, decision support, data mining, and data warehousing systems.
Application areas addressed by implementations of this part of ISO/IEC 13249 include, but are not restricted
to, graphics, multimedia, scientific research, and medicine.
© ISO/IEC 2001 - All rights reserved Scope 1

Blank page
2 Scope © ISO/IEC 2001 - All rights reserved

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).
ISO/IEC 13249-1:2000, Information technology — Database languages — SQL multimedia and
application packages — Part 1: Framework.
ISO/IEC 10918-1:1994, Information technology — Digital compression and coding of continuous-tone still
images: Requirements and guidelines.
© ISO/IEC 2001 - All rights reserved Normative references 3

Blank page
4 Normative references © ISO/IEC 2001 - All rights reserved

3.1 Definitions
3 Definitions, notations, and conventions
3.1 Definitions
For the purposes of this part of ISO/IEC 13249, the following definitions apply.
3.1.1 Definitions provided in Part 1
This part of ISO/IEC 13249 makes use of all terms defined in Part 1 of ISO/IEC 13249.
3.1.2 Definitions provided in Part 5
This part of ISO/IEC 13249 defines the following terms:
3.1.2.1
basic image feature
a basic image feature is an image feature that is not a composite feature
3.1.2.2
color space
a set of conventions how to represent a color value
3.1.2.3
composite feature
an image feature which consists of basic image features and their associated weights
3.1.2.4
image format
a set of conventions for storing the image data of digital images in a specific compressed or
uncompressed interchange format
3.1.2.5
image feature
characteristic (other than inherent image characteristics) of the image data
3.1.2.6
inherent image characteristics
image format and particular physical characteristics of a digital image
3.1.2.7
list of weighted features
see composite feature
3.1.2.8
picture element
see sample in Subclause 3.1.4, "Definitions taken from ISO/IEC 10918-1"
3.1.2.9
raw image
a binary string that represents a certain image
3.1.2.10
similarity of images
a numerical measure obtainable by the comparison of two images; the measure is based on image
features
© ISO/IEC 2001 - All rights reserved Definitions, notations, and conventions 5

3.1 Definitions
3.1.2.11
thumbnail
a raw image which was obtained from another raw image by downsizing
3.1.3 Definitions taken from ISO/IEC 9075
This part of ISO/IEC 13249 makes use of the following terms defined in ISO/IEC 9075:
3.1.4 Definitions taken from ISO/IEC 10918-1
This part of ISO/IEC 13249 makes use of the following terms defined in ISO/IEC 10918-1:
a) columns
NOTE 1 The use of "columns" here is as defined in the JPEG standard and not as defined in
the SQL standard.
b) component
c) (digital) (still) image
NOTE 2 Parentheses around the text "digital" and "still" is a convention used by ISO/IEC
10918-1 to denote that the phases "digital image", "still image", and "image" are interchangeable.
d) image data
e) interchange format
f) (number of) lines
NOTE 3 Parentheses around the text "number of" is a convention used by ISO/IEC 10918-1 to
denote that the phases "number of lines" and "lines" are interchangeable.
g) sample
6 Definitions, notations, and conventions © ISO/IEC 2001 - All rights reserved

3.2 Notations
3.2 Notations
3.2.1 Notations provided in Part 1
The notations used in this part of ISO/IEC 13249 are defined in Part 1 of ISO/IEC 13249.
3.2.2 Notations provided in Part 5
This part of ISO/IEC 13249 uses the prefix 'SI_' for user-defined types, attributes and SQL-invoked
routine names.
© ISO/IEC 2001 - All rights reserved Definitions, notations, and conventions 7

3.3 Conventions
3.3 Conventions
The conventions used in this part of ISO/IEC 13249 are defined in Part 1 of ISO/IEC 13249.
8 Definitions, notations, and conventions © ISO/IEC 2001 - All rights reserved

4 Concepts
4.1 Introduction
In the context of this part of ISO/IEC 13249, digital images are effectively 2-dimensional arrays of picture
elements, or samples. The internal representation of a sample in the raw image itself is image format
specific. The color value of a sample in the image data might be represented by an index in a color look
up table, spread over multiple color planes, multiple binary strings which represent the single components
of a color, or in any other image format specific way.
An image format is a set of conventions for storing digital images in an interchange format. An image
consists of the representation and organization of data that constitute the picture elements, and
prescriptions about auxiliary data that control the interpretation and processing of the digital image
information according to that format.
A color space, which is used to represent the color values of the samples, is either defined by the image
format or described in the header information of the raw image.
An image format is referenced by format indications. A format indication is a character string whose
format and content is implementation-defined.
A binary string that adheres to a certain image format is called a raw image.
The inherent image characteristics of a raw image consist of:
- the format of the raw image;
- the width of the raw image is the number of columns of the image data;
- the height of the raw image is the number of lines of the image data.
An image format is a format supported by an implementation (for short: a supported format)if the
implementation is able to derive the inherent image characteristics and features from the raw image.
NOTE 4 Features are described in Subclause 4.4, "Image features".
This part of ISO/IEC 13249 defines types and routines with provisions for storing and manipulating still
images. This part of ISO/IEC 13249 consists of the following parts:
- The data type SI_StillImage, a value of which has the following structure:
- a digital representation of a still image;
- format conventions used for representing that still image;
- physical characteristics of that still image (such as its height and width).
- Methods on the data type SI_StillImage for:
- constructing SI_StillImage values;
- obtaining the digital representation of an image or the inherent image characteristics of the
image;
- obtaining a thumbnail from an SI_StillImage value.
- Feature data types that abstract from certain characteristics of the pictorial information contained
in images; these data types provide facilities for:
© ISO/IEC 2001 - All rights reserved Concepts 9

4.1 Introduction
- deriving feature values from a given image;
- constructing feature values;
- deriving metric values that characterize the content of images with respect to feature values;
- Information Schema views that provide data describing certain capabilities of an
implementation of this part of ISO/IEC 13249.
A conforming implementation of this part of ISO/IEC 13249 shall be based on SQL-implementations that
supports Core SQL as defined by ISO/IEC 9075. A number of provisions are made for that purpose:
- No function name overloading is used for SQL-invoked regular functions that are intended for
public use;
- For every method that is intended for public use, a corresponding SQL-invoked regular function is
specified that provides the same services as the associated method;
- The lengths of the names of schemata, types and SQL-invoked regular functions that are
intended for public use do not exceed 18 characters. If the name of a view of the Still Image
Information Schema exceeds 18 characters, an equivalent view with a short identifier is also
specified.
10 Concepts © ISO/IEC 2001 - All rights reserved

4.2 Concepts taken from ISO/IEC 9075
4.2 Concepts taken from ISO/IEC 9075
The following concepts defined in ISO/IEC 9075 are used in this part of ISO/IEC 13249.
a) binary string
b) EXECUTE privilege
c) function
d) SQL-invoked regular function
© ISO/IEC 2001 - All rights reserved Concepts 11

4.3 Types representing digital images
4.3 Types representing digital images
4.3.1 Attributes of the SI_StillImage type
The SI_StillImage type is an abstraction for digital images, using the following attributes:
- The attribute SI_content to represent the raw image;
- The attribute SI_contentLength to represent the length of the raw image;
- The attribute SI_format to represent a format indication; it identifies the image format of the raw
image;
- The attribute SI_width to represent the width of the raw image;
- The attribute SI_height to represent the height of the raw image.
4.3.2 Methods of the SI_StillImage type
The type SI_StillImage provides the following methods for public use:
- SI_StillImage: constructs an SI_StillImage value from a raw image;
- SI_StillImage: constructs an SI_StillImage value from a raw image and a character string
representing a format indication; this method allows for user-supplied format information when
SI_StillImage values are to be constructed from a raw image whose format is not a supported
one;
- SI_setContent: has the same effect as the invocation of the mutator function for the SI_content
attribute, but additionally adjusts the values of the attributes that represent the inherent image
characteristics;
- SI_changeFormat: has the same effect as the invocation of the mutator function for the SI_format
attribute, but additionally adjusts the value of the attribute SI_content and the values of the
attributes which represent the inherent image characteristics. The format conversion fails if the
conversion between the source image format and the target image format is not supported;
- SI_Thumbnail: obtains a thumbnail from an SI_StillImage value;
- SI_content: returns the representation of the raw image;
- SI_contentLength: returns the length in bytes of the representation of the raw image;
- SI_format: returns the format indication of the image;
- SI_height: returns the number of lines of the image;
- SI_width: returns the number of columns of the image.
12 Concepts © ISO/IEC 2001 - All rights reserved

4.4 Image features
4.4 Image features
Image features (for short: features) are used to characterize the pictorial information of an image by
means other than inherent image characteristics. This part of ISO/IEC 13249 supports four basic
features and one composite feature. The basic features are:
- Average color feature: this feature characterizes an image by its average color;
- Color histogram feature: this feature characterizes an image by the relative frequencies of the colors
exhibited by the samples of the raw image;
- Positional color feature: let an image be divided into n by m rectangles; the positional color feature
characterizes that image by the n by m average colors of these rectangles;
- Texture feature: this feature characterizes an image by the size of repeating items (coarseness),
brightness variations (contrast), and the predominant direction (directionality).
All basic features can be derived from images. In addition, the two basic features average color feature
and color histogram feature can be constructed by means of numerical values.
The composite feature is a list of up to 4 basic features, each of a different feature type. All the basic
features in the composite feature are associated with a feature weight.
Features are represented by feature types. Values of those types are used for obtaining a quantitative
measure for the similarity between two images represented as SI_StillImage values, say, I and I .If F is
1 2 2
some feature that characterizes the image I , then a similarity measure for the images I and I is obtained
2 1 2
from F by a method SI_Score that takes I as its parameter. For a given pair of images, the obtained
2 1
similarity depends on the kind of feature used for comparison; the exact relationship is implementation-
dependent.
4.4.1 Feature types
The basic features are represented by the following feature types:
- Average color feature: SI_AverageColor;
- Color histogram feature: SI_ColorHistogram;
- Positional color feature: SI_PositionalColor;
- Texture feature: SI_Texture.
The composite feature is represented by the feature type SI_FeatureList.
For all basic features methods and functions are provided that derive the corresponding feature value
from an SI_StillImage value. The functions are:
- Average color feature: SI_fndAverageColor;
- Color histogram feature: SI_findColorHstgrm;
- Positional color feature: SI_findPositColor;
- Texture feature: SI_findTexture.
© ISO/IEC 2001 - All rights reserved Concepts 13

4.4 Image features
SI_AverageColor and SI_ColorHistogram values can also be obtained by methods SI_AverageColor and
SI_ColorHistogram, respectively. The parameter of the first method is a color value that is used to
represent the intended average color. The second method takes a first color value and a first frequency
and returns an initial color histogram. This initial color histogram can be extended using the method
SI_Append.
SI_FeatureList values must be constructed from basic feature values and associated weights.
The observer and mutator functions of the basic feature types are not intended for public use. Thus, there
are no GRANT statements granting EXECUTE privilege on these functions.
4.4.2 Assessing the similarity of images
Every feature type has a method SI_Score. This method can be used for obtaining numerical values that
measure the similarity between two images. To that end, a distance function is used for this
measurement. The returned numerical value for the distance indicates the difference between a given
feature value and a still image value. Let F be some feature value that characterizes an SI_StillImage
values I . Then
F .SI_Score(I )
1 2
returns a measure for the similarity of the SI_StillImage value I to the feature value F .
2 1
14 Concepts © ISO/IEC 2001 - All rights reserved

4.5 Complementary SQL-invoked regular functions
4.5 Complementary SQL-invoked regular functions
To ease conformance for implementation of this part of ISO/IEC 13249, each method intended for public
use is complemented by an SQL-invoked regular function.
For each such method, the type of specified method, the method name, parameter types (if any), and the
name of the corresponding SQL-invoked regular function is listed in Table 1 – Method and function name
correspondences. Since the names of these functions are unique, their parameter types are not given.
Table 1 – Method and function name correspondences
Type Name Method Name Parameter Types (if any) Function Name
SI_StillImage SI_StillImage BINARY LARGE OBJECT SI_mkStillImage1
SI_StillImage SI_StillImage BINARY LARGE OBJECT, SI_mkStillImage2
CHARACTER VARYING
SI_StillImage SI_setContent BINARY LARGE OBJECT SI_chgContent
SI_StillImage SI_changeFormat CHARACTER VARYING SI_convertFormat
SI_StillImage SI_content SI_getContent
SI_StillImage SI_contentLength SI_getContentLngth
SI_StillImage SI_format SI_getFormat
SI_StillImage SI_height SI_getHeight
SI_StillImage SI_width SI_getWidth
SI_StillImage SI_Thumbnail SI_getThumbnail
SI_StillImage SI_Thumbnail INTEGER, SI_getSizedThmbnl
INTEGER
SI_AverageColor SI_AverageColor SI_StillImage SI_fndAverageColor
SI_AverageColor SI_AverageColor SI_Color SI_mkAverageColor
SI_AverageColor SI_Score SI_StillImage SI_ScoreByAvrgClr
SI_ColorHistogram SI_ColorHistogram SI_StillImage SI_findColorHstgrm
SI_ColorHistogram SI_ColorHistogram SI_Color, SI_mkColorHistogrm
DOUBLE PRECISION
SI_ColorHistogram SI_ColorHistogram SI_Color ARRAY, SI_arrayClrHstgrm
DOUBLE PRECISION ARRAY
SI_ColorHistogram SI_Append SI_Color, SI_appendClrHstgrm
DOUBLE PRECISION
SI_ColorHistogram SI_Score SI_StillImage SI_ScoreByClrHstgr
SI_PositionalColor SI_PositionalColor SI_StillImage SI_findPositColor
SI_PositionalColor SI_Score SI_StillImage SI_ScoreByPositClr
SI_Texture SI_Texture SI_StillImage SI_findTexture
SI_Texture SI_Score SI_StillImage SI_ScoreByTexture
© ISO/IEC 2001 - All rights reserved Concepts 15

4.5 Complementary SQL-invoked regular functions
Type Name Method Name Parameter Types (if any) Function Name
SI_FeatureList SI_FeatureList SI_AverageColor, SI_mkFeatureList
DOUBLE PRECISION,
SI_ColorHistogram,
DOUBLE PRECISION,
SI_PositionalColor,
DOUBLE PRECISION,
SI_Texture,
DOUBLE PRECISION
SI_FeatureList SI_setFeature SI_AverageColor, SI_setAvgClrFtrW
DOUBLE PRECISION
SI_FeatureList SI_setFeature SI_ColorHistogram, SI_setClrHstgrFtrW
DOUBLE PRECISION
SI_FeatureList SI_setFeature SI_PositionalColor, SI_setPstnlClrFtrW
DOUBLE PRECISION
SI_FeatureList SI_setFeature SI_Texture, SI_setTextureFtrW
DOUBLE PRECISION
SI_FeatureList SI_AvgClrFtr SI_getAvgClrFtr
SI_FeatureList SI_AvgClrFtrWght SI_getAvgClrFtrW
SI_FeatureList SI_ClrHstgrFtr SI_getClrHstgrFtr
SI_FeatureList SI_ClrHstgrFtrWght SI_getClrHstgrFtrW
SI_FeatureList SI_PstnlClrFtr SI_getPstnlClrFtr
SI_FeatureList SI_PstnlClrFtrWght SI_getPstnlClrFtrW
SI_FeatureList SI_TextureFtr SI_getTextureFtr
SI_FeatureList SI_TextureFtrWght SI_getTextureFtrW
SI_FeatureList SI_Score SI_StillImage SI_ScoreByFtrList
SI_Color SI_RGBColor INTEGER, SI_mkRGBColor
INTEGER,
INTEGER
16 Concepts © ISO/IEC 2001 - All rights reserved

4.6 Auxiliary type SI_Color
4.6 Auxiliary type SI_Color
Color values are encapsulated by the type SI_Color. The implementation shall provide constructor
methods to obtain SI_Color values. Each constructor method is provided for a specific color space. Each
function takes parameters that represent the intended color value in this color space. A constructor
method SI_RGBColor, for the RGB color space, is in this part of ISO/IEC 13249. Constructor methods for
other color spaces are implementation defined.
© ISO/IEC 2001 - All rights reserved Concepts 17

4.7 The Still Image Information Schema
4.7 The Still Image Information Schema
This part of ISO/IEC 13249 prescribes an Information Schema called SI_INFORMTN_SCHEMA. It
contains views for the following purposes:
- a view SI_IMAGE_FORMATS that lists the format indications of the supported image formats;
- a view SI_IMAGE_FORMAT_CONVERSIONS that lists pairs of format indications of image
formats for which format conversions are supported;
- a view SI_IMAGE_FORMAT_FEATURES that lists pairs of format indications and feature
indications; images of the indicated image format support the extraction of the indicated feature
and scoring with respect to that feature;
- a view SI_THUMBNAIL_FORMATS that lists the format indications of image formats from which
thumbnails can be derived;
- a view SI_VALUES that lists implementation-defined values.
18 Concepts © ISO/IEC 2001 - All rights reserved

5 Still Image Types
The types in this family provide for the storage and retrieval of still image values.
5.1 SI_StillImage Types and Routines
5.1.1 SI_StillImage Type
Purpose
The SI_StillImage type provides the definition of a still image type.
Definition
CREATE TYPE SI_StillImage
AS (
SI_content BINARY LARGE OBJECT(SI_MaxContentLength),
SI_contentLength INTEGER,
SI_format CHARACTER VARYING(SI_MaxFormatLength),
SI_height INTEGER,
SI_width INTEGER
)
INSTANTIABLE
NOT FINAL
CONSTRUCTOR METHOD SI_StillImage
(content BINARY LARGE OBJECT(SI_MaxContentLength))
RETURNS SI_StillImage
SELF AS RESULT
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
CALLED ON NULL INPUT,
CONSTRUCTOR METHOD SI_StillImage
(content BINARY LARGE OBJECT(SI_MaxContentLength),
explicitFormat CHARACTER VARYING(SI_MaxFormatLength))
RETURNS SI_StillImage
SELF AS RESULT
LANGUAGE SQL
DETERMINISTIC
CONTAINS
...