《07-30082648-DC.pdf》由会员分享,可在线阅读,更多相关《07-30082648-DC.pdf(293页珍藏版)》请在三一文库上搜索。
1、a Date: 13 February 2007 Origin: International Latest date for receipt of comments: 31 May 2007 Project no.: 2002/02676 Responsible committee: IST/40 Data management and interchange Interested committees: Title: Draft ISO/IEC 9075-11 Information technology - Database languages - SQL Part 11: Informa
2、tion and definition scemas (SQL/Schemata) Supersession information: If this document is published as a standard, the UK implementation of it will supersede NONE and partially supersede NONE . If you are aware of a current national standard which may be affected, please notify the secretary (contact
3、details below). WARNING: THIS IS A DRAFT AND MUST NOT BE REGARDED OR USED AS A BRITISH STANDARD. THIS DRAFT IS NOT CURRENT BEYOND 31 May 2007. This draft is issued to allow comments from interested parties; all comments will be given consideration prior to publication. No acknowledgement will normal
4、ly be sent. See overleaf for information on commenting. No copying is allowed, in any form, without prior written permission from BSI except as permitted under the Copyright, Designs and Patent Act 1988 or for circulation within a nominating organization for briefing purposes. Electronic circulation
5、 is limited to dissemination by e-mail within such an organization by committee members. Further copies of this draft may be purchased from BSI Customer Services, Tel: +44(0) 20 8996 9001 or email ordersbsi-. British, International and foreign standards are also available from BSI Customer Services.
6、 British Standards on CD or Online are available from British Standards Publishing Sales Limited. Tel: 01344 404409 or email bsonlinetechindex.co.uk. Information on the co-operating organizations represented on the committees referenced above may be obtained from the responsible committee secretary.
7、 Cross-references The British Standards which implement International or European publications referred to in this draft may be found via the British Standards Online Service on the BSI web site http:/www.bsi-. Direct tel: 020 8996 7411 Responsible Committee Secretary: Mr G H Williams (BSI) E-mail:
8、geoff.williamsbsi- Draft for Public Comment Head Office 389 Chiswick High Road London W4 4AL Telephone: +44(0)20 8996 9000 Fax: +44(0)20 8996 7001 Form 36 Version 6.1 DPC: 07/30082648 DC Licensed Copy: London South Bank University, London South Bank University, Thu Mar 01 08:28:17 GMT+00:00 2007, Un
9、controlled Copy, (c) BSI b Introduction This draft standard is based on international discussions in which the UK has taken an active part. Your comments on this draft are welcome and will assist in the preparation of the consequent standard. If no comments are received to the contrary, then the UK
10、will approve this draft. There is a high probability that this text could be adopted by CENELEC as a reference document for harmonization or as a European Standard. Recipients of this draft are requested to comment on the text bearing in mind this possibility. UK Vote Please indicate whether you con
11、sider the UK should submit a negative (with reasons) or positive vote on this draft. BSI Committee Responsibilities Whether or not the standard is published in its original (international) form, or as a formal British Standard Implementation, the BSI committees responsibilities are to: - aid enquire
12、rs to understand the text; - present to the responsible international committee any enquiries on interpretation, or proposals for change, and keep UK interests informed; - monitor related International and European developments and promulgate them in the UK. Submission The guidance given below is in
13、tended to ensure that all comments receive efficient and appropriate attention by the responsible BSI committee. Annotated drafts are not acceptable and will be rejected. All comments must be submitted, preferably electronically, to the Responsible Committee Secretary at the address given on the fro
14、nt cover. Comments should be compatible with Version 6.0 or Version 97 of Microsoft Word for Windows, if possible; otherwise comments in ASCII text format are acceptable. Any comments not submitted electronically should still adhere to these format requirements. All comments submitted should be pres
15、ented as given in the example below. Further information on submitting comments and how to obtain a blank electronic version of a comment form are available from the BSI web site at:http:/www.bsi- Template for comments and secretariat observations Date: xx/xx/200x Document: ISO/DIS xxxxx 1 2 (3) 4 5
16、 (6) (7) MB Clause No./ Subclause No./ Annex (e.g. 3.1) Paragraph/ Figure/Table/ Note (e.g. Table 1) Type of com- ment Comment (justification for change) by the MB Proposed change by the MB Secretariat observations on each comment submitted 3.1 Definition 1 ed Definition is ambiguous and needs clari
17、fying. Amend to read . so that the mains connector to which no connection . 6.4 Paragraph 2 te The use of the UV photometer as an alternative cannot be supported as serious problems have been encountered in its use in the UK. Delete reference to UV photometer. Microsoft and MS-DOS are registered tra
18、demarks, and Windows is a trademark of Microsoft Corporation. Licensed Copy: London South Bank University, London South Bank University, Thu Mar 01 08:28:17 GMT+00:00 2007, Uncontrolled Copy, (c) BSI Final Committee Draft ISO/IEC FCD 9075-11 Date: 2006-11-22 Reference number: ISO/JTC 1/SC 32N1531 Su
19、persedes document SC 32N1413 THIS DOCUMENT IS STILL UNDER STUDY AND SUBJECT TO CHANGE. IT SHOULD NOT BE USED FOR REFERENCE PURPOSES. ISO/IEC JTC 1/SC 32 Data Management and Interchange Secretariat: USA (ANSI) Circulated to P- and O-members, and to technical committees and organizations in liaison fo
20、r voting (P-members only) by: 2007-03-22 Please return all votes and comments in electronic form directly to the SC 32 Secretariat by the due date indicated. ISO/IEC FCD 9075-11:2006(E) Title: ISO/IEC FCD 9075-11 - Information technology -Database Languages - SQL - Part 11: Information and Definitio
21、n Schemas (SQL/Schemata) Project: 1.32.03.06.11.00 Introductory note: The attached document is hereby submitted for a four-month letter ballot to the National Bodies of ISO/IEC JTC 1/SC 32. The ballot starts 2006-11-22. Medium: E No. of pages: 291 Dr. Timothy Schoechle, Secretary, ISO/IEC JTC 1/SC 3
22、2 Farance Inc *, 3066 Sixth Street, Boulder, CO, United States of America Telephone: +1 303-443-5490; E-mail: TimothySchoechle.org available from the JTC 1/SC 32 WebSite http:/www.jtc1sc32.org/ *Farance Inc. administers the ISO/IEC JTC 1/SC 32 Secretariat on behalf of ANSI Licensed Copy: London Sout
23、h Bank University, London South Bank University, Thu Mar 01 08:28:17 GMT+00:00 2007, Uncontrolled Copy, (c) BSI ISO/IEC JTC 1/SC 32 Date: 2006-11-12 FCD 9075-11:200x(E) ISO/IEC JTC 1/SC 32/WG 3 The United States of American (ANSI) Information technology Database languages SQL Part 11: Information an
24、d Definition Schemas (SQL/Schemata) Technologies de linformation Langages de base de donnes SQL Partie 11: Information et Definition Schmas (SQL/Schemata) Document type: International Standard Document subtype: Final Committee Draft (FCD) Document stage: (3) FCD under Consideration Document language
25、: English Licensed Copy: London South Bank University, London South Bank University, Thu Mar 01 08:28:17 GMT+00:00 2007, Uncontrolled Copy, (c) BSI Copyright notice This ISO document is a working draft or a committee draft and is copyright-protected by ISO.While the reproduction of working drafts or
26、 committee drafts in any form for use by participants in the ISO standards development process is permitted without prior permission from ISO, neither this document nor any extract from it may be reproduced, stored or transmitted in any form for any other purpose without prior written permission fro
27、m ISO. Requests for permission to reproduce for the purpose of selling it should be addressed as shown below or to ISOs member body in the country of the requester. ANSI Customer Service Department 25 West 43rd Street, 4th Floor New York, NY 10036 Tele: 1-212-642-4980 Fax: 1-212-302-1286 Email: stor
28、emanageransi.org Web: www.ansi.org Reproduction for sales purposes may be subject to royalty payments or a licensing agreement. Violaters may be prosecuted. Licensed Copy: London South Bank University, London South Bank University, Thu Mar 01 08:28:17 GMT+00:00 2007, Uncontrolled Copy, (c) BSI Conte
29、ntsPage Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
30、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . x 1Scope. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 2Normative references. . . . . . . . . . . . . . .
31、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.1ISO and IEC standards. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 3Definitions, notations, a
32、nd conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 3.1Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4Concept
33、s. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 4.1Introduction to the Definition Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
34、 . . . . . . . . 7 4.2Introduction to the Information Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 5Information Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
35、 . . . . . . . . . . . . . . . . 9 5.1INFORMATION_SCHEMA Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 5.2INFORMATION_SCHEMA_CATALOG_NAME base table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
36、 5.3CARDINAL_NUMBER domain. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 5.4CHARACTER_DATA domain. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 5.5S
37、QL_IDENTIFIER domain. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 5.6TIME_STAMP domain. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
38、 . 14 5.7YES_OR_NO domain. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.8ADMINISTRABLE_ROLE_AUTHORIZATIONS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 5.9APPLICABL
39、E_ROLES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 5.10ASSERTIONS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5
40、.11ATTRIBUTES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 5.12CHARACTER_SETS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
41、. . . . 21 5.13CHECK_CONSTRAINT_ROUTINE_USAGE view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 5.14CHECK_CONSTRAINTS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 5.15COLLATIO
42、NS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 5.16COLLATION_CHARACTER_SET_APPLICABILITY view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 5.17COLUMN_COLUMN_USAGE view. .
43、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 5.18COLUMN_DOMAIN_USAGE view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 5.19COLUMN_PRIVILEGES view. . . . . . . . . . .
44、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 5.20COLUMN_UDT_USAGE view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 5.21COLUMNS view. . . . . . . . . . . . . . . . .
45、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 5.22CONSTRAINT_COLUMN_USAGE view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 5.23CONSTRAINT_TABLE_USAGE view. . . . . . . . . . .
46、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 5.24DATA_TYPE_PRIVILEGES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 ISO/IEC 2006 All rights reservedContents iii Licensed Copy: Lo
47、ndon South Bank University, London South Bank University, Thu Mar 01 08:28:17 GMT+00:00 2007, Uncontrolled Copy, (c) BSI 5.25DIRECT_SUPERTABLES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 5.26DIRECT_SUPERTYPES view. . .
48、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 5.27DOMAIN_CONSTRAINTS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41 5.28DOMAINS view. . . . . . . . .
49、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 5.29ELEMENT_TYPES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 5.30ENABLED_ROLES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 5.31FIE