1、BRITISH STANDARD BS ISO/IEC 13249-5:2003 Information technology Database languages SQL multimedia and application packages Part 5: Still image ICS 35.060 BS ISO/IEC 13249-5:2003 This British Standard was published under the authority of the Standards Policy and Strategy Committee on 11 November 2003
2、 BSI 11 November 2003 ISBN 0 580 42907 5 National foreword This British Standard reproduces verbatim ISO/IEC 13249-5:2003 and implements it as the UK national standard. It supersedes BS ISO/IEC 13249-5:2001 which is withdrawn. The UK participation in its preparation was entrusted to Technical Commit
3、tee IST/40, Data management and interchange, which has the responsibility to: A list of organizations represented on this committee can be obtained on request to its secretary. Cross-references The British Standards which implement international publications referred to in this document may be found
4、 in the BSI Catalogue under the section entitled “International Standards Correspondence Index”, or by using the “Search” facility of the BSI Electronic Catalogue or of British Standards Online. This publication does not purport to include all the necessary provisions of a contract. Users are respon
5、sible for its correct application. Compliance with a British Standard does not of itself confer immunity from legal obligations. aid enquirers to understand the text; present to the responsible international/European committee any enquiries on the interpretation, or proposals for change, and keep th
6、e UK interests informed; monitor related international and European developments and promulgate them in the UK. Summary of pages This document comprises a front cover, an inside front cover, the ISO/IEC title page, pages ii to vii, a blank page, pages 1 to 104, an inside back cover and a back cover.
7、 The BSI copyright notice displayed in this document indicates when the document was last issued. Amendments issued since publication Amd. No. Date Comments Reference number ISO/IEC 13249-5:2003(E) OSI3002 CEI/INTERNATIONAL STANDARD ISO/IEC 13249-5 Second edition 2003-11-01 Information technology Da
8、tabase languages SQL multimedia and application packages Part 5: Still image Technologies de linformation Langages de bases de donnes Multimdia SQL et paquetages dapplication Partie 5: Image fixe BSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) DPlcsid Fremia ihTs PDF file mya ctnoian emdebt dedyfepcaes.
9、 In ccacnadrow eitA hebods licnesilop gnic,y tihs file mirp eb yatnde iv roweb detu slahl ton ide ebtlnu deess teh typfecaes wihce era hml era deddebicsnede ti dna onstlalde t noeh comuptfrep reromign tide ehtin.g In wodlnidaot gnihs fil,e trapise atpecc tiereht nser ehnopsiiblity fo nto ifnriigngn
10、Aebods licnesilop gnic.y ehT ISO tneClar Secrteirata caceptl on siibality in this .aera Ai ebods a tedarmfo kra Aebod SystemI snctaropro.de teDials fo teh sfotwcudorp erats sut deo crtaee tihs PDF file cna f ebi dnuon tlareneG eh Ifnler oatit evt oeh file; tP ehDc-Frtaeino marapteres wtpo ereimizf d
11、eirp rotni.gn Evc yresah era t neebakt nesne ot erutah teh fili es siutlbaf eosu rI yb eSO memdob rebeis. In tlnu ehikletneve y ttah lborp aem lertait gno it is f,dnuo plsaee ifnrom ttneC ehlar Secterirata ta teh serddaig sleb nevwo. ISO/IE3002 C Athgir lls serevr.de selnUs towrehise specfidei, trap
12、 on fo thsi ilbupctanoi may cudorper ebtu ro dezilina ni dey fomr yb ro nam y,snae lecetrinoc m roceinahcla, icnliduntohp gcoiypom dna gnicrfoilm, wittuoh mrepissii non writif gnrmo ietI rehSta O tserdda ehs ebolw or ISOs memreb i ydobn the cnuotfo yr ttseuqer ehe.r ISO cirypothg fofice saCe tsopale
13、 65 eneG 1121-HC 02 av leT. 4 + 10 947 22 1 11 xaF0 947 22 14 + 9 74 E-mial coirypthgis.o gro We bwww.is.o groii ISO/IE 3002 C Allr ihgtsser edevrBSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) OSI /IEC 002- 3 All thgirer svresed Contents iii Contents Page Foreword. vi Introduction . vii 1 Scope. 1 2 No
14、rmative references 2 3 Terms and definitions, notations and conventions 3 3.1 Terms and definitions 3 3.1.1 Terms and definitions provided in ISO/IEC 13249-1:2002 . 3 3.1.2 Terms and definitions provided in this part of ISO/IEC 13249 3 3.1.3 Terms and definitions taken from ISO/IEC 9075-9:2001 4 3.1
15、.4 Terms and definitions taken from ISO/IEC 10918-1:1994 4 3.1.5 Terms and definitions taken from ISO/IEC 15444-1:2000 4 3.2 Notations. 4 3.2.1 Notations provided in ISO/IEC 13249-1:2002 4 3.2.2 Notations provided in this part of ISO/IEC 13249 . 4 3.3 Conventions 4 4 Concepts. 5 4.1 Introduction 5 4
16、.2 Concepts taken from ISO/IEC 9075-9:2001 6 4.3 Types representing still images . 6 4.3.1 Attributes of the SI_StillImage type . 6 4.3.2 Methods of the SI_StillImage type 6 4.4 Image features 7 4.4.1 Feature types 8 4.4.2 Assessing the similarity of images 8 4.5 Complementary SQL-invoked regular fu
17、nctions 9 4.6 Auxiliary type SI_Color 11 4.7 The Still Image Information Schema 11 5 Still Image Types 12 5.1 SI_StillImage Types and Routines . 12 5.1.1 SI_StillImage Type. 12 5.1.2 SI_StillImage Methods. 17 5.1.3 SI_setContent Method. 22 5.1.4 SI_changeFormat Method. 23 5.1.5 SI_Scale Methods. 24
18、5.1.6 SI_Resize Methods. 26 5.1.7 SI_Rotate Method. 28 5.1.8 SI_Thumbnail Methods 29 5.1.9 SI_InitFeatures method. 30 5.1.10 SI_ClearFeatures method 30 5.1.11 SI_Score Methods 31 5.1.12 Functions Complementing SI_StillImage Methods 33 5.1.13 SI_chgContent Function 35 5.1.14 SI_convertFormat Function
19、 35 5.1.15 SI_scaleImage Function 35 5.1.16 SI_zoomImage Function 36 5.1.17 SI_resizeImage Function. 36 5.1.18 SI_rotateImage Function. 37 5.1.19 SI_getThmbnl Function. 37 5.1.20 SI_getSizedThmbnl Function 37 5.1.21 SI_setImageFtrs Function. 38 BSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) iv Contents
20、 OSI /IEC 002- 3 All girhter svresed 5.1.22 SI_resetImageFtrs Function38 5.1.23 Functions Complementing Observer Functions of Type SI_StillImage .39 5.1.24 Functions not intended for Public Use 40 6 Feature Types.49 6.1 SI_AverageColor Type and Routines .49 6.1.1 SI_AverageColor Type.49 6.1.2 SI_Ave
21、rageColor Methods.50 6.1.3 SI_Score Method51 6.1.4 SI_findAvgClr Function.51 6.1.5 SI_mkAvgClr Function.52 6.1.6 SI_ScoreByAvgClr Function.52 6.2 SI_ColorHistogram Type and Routines .52 6.2.1 SI_ColorHistogram Type.52 6.2.2 SI_ColorHistogram Methods.54 6.2.3 SI_Append Method.56 6.2.4 SI_Score Method
22、57 6.2.5 SI_findClrHstgr Function.57 6.2.6 SI_mkClrHstgr Function58 6.2.7 SI_arrayClrHstgr Function.58 6.2.8 SI_appendClrHstgr Function.58 6.2.9 SI_ScoreByClrHstgr Function.59 6.3 SI_PositionalColor Type and Routines 59 6.3.1 SI_PositionalColor Type59 6.3.2 SI_PositionalColor Method60 6.3.3 SI_Score
23、 Method61 6.3.4 SI_findPstnlClr Function.62 6.3.5 SI_ScoreByPstnlClr Function.62 6.4 SI_Texture Type and Routines62 6.4.1 SI_Texture Type62 6.4.2 SI_Texture Method.63 6.4.3 SI_Score Method64 6.4.4 SI_findTexture Function65 6.4.5 SI_ScoreByTexture Function65 6.5 SI_FeatureList Type and Routines .65 6
24、.5.1 SI_FeatureList Type.65 6.5.2 SI_FeatureList Method.67 6.5.3 SI_setFeature Methods69 6.5.4 SI_Score Method71 6.5.5 SI_mkFtrList Function.73 6.5.6 SI_ScoreByFtrList Function73 6.5.7 Regular Functions Complementing SI_setFeature Methods.74 6.5.8 Regular Functions Complementing Observer Functions o
25、f type SI_FeatureList .75 6.6 Auxiliary Types and Routines.77 6.6.1 SI_Color Type.77 6.6.2 SI_RGBColor Method.77 6.6.3 SI_mkRGBClr Function78 7 SQL/MM Still Image Information Schema 80 7.1 Introduction.80 7.2 SI_FEATURES view80 7.3 SI_IMAGE_FORMATS view80 7.4 SI_IMAGE_FORMAT_CONVERSIONS view.80 7.5
26、SI_IMAGE_FORMAT_FEATURES view80 7.6 SI_THUMBNAIL_FORMATS view81 7.7 SI_VALUES view.81 7.8 Short name views.81 8 SQL/MM Still Image Definition Schema .82 8.1 Introduction.82 8.2 SI_FEATURES base table82 BSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) OSI /IEC 002- 3 All girhter svresed Contents v 8.3 SI_
27、IMAGE_FORMATS base table83 8.4 SI_IMAGE_FORMAT_CONVERSIONS base table . 84 8.5 SI_IMAGE_FORMAT_FEATURES base table 84 8.6 SI_THUMBNAIL_FORMATS base table 85 8.7 SI_VALUES base table. 85 9 Status Codes 87 10 Conformance 88 10.1 Requirements for conformance 88 10.2 Features of ISO/IEC 9075-9:2001 requ
28、ired in this part of ISO/IEC 13249 . 91 10.3 Claims of conformance. 92 Annex A (informative)93 A.1 Implementation-defined Meta-variables94 Annex B (informative). 95 B.1 Implementation-dependent Meta-variables.99 Index . 100 Tables Page Table 1 Method and function name correspondences. 9 Table 2 SQLS
29、TATE class and subclass values 87 BSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) vi Foreword OSI /IEC 002- 3 All girhter svresed Foreword ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission) form the specialized system for worldwide standardiz
30、ation. 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 mutu
31、al 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. International Standards are drafted in accordan
32、ce with the rules given in the ISO/IEC Directives, Part 2. The main task of the joint technical committee is to prepare International Standards. Draft International Standards adopted by the joint technical committee are circulated to national bodies for voting. Publication as an International Standa
33、rd 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 document may be the subject of patent rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights. ISO/IEC 13249-5
34、was prepared by Joint Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange. This second edition cancels and replaces the first edition (ISO/IEC 13249-5:2001), which has been technically revised. ISO/IEC 13249 consists of the following parts,
35、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 BSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) SII/OEC 2003 - All rithgs reserved Introduction vii Intro
36、duction 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 o
37、f 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) Cla
38、use 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 an
39、d 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“ defin
40、es 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
41、 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 implementer shall provide in each case. 12) Annex B, “Implementation
42、-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. BSISO/IEC132495:2003blank BSISO/IEC132495:2003INTENRATIONAL TSANDADR IS/OIE94231 C-5:3002(
43、E)OSI /IEC 002- 3 All girhter svresed Scope 1 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 (all parts); b) gives the references necessary for this part of
44、ISO/IEC 13249; c) defines notations and conventions specific to this part of ISO/IEC 13249; d) defines concepts specific to 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 of ISO/IEC 1324
45、9 adhere to the following. A still image user-defined type is generic to image handling. It addresses the need to store, manage and retrieve information based on aspects of inherent image characteristics such as height, width and format and based on image features such as average color, color histog
46、ram, positional color and texture. It also addresses the need to employ manipulation such as rotation, scaling, as well as similarity assessment. 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
47、 user-defined types are applicable to all different image formats. However, not all functionality can be used with all known still image formats. An implementation of this part of ISO/IEC 13249 may exist in environments that also support information and content management, decision support, data min
48、ing 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. BSISO/IEC132495:2003IS/OIE94231 C-5:3002(E) 2 Normative references OSI /IEC 002- 3 All girhter sv
49、resed 2 Normative references The following referenced documents are indispensable for the application of this document. For dated references, only the edition cited applies. For undated references, the latest edition of the referenced document (including any amendments) applies. ISO/IEC 9075-9:2001, Information technology Database languages SQL Part 9: Management of External Data (SQL/MED) ISO/IEC 13249
