1、Reference numberISO/IEC 13249-5:2001(E)ISO/IEC 2001INTERNATIONALSTANDARDISO/IEC13249-5First edition2001-05-01Information technology Databaselanguages SQL multimedia andapplication packages Part 5:Still ImageTechnologies de linformation Langages de bases de donnes Multimdia SQL et paquetages dapplica
2、tion Partie 5: Image fixeAdopted by INCITS (InterNational Committee for Information Technology Standards) as an American National Standard. Date of ANSI Approval: 10/22/01 Published by American National Standards Institute, 25 West 43rd Street, New York, New York 10036 Copyright 2002 by Information
3、Technology Industry Council (ITI). All rights reserved. These materials are subject to copyright claims of International Standardization Organization (ISO), International Electrotechnical Commission (IEC), American National Standards Institute (ANSI), and Information Technology Industry Council (ITI
4、). Not for resale. No part of this publication may be reproduced in any form, including an electronic retrieval system, without the prior written permission of ITI. All requests pertaining to this standard should be submitted to ITI, 1250 Eye Street NW, Washington, DC 20005. Printed in the United St
5、ates of America ISO/IEC 13249-5:2001(E)PDF disclaimerThis PDF file may contain embedded typefaces. In accordance with Adobes licensing policy, this file may be printed or viewed but shall notbe edited unless the typefaces which are embedded are licensed to and installed on the computer performing th
6、e editing. In downloading thisfile, parties accept therein the responsibility of not infringing Adobes licensing policy. The ISO Central Secretariat accepts no liability in thisarea.Adobe is a trademark of Adobe Systems Incorporated.Details of the software products used to create this PDF file can b
7、e found in the General Info relative to the file; the PDF-creation parameterswere optimized for printing. Every care has been taken to ensure that the file is suitable for use by ISO member bodies. In the unlikely eventthat a problem relating to it is found, please inform the Central Secretariat at
8、the address given below. ISO/IEC 2001All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronicor mechanical, including photocopying and microfilm, without permission in writing from either ISO at the address bel
9、ow or ISOs member bodyin the country of the requester.ISO copyright officeCase postale 56 Gb7 CH-1211 Geneva 20Tel. + 41 22 749 01 11Fax + 41 22 749 09 47E-mail copyrightiso.chWeb www.iso.chPrinted in Switzerlandii ISO/IEC 2001 All rights reservedISO/IEC 13249-5:2001(E) ISO/IEC 2001 - All rights res
10、erved Contents iiiContents PageForeword. viIntroduction . vii1 Scope. 12 Normative references 33 Definitions, notations, and conventions 53.1 Definitions. 53.1.1 Definitions provided in Part 1 . 53.1.2 Definitions provided in Part 5 . 53.1.3 Definitions taken from ISO/IEC 907563.1.4 Definitions take
11、n from ISO/IEC 10918-1. 63.2 Notations. 73.2.1 Notations provided in Part 1 . 73.2.2 Notations provided in Part 5 . 73.3 Conventions 84 Concepts. 94.1 Introduction 94.2 Concepts taken from ISO/IEC 9075 114.3 Types representing digital images. 124.3.1 Attributes of the SI_StillImage type 124.3.2 Meth
12、ods of the SI_StillImage type124.4 Image features 144.4.1 Feature types 144.4.2 Assessing the similarity of images 154.5 Complementary SQL-invoked regular functions 164.6 Auxiliary type SI_Color 204.7 The Still Image Information Schema 215 Still Image Types 225.1 SI_StillImage Types and Routines 225
13、.1.1 SI_StillImage Type 225.1.2 SI_StillImage Methods. 265.1.3 SI_setContent Method . 285.1.4 SI_changeFormat Method . 295.1.5 SI_Thumbnail Methods 315.1.6 Functions Complementing SI_StillImage Methods 335.1.7 SI_chgContent Function 345.1.8 SI_convertFormat Function 355.1.9 SI_getThumbnail Function
14、365.1.10 SI_getSizedThmbnl Function 375.1.11 Functions Complementing Observer Functions of Type SI_StillImage . 385.1.12 Functions not intended for Public Use 406 Feature Types. 476.1 SI_AverageColor Type and Routines. 476.1.1 SI_AverageColor Type. 476.1.2 SI_AverageColor Methods 496.1.3 SI_Score Me
15、thod 536.1.4 SI_fndAverageColor Function 546.1.5 SI_mkAverageColor Function. 556.1.6 SI_ScoreByAvrgClr Function 566.2 SI_ColorHistogram Type and Routines . 576.2.1 SI_ColorHistogram Type . 57ISO/IEC 13249-5:2001(E)iv Contents ISO/IEC 2001 - All rights reserved6.2.2 SI_ColorHistogram Methods. 616.2.3
16、 SI_Append Method. 646.2.4 SI_Score Method 666.2.5 SI_findColorHstgrm Function. 676.2.6 SI_mkColorHistogrm Function . 686.2.7 SI_arrayClrHstgrm Function . 696.2.8 SI_appendClrHstgrm Function . 706.2.9 SI_ScoreByClrHstgr Function. 716.3 SI_PositionalColor Type and Routines 726.3.1 SI_PositionalColor
17、Type 726.3.2 SI_PositionalColor Method . 746.3.3 SI_Score Method 766.3.4 SI_findPositColor Function. 776.3.5 SI_ScoreByPositClr Function . 786.4 SI_Texture Type and Routines796.4.1 SI_Texture Type 796.4.2 SI_Texture Method . 816.4.3 SI_Score Method 826.4.4 SI_findTexture Function 836.4.5 SI_ScoreByT
18、exture Function 846.5 SI_FeatureList Type and Routines . 856.5.1 SI_FeatureList Type . 856.5.2 SI_FeatureList Method. 896.5.3 SI_setFeature Methods 916.5.4 SI_Score Method 956.5.5 SI_mkFeatureList Function. 976.5.6 SI_ScoreByFtrList Function 986.5.7 Regular Functions Complementing SI_setFeature Meth
19、ods. 996.5.8 Regular Functions Complementing Observer Functions of type SI_FeatureList . 1016.6 Auxiliary Types and Routines. 1056.6.1 SI_Color Type . 1056.6.2 SI_RGBColor Method. 1066.6.3 SI_mkRGBColor Function. 1087 SQL/MM Still Image Information Schema 1107.1 Introduction 1107.2 SI_IMAGE_FORMATS
20、view . 1117.3 SI_IMAGE_FORMAT_CONVERSIONS view . 1127.4 SI_IMAGE_FORMAT_FEATURES view 1137.5 SI_THUMBNAIL_FORMATS view 1147.6 SI_VALUES view 1157.7 Short name views. 1168 SQL/MM Still Image Definition Schema . 1188.1 Introduction 1188.2 SI_IMAGE_FORMATS base table 1198.3 SI_IMAGE_FORMAT_CONVERSIONS
21、base table . 1208.4 SI_IMAGE_FORMAT_FEATURES base table 1218.5 SI_THUMBNAIL_FORMATS base table 1228.6 SI_VALUES base table. 1239 Status Codes 12410 Conformance 12710.1 Requirements for conformance 12710.2 Claims of conformance . 132Annex A 133A.1 Implementation-defined Meta-variables 134Annex B 135B
22、.1 Implementation-dependent Meta-variables . 137Index . 138ISO/IEC 13249-5:2001(E) ISO/IEC 2001 - All rights reserved Contents vTables PageTable 1 Method and function name correspondences. 16Table 2 SQLSTATE class and subclass values 124ISO/IEC 13249-5:2001(E)vi Foreword ISO/IEC 2001 - All rights re
23、servedForewordISO (the International Organization for Standardization) and IEC (the International ElectrotechnicalCommission) form the specialized system for worldwide standardization. National bodies that aremembers of ISO or IEC participate in the development of International Standards through tec
24、hnicalcommittees 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 internationalorganizations, governmental and non-governmental, in liaison with ISO and IEC, also take part
25、 in thework.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/IECJTC 1. Draft International Standards adopted by the joint technical committee
26、are circulated to nationalbodies for voting. Publication as an International Standard requires approval by at least 75 % of thenational bodies casting a vote.Attention is drawn to the possibility that some of the elements of this part of ISO/IEC 13249 may be thesubject of patent rights. ISO and IEC
27、shall not be held responsible for identifying any or all such patentrights.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 t
28、he general title Information technology Databaselanguages 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 MiningAnnexes A and B of this part of ISO/IEC 13249 are for information only.ISO/
29、IEC 13249-5:2001(E) ISO/IEC 2001 - All rights reserved Introduction viiIntroductionThe purpose of this International Standard is to define multimedia and application specific types and theirassociated routines using the user-defined features in ISO/IEC 9075.This document is based on the content of I
30、SO/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 ofISO/I
31、EC 13249, constitute provisions of this part of ISO/IEC 13249.3) Clause 3, “Definitions, notations, and conventions“, defines the notations and conventions used inthis 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, “
32、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 imagefeatures.7) Clause 7, “SQL/MM Still Image Information Schema“ defines the SQL/MM Still Image InformationSche
33、ma.8) Clause 8, “SQL/MM Still Image Definition Schema“ defines the SQL/MM Still Image DefinitionSchema.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
34、 A, “Implementation-defined elements“, is an informative Annex. It lists those features forwhich the body of this part of ISO/IEC 13249 states that the syntax or meaning or effect on thedatabase is partly or wholly implementation-defined, and describes the defining information that animplementor sha
35、ll provide in each case.12) Annex B, “Implementation-dependent elements“, is an informative Annex. It lists those features forwhich the body of this part of ISO/IEC 13249 states explicitly that the meaning or effect on thedatabase is implementation-dependent.In the text of this part of ISO/IEC 13249
36、, Clauses begin a new odd-numbered page, and in Clause 5, “StillImage Types“, through Clause 10, “Conformance“, Subclauses begin a new page. Any resulting blankspace is not significant.INTERNATIONAL STANDARD ISO/IEC 13249-5:2001(E) ISO/IEC 2001 - All rights reserved Scope 1Information technology Dat
37、abase languages SQL multimedia and application packages Part 5:Still Image1 ScopeThis 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
38、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 t
39、o image data handling. It addresses the need to store,manage and retrieve information based on aspects of image data such as height, width and formatand based on image features such as average color, color histogram, positional color and texture. A still image user-defined type does not redefine the
40、 database language SQL directly or incombination with another still image data type.The still image user-defined types are applicable to all different image formats. However, not all functionalitycanbeusedwithallknownstillimageformats.An implementation of this part of ISO/IEC 13249 may exist in envi
41、ronments that also support information andcontent 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 restrictedto, graphics, multimedia, scientific research, and medicine.ISO/IEC 13
42、249-5:2001(E)2 Scope ISO/IEC 2001 - All rights reservedBlank pageISO/IEC 13249-5:2001(E) ISO/IEC 2001 - All rights reserved Normative references 32 Normative referencesThe following normative documents contain provisions which, through reference in this text, constituteprovisions of this part of ISO
43、/IEC 13249. For dated references, subsequent amendments to, or revisionsof, any of these publications do not apply. However, parties to agreements based on this part ofISO/IEC 13249 are encouraged to investigate the possibility of applying the most recent editions of thenormative documents indicated
44、 below. For undated references, the latest edition of the normativedocument referred to applies. Members of ISO and IEC maintain registers of currently valid InternationalStandards.ISO/IEC 9075-1:1999, Information technology Database languages SQL Part 1: Framework(SQL/Framework).ISO/IEC 9075-2:1999
45、, Information technology Database languages SQL Part 2: Foundation(SQL/Foundation).ISO/IEC 9075-4:1999, Information technology Database languages SQL Part 4: PersistentStored Modules (SQL/PSM).ISO/IEC 13249-1:2000, Information technology Database languages SQL multimedia andapplication packages Part
46、 1: Framework.ISO/IEC 10918-1:1994, Information technology Digital compression and coding of continuous-tone stillimages: Requirements and guidelines.ISO/IEC 13249-5:2001(E)4 Normative references ISO/IEC 2001 - All rights reservedBlank pageISO/IEC 13249-5:2001(E)3.1 Definitions ISO/IEC 2001 - All ri
47、ghts reserved Definitions, notations, and conventions 53 Definitions, notations, and conventions3.1 DefinitionsFor the purposes of this part of ISO/IEC 13249, the following definitions apply.3.1.1 Definitions provided in Part 1This part of ISO/IEC 13249 makes use of all terms defined in Part 1 of IS
48、O/IEC 13249.3.1.2 Definitions provided in Part 5This part of ISO/IEC 13249 defines the following terms:3.1.2.1basic image featurea basic image feature is an image feature that is not a composite feature3.1.2.2color spacea set of conventions how to represent a color value3.1.2.3composite featurean im
49、age feature which consists of basic image features and their associated weights3.1.2.4image formata set of conventions for storing the image data of digital images in a specific compressed oruncompressed interchange format3.1.2.5image featurecharacteristic (other than inherent image characteristics) of the image data3.1.2.6inherent image characteristicsimage format and particular physical characteristics of a digital image3.1.2.7list of weighted featuressee composite feature3.1.2.8picture elementsee sample in Su
