BS ISO IEC 13249-1-2016 Information technology Database languages SQL multimedia and application packages Framework《信息技术 数据库语言 结构化查询语言(SQL)多媒体和应用软件包 框架》.pdf

1、BS ISO/IEC 13249-1:2016 Information technology Database languages SQL multimedia and application packages Part 1: Framework BSI Standards Publication WB11885_BSI_StandardCovs_2013_AW.indd 1 15/05/2013 15:06BS ISO/IEC 13249-1:2016 BRITISH STANDARD National foreword This British Standard is the UK imp

2、lementation of ISO/IEC 13249-1:2016. It supersedes BS ISO/IEC 13249-1:2007 which is withdrawn. The UK participation in its preparation was entrusted to Technical Committee IST/40, Data management and interchange. A list of organizations represented on this committee can be obtained on request to its

3、 secretary. This publication does not purport to include all the necessary provisions of a contract. Users are responsible for its correct application. The British Standards Institution 2016. Published by BSI Standards Limited 2016 ISBN 978 0 580 87373 7 ICS 35.060 Compliance with a British Standard

4、 cannot confer immunity from legal obligations. This British Standard was published under the authority of the Standards Policy and Strategy Committee on 30 June 2016. Amendments/corrigenda issued since publication Date T e x t a f f e c t e dBS ISO/IEC 13249-1:2016 Information technology Database l

5、anguages SQL multimedia and application packages Part 1: Framework Technologies de linformation Langages de bases de donnes Multimdia SQL et paquetages dapplication Partie 1: Cadre gnral INTERNATIONAL STANDARD ISO/IEC 13249-1 Reference number ISO/IEC 13249-1:2016(E) Fourth edition 2016-06-01 ISO/IEC

6、 2016 BS ISO/IEC 13249-1:2016ii ISO/IEC 2016 All rights reserved COPYRIGHT PROTECTED DOCUMENT 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 mechani

7、cal, 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 ISOs member body in the country of the requester. ISO copyright office Ch. de Blandonnet 8 CP 401 CH-1214 Vernier, Geneva, Swi

8、tzerland Tel. +41 22 749 01 11 Fax +41 22 749 09 47 copyrightiso.org www.iso.org ISO/IEC 13249-1:2016(E)BS ISO/IEC 13249-1:2016ISO/IEC 13249-1:2016(E)Foreword iv Introduction v 1 Scope . 1 2 Normative references 1 3 T erms and definitions . 1 3.1 Terms defined in ISO/IEC 9075-1 1 3.2 Terms defined i

9、n 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

10、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 an

11、d 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 Paramet

12、er 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 routine

13、s .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 procedure

14、s 14 ISO/IEC 2016 All rights reserved iii Contents PageBS ISO/IEC 13249-1:2016ISO/IEC 13249-1:2016(E) Foreword ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission) form the specialized system for worldwide standardization. National bodies t

15、hat 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 inter

16、national 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

17、 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/directiv

18、es). 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 i

19、n 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

20、related to conformity assessment, as well as information about ISOs 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 m

21、anagement 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:

22、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 reservedBS ISO/IEC 132

23、49-1:2016ISO/IEC 13249-1:2016(E) 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, Infor

24、mation 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 par

25、t 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 con

26、ventions 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 mainte

27、nance and interpretation of ISO/IEC 13249. ISO/IEC 2016 All rights reserved vBS ISO/IEC 13249-1:2016BS ISO/IEC 13249-1:2016Information 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

28、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 con

29、ventions 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

30、 following documents, in whole or in part, are normatively referenced in this document and are indispensable for its application. For dated references, only the edition cited applies. For undated references, the latest edition of the referenced document (including any amendments) applies. ISO/IEC 90

31、75-1, Information technology Database languages SQL Part 1: Framework (SQL/Framework) ISO/IEC 9075-2, Information technology Database languages SQL Part 2: Foundation (SQL/Foundation) ISO/IEC 9075-11, Information technology Database languages SQL Part 11: Information and definition schemas (SQL/Sche

32、mata) 3 T erms a nd definiti ons 3.1 T erms defined in ISO/IE C 9075-1 For the purposes of this document, the following terms defined in ISO/IEC 9075-1 apply. a) compilation unit b) data type c) descriptor d) identifier e) implementation-defined f) implementation-dependent g) instance (of a value) h

33、) null value INTERNATIONAL ST ANDARD ISO/IEC 13249-1:2016(E) ISO/IEC 2016 All rights reserved 1BS ISO/IEC 13249-1:2016ISO/IEC 13249-1:2016(E) i) row j) sequence k) SQL-environment l) SQL-implementation m) SQL-statement n) table 3.2 T erms defined in ISO/IE C 9075-2 For the purposes of this document,

34、 the following terms defined in ISO/IEC 9075-2 apply. a) assignment b) attribute c) cardinality d) constructor function e) declared type f) external routine g) mutator function h) observer function i) signature (of an SQL-invoked routine) j) SQL routine k) SQL-invoked routine l) subtype m) supertype

35、 n) type-preserving function o) user-defined type p) white space 3.3 T erms defined in t his part of ISO/IE C 1324 9 For the purposes of this document, the following terms and definitions apply. 3.3.1 generic data type kind of data not already defined in any part of ISO/IEC 9075 that is used in a wi

36、der context than a single enterprise and for which there are advantages in standardizing the way it is represented 3.3.2 common table structure set of a table name and a sequence of a column name and data type pairs of columns consisting of an SQL table that is used in a wider context than a single

37、enterprise and for which there are advantages in standardizing the way it is represented2 ISO/IEC 2016 All rights reservedBS ISO/IEC 13249-1:2016ISO/IEC 13249-1:2016(E) 3.3.3 meta-variable variable which is used to define implementation-dependent or implementation-defined constants 3.3.4 method spec

38、ific implementation of an action or transformation that a user-defined type performs or a representation of values of that type is subject to Note 1 to entry: With such user-defined methods for structured types, an SQL-implementation allows users to extend the function of the database system in obje

39、ct-oriented manner. 4 Concepts 4.1 Concepts taken from parts of ISO/IEC 9075 The following concepts defined in parts of ISO/IEC 9075 are used either in this part of ISO/IEC 13249 or in other parts of ISO/IEC 13249. a) array b) base table c) catalog d) character set e) column f) completion condition

40、g) definition schema h) distinct type i) exception condition j) False k) field l) host language m) information schema n) maximal supertype o) ordering function p) predefined data type q) privilege r) source type s) SQL-agent t) SQL-data u) SQL-invoked method NOTE Throughout ISO/IEC 13249, the method

41、 is referred to SQL-invoked method. ISO/IEC 2016 All rights reserved 3BS ISO/IEC 13249-1:2016ISO/IEC 13249-1:2016(E) v) structured type w) subtype family x) transform function y) True z) Unknown aa) user-defined cast bb) view 4.2 Generic kinds of data and common table structures All parts of ISO/IEC

42、 9075 define the Database Language SQL, which is a language used to define and manipulate SQL-data. For the purposes of this part of ISO/IEC 13249, the SQL-data in an SQL- environment is referred to as an SQL database. Using the data definition facilities of parts of ISO/IEC 9075, an enterprise may

43、develop an SQL database based on the kinds of data chosen for some specific purpose determined by the particular requirements of the enterprise. Many kinds of data are used in a wider context than that of an individual enterprise, in which case there are benefits in being able to use a generic speci

44、fication for the definition and manipulation of these kinds of data. These benefits include the enabling of the following: a) shared understanding of this data; b) exchange of this data; c) provision of common manipulation facilities to process this data. Recognition of these benefits has resulted i

45、n publicly available specifications for generic data types and common table structures in the subject areas referred to in Clause 1 of each part of ISO/IEC 13249. Many enterprises have requirements to use such generic data types combined with their own enterprise-specific data types and their own en

46、terprise-specific tables with such common structures in an SQL database. These requirements include the manipulation of component elements of a generic data type and of a table with a common structure, enabling both the construction and recording of user-defined types and of rows of tables within an

47、 SQL database, and the use of these components in selection and retrieval of data from an SQL database. ISO/IEC 13249 addresses these requirements. 4.3 Use of parts of ISO/IEC 9075 4.3.1 User-defined types and r outines Parts of ISO/IEC 9075 include facilities for defining user-defined types. A user

48、-defined type can be either a distinct type or a structured type. A distinct type is based on some predefined data type. A structured type has attributes specified as either SQL data types or other user-defined types. A structured type may be defined as a subtype of another structured type, with inh

49、eritance of its attributes. A user- defined type may be specified as the data type of a column of an SQL table. A user-defined type can only be manipulated by associated routines. An attribute has automatically an associated observer and mutator function to retrieve and change its value. Further routines may be defined in which the body of the routine, being the component that 4 ISO/IEC 2016 All rights reserved