1、 Reference numberISO/IEC 13249-5:2003(E)ISO/IEC 2003Information technology Database 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 National Standard of Canada
2、CAN/CSA-ISO/IEC 13249-5:04(ISO/IEC 13249-5:2003)International Standard ISO/IEC 13249-5:2003 (second edition, 2003-11-01) has been adopted withoutmodification (IDT) as CSA Standard CAN/CSA-ISO/IEC 13249-5:04, which has been approved as a NationalStandard of Canada by the Standards Council of Canada.I
3、SBN 1-55397-810-2 December 2004The Canadian Standards Association (CSA), under whose auspices this National Standard has been produced, was chartered in 1919 and accredited by the Standards Council of Canada to the National Standards system in 1973. It is a not-for-profit, nonstatutory, voluntary me
4、mbership association engaged in standards development and certification activities. CSA standards reflect a national consensus of producers and users including manufacturers, consumers, retailers, unions and professional organizations, and governmental agencies. The standards are used widely by indu
5、stry and commerce and often adopted by municipal, provincial, and federal governments in their regulations, particularly in the fields of health, safety, building and construction, and the environment. Individuals, companies, and associations across Canada indicate their support for CSAs standards d
6、evelopment by volunteering their time and skills to CSA Committee work and supporting the Associations objectives through sustaining memberships. The more than 7000 committee volunteers and the 2000 sustaining memberships together form CSAs total membership from which its Directors are chosen. Susta
7、ining memberships represent a major source of income for CSAs standards development activities. The Association offers certification and testing services in support of and as an extension to its standards development activities. To ensure the integrity of its certification process, the Association r
8、egularly and continually audits and inspects products that bear the CSA Mark. In addition to its head office and laboratory complex in Toronto, CSA has regional branch offices in major centres across Canada and inspection and testing agencies in eight countries. Since 1919, the Association has devel
9、oped the necessary expertise to meet its corporate mission: CSA is an independent service organization whose mission is to provide an open and effective forum for activities facilitating the exchange of goods and services through the use of standards, certification and related services to meet natio
10、nal and international needs.For further information on CSA services, write toCanadian Standards Association5060 Spectrum Way, Suite 100Mississauga, Ontario, L4W 5N6CanadaThe Standards Council of Canada is the coordinating body of the National Standards system, a federation of independent, autonomous
11、 organizations working towards the further development and improvement of voluntary standardization in the national interest. The principal objects of the Council are to foster and promote voluntary standardization as a means of advancing the national economy, benefiting the health, safety, and welf
12、are of the public, assisting and protecting the consumer, facilitating domestic and international trade, and furthering international cooperation in the field of standards. A National Standard of Canada is a standard which has been approved by the Standards Council of Canada and one which reflects a
13、 reasonable agreement among the views of a number of capable individuals whose collective interests provide to the greatest practicable extent a balance of representation of producers, users, consumers, and others with relevant interests, as may be appropriate to the subject in hand. It normally is
14、a standard which is capable of making a significant and timely contribution to the national interest. Approval of a standard as a National Standard of Canada indicates that a standard conforms to the criteria and procedures established by the Standards Council of Canada. Approval does not refer to t
15、he technical content of the standard; this remains the continuing responsibility of the accredited standards development organization. Those who have a need to apply standards are encouraged to use National Standards of Canada whenever practicable. These standards are subject to periodic review; the
16、refore, users are cautioned to obtain the latest edition from the organization preparing the standard.The responsibility for approving National Standards of Canada rests with theStandards Council of Canada270 Albert Street, Suite 200Ottawa, Ontario, K1P 6N7CanadaAlthough the intended primary applica
17、tion of this Standard is stated in its Scope, it is importantto note that it remains the responsibility of the users to judge its suitability for their particular purpose.Registered trade-mark of Canadian Standards AssociationCAN/CSA-ISO/IEC 13249-5:04Information technology Database languages SQLmul
18、timedia and application packages Part 5: Still imageDecember 2004 Canadian Standards Association CSA/1CAN/CSA-ISO/IEC 13249-5:04Information technology Database languages SQL multimedia and application packages Part 5: Still imageCSA PrefaceStandards development within the Information Technology sect
19、or is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT, Canadians serve as the Canadian Advisory Committee (CAC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada
20、 (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T).This Standard supersedes CAN/CSA-ISO
21、/IEC 13249-5:02 (adoption of ISO/IEC 13249-5:2001).This International Standard was reviewed by the CSA TCIT under the jurisdiction of the Strategic Steering Committee on Information Technology and deemed acceptable for use in Canada. (A committee membership list is available on request from the CSA
22、Project Manager.) From time to time, ISO/IEC may publish addenda, corrigenda, etc. The CSA TCIT will review these documents for approval and publication. For a listing, refer to the CSA Information Products catalogue or CSA Info Update or contact a CSA Sales representative. This Standard has been fo
23、rmally approved as a National Standard of Canada by the Standards Council of Canada.December 2004 Canadian Standards Association 2004All rights reserved. No part of this publication may be reproduced in any form whatsoever without the prior permission ofthe publisher. ISO/IEC material is reprinted w
24、ith permission. Where the words “this International Standard” appear in the text, they should be interpreted as “this National Standard of Canada”.Inquiries regarding this National Standard of Canada should be addressed toCanadian Standards Association5060 Spectrum Way, Suite 100, Mississauga, Ontar
25、io, Canada L4W 5N61-800-463-6727 416-747-4044www.csa.caReference numberISO/IEC 13249-5:2003(E)ISO/IEC 2003INTERNATIONAL STANDARD ISO/IEC13249-5Second edition2003-11-01Information technology Database languages SQL multimedia and application packages Part 5: Still image Technologies de linformation La
26、ngages de bases de donnes Multimdia SQL et paquetages dapplication Partie 5: Image fixe ISO/IEC 13249-5:2003(E) PDF disclaimer This PDF file may contain embedded typefaces. In accordance with Adobes licensing policy, this file may be printed or viewed but shall not be edited unless the typefaces whi
27、ch 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 Adobes licensing policy. The ISO Central Secretariat accepts no liability in this area. Adobe is a trademark of Adobe Systems In
28、corporated. 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
29、that a problem relating to it is found, please inform the Central Secretariat at the address given below. ISO/IEC 2003 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 photocopy
30、ing and microfilm, without permission in writing from either ISO at the address below or ISOs 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 copyrightiso.org Web www.iso.org ii ISO/IEC 2003 All r
31、ights reservedISO/IEC 13249-5:2003(E) ISO/IEC 2003 - All rights reserved Contents iii Contents Page Foreword. vi Introduction . vii 1 Scope. 1 2 Normative 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 132
32、49-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.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
33、 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.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
34、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 functions 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
35、 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 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
36、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 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 S
37、I_getThmbnl Function . 37 5.1.20 SI_getSizedThmbnl Function 37 5.1.21 SI_setImageFtrs Function . 38 ISO/IEC 13249-5:2003(E) iv Contents ISO/IEC 2003 - All rights reserved 5.1.22 SI_resetImageFtrs Function38 5.1.23 Functions Complementing Observer Functions of Type SI_StillImage .39 5.1.24 Functions
38、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_AverageColor Methods.50 6.1.3 SI_Score Method 51 6.1.4 SI_findAvgClr Function .51 6.1.5 SI_mkAvgClr Function.52 6.1.6 SI_ScoreByAvgClr Function .52 6.2 SI_ColorHistogr
39、am 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 57 6.2.5 SI_findClrHstgr Function.57 6.2.6 SI_mkClrHstgr Function 58 6.2.7 SI_arrayClrHstgr Function.58 6.2.8 SI_appendClrHstgr Function.58 6.2.9 SI_ScoreByClr
40、Hstgr 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 Method 61 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_Textur
41、e Method .63 6.4.3 SI_Score Method 64 6.4.4 SI_findTexture Function 65 6.4.5 SI_ScoreByTexture Function 65 6.5 SI_FeatureList Type and Routines .65 6.5.1 SI_FeatureList Type .65 6.5.2 SI_FeatureList Method.67 6.5.3 SI_setFeature Methods69 6.5.4 SI_Score Method 71 6.5.5 SI_mkFtrList Function .73 6.5.
42、6 SI_ScoreByFtrList Function73 6.5.7 Regular Functions Complementing SI_setFeature Methods.74 6.5.8 Regular Functions Complementing Observer Functions of 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
43、/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 SI_IMAGE_FORMAT_FEATURES view 80 7.6 SI_THUMBNAIL_FORMATS view81 7.7 SI_VALUES view.81 7.8 Short name views.81 8 SQL/MM Still Image Definition Sch
44、ema .82 8.1 Introduction.82 8.2 SI_FEATURES base table82 ISO/IEC 13249-5:2003(E) ISO/IEC 2003 - All rights reserved Contents v 8.3 SI_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_VA
45、LUES 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 required in this part of ISO/IEC 13249 . 91 10.3 Claims of conformance . 92 Annex A (informative)93 A.1 Implementation-defined Meta-variables 94 Annex B (informative). 95
46、 B.1 Implementation-dependent Meta-variables . 99 Index . 100 Tables Page Table 1 Method and function name correspondences. 9 Table 2 SQLSTATE class and subclass values 87 ISO/IEC 13249-5:2003(E) vi Foreword ISO/IEC 2003 - All rights reserved Foreword ISO (the International Organization for Standard
47、ization) 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
48、 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
49、 and IEC have established a joint technical committee, ISO/IEC JTC 1. International Standards are drafted in accordance 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 Standard requires approval by at least 75 % of the national bodies casting a vote. Attention is drawn t
