|
US$874.00 · In stock
Delivery: <= 5 days. True-PDF full-copy in English will be manually translated and delivered via email.
GB/T 12991.1-2008: Information technology -- Database languages-SQL -- Part 1: framework
Status: Valid GB/T 12991.1: Evolution and historical versions
| Standard ID | Contents [version] | USD | STEP2 | [PDF] delivered in | Standard Title (Description) | Status | PDF |
| GB/T 12991.1-2008 | English | 874 |
Add to Cart
|
5 days [Need to translate]
|
Information technology -- Database languages-SQL -- Part 1: framework
| Valid |
GB/T 12991.1-2008
|
| GB/T 12991-1991 | English | RFQ |
ASK
|
7 days [Need to translate]
|
Information processing systems--Database language SQL with integrity enhancement
| Obsolete |
GB/T 12991-1991
|
PDF similar to GB/T 12991.1-2008
Basic data | Standard ID | GB/T 12991.1-2008 (GB/T12991.1-2008) | | Description (Translated English) | Information technology -- Database languages-SQL -- Part 1: framework | | Sector / Industry | National Standard (Recommended) | | Classification of Chinese Standard | L74 | | Classification of International Standard | 35.060 | | Word Count Estimation | 44,475 | | Date of Issue | 2008-07-16 | | Date of Implementation | 2008-12-01 | | Older Standard (superseded by this standard) | GB/T 12991-1991 | | Quoted Standard | GB/T 12991; GB/T 16262.1-2006; ISO/IEC 10646: 2003; ISO/IEC 14651: 2001 | | Adopted Standard | ISOIEC 9075-1-2003, IDT | | Regulation (derived from) | Announcement of Newly Approved National Standards No. 12 of 2008 (No. 125 overall) | | Issuing agency(ies) | General Administration of Quality Supervision, Inspection and Quarantine of the People's Republic of China, Standardization Administration of the People's Republic of China | | Summary | This standard provides a conceptual framework, provides SQL syntax and SQL statement to achieve the processing results. This section also defines the GB/T 12991 other parts of the terminology and notation used. | GB/T 12991.1-2008: Information technology -- Database languages-SQL -- Part 1: framework---This is a DRAFT version for illustration, not a final translation. Full copy of true-PDF in English version (including equations, symbols, images, flow-chart, tables, and figures etc.) will be manually/carefully translated upon your order.
. Information technology Database languages \u200b\u200bSQL Part 1. Framework
ICS 35.060
L74
National Standards of People's Republic of China
GB/T 12991.1-2008/ISO /IEC 9075-1.2003
Replacing GB/T 12991-1991
IT database language SQL
Part 1. Framework
(ISO /IEC 9075-1.2003, Informationtechnology-
Databaselanguages-SQL-Part 1. Framework (SQL/Framework), IDT)
Posted 2008-07-16
2008-12-01 implementation
Administration of Quality Supervision, Inspection and Quarantine of People's Republic of China
Standardization Administration of China released
Table of Contents
Introduction Ⅴ
Introduction Ⅵ
1 Scope 1
2 Normative references 1
Definitions and use of terms 1 3
3.1 Definitions 1
3.1.1 This standard provides definitions 1
3.2 Use of terms 3
3.3 3 suggestive content
4 Concepts 3
4.1 caveats 3
4.2 SQL environment and its components 4
4.2.1 SQL environment 4
4.2.2 SQL Agent 4
4.2.3 SQL achieve 4
4.2.4 SQL client module 4
4.2.5 user identifier 5
4.2.5a Roles 5
4.2.6 user mapping concepts 5
4.2.7 routine mapping concepts 5
4.2.8 directory and mode 5
4.2.9 external server and descriptors 6
4.2.10 external data wrappers and descriptors 6
4.2.11 SQL data 6
4.3 Table 6
4.4 SQL data type 6
4.4.1 General data type information 6
4.4.2 null 7
4.4.3 Predefined Type 7
4.4.4 atomic structure type 8
4.4.5 construct composite type 8
Operation 4.5 on 8 places and spaces
4.5.1 place 8
4.5.2 Assignment 8
4.5.3 Nullability 8
4.6 SQL schema objects 8
4.6.1 General SQL schema object information 8
4.6.2 associated with the character set descriptor 9
GB/T 12991.1-2008/ISO /IEC 9075-1.2003
4.6.3 domain and its components 9
4.6.4 User-defined types 10
4.6.5 10 distinct types
4.6.6 and composition of the base table 10
4.6.7 view definition 11
4.6.8 Assertion 11
4.6.9 SQL Server Module 11
4.6.10 mode routine 11
4.6.11 sequence generator 11
4.6.12 privilege 11
4.7 integrity constraints and constraint checking 11
4.7.1 Check constraint 11
4.7.2 uncertainties and constraints 12
Communication between 4.8 SQL Server Agent and SQL 12
12 4.8.1 host language
4.8.2 parameter passing and data corresponding to the type of 12
4.8.3 descriptor area 13
13 4.8.4 Diagnostic information
4.8.5 SQL transaction 13
4.9 module 14
4.10 routine 14
General information 14 4.10.1 Routine
4.10.2 type function 14 Reserved
4.11 SQL statements 14
4.11.1 SQL statements classified 14
4.11.2 SQL statements classified by function 15
5 GB/T 12991 Description of each of the 15
5.1 Overview 15
5.2 GB/T 12991.1. frame 15
5.3 GB/T 12991.2. base 16
5.3.1 GB/T 12991.2 specified data type 16
5.3.2 Table 16
5.3.3 Binding Method 16
5.3.4 GB/T 12991.2 specified in SQL statements 16
5.4 GB/T 12991.3. 17 Call Level Interface
5.5 GB/T 12991.4. Persistent Stored Modules 17
SQL statements 5.5.1 GB/T 12991.4 specified in 17
5.6 GB/T 12991.9. External Data Management 17
5.7 GB/T 12991.10. Object Language Bindings 18
5.8 GB/T 12991.11. Information and Custom mode 18
5.9 GB/T 12991.13. SQL routines and types using the Java programming language 18
5.10 GB/T 12991.14. XML-related specifications 18
6 GB/T 12991 in the parts other notations and conventions used in 18
GB/T 12991.1-2008/ISO /IEC 9075-1.2003
6.1 taken from ISO /IEC 10646 in the notation 18
6.2 standard notation used in 18
6.3 Conventions 19
6.3.1 Syntax Element 19
6.3.2 Description information mode and Custom mode 20
6.3.3 Use of terms 20
6.3.4 Descriptor 23
Relations 6.3.5 GB/T 12991 in various parts of the 23
Terms 6.3.5a used as a subroutine 26
6.3.6 Index typesetting format 26
6.3.7 Characteristics and features 26-ID
6.4 database language SQL object identifier 27
Appendix 7 GB/T 12991 in various parts of the 28
28 7.1 Implementation-defined elements
7.2 implementation elements associated 28
7.3 deprecated features 28
7.4 incompatibilities with previous versions 28
8 Compliance 28
8.1 Minimum Compliance 28
8.2 Compliance section 28
Compliance 8.3 features 28
Compliance 8.4 SQL package 29
8.4.1 Enhanced datetime facilities 29
8.4.2 Enhanced Integrity Management 29
8.4.3 PSM 30
8.4.4 Basic objects support 30
8.4.5 Enhanced Object Support 30
8.4.6 Active Database 30
8.4.7 OLAP 30
8.4.8 Extensions and options 30
8.5 SQL tag 31
8.6 Declaration of Conformity 32
8.6.1 Requirements for SQL applications 32
8.6.2 SQL implementation of the requirements of 32
Appendix A (Informative Appendix) SQL international standards of maintenance and interpretation 33
Annex B (informative) Implementation-defined elements 34
Annex C (informative) implementation-dependent element 35
Appendix NA (Informative Appendix) GB/T 12991 standard development process 36
References 37
GB/T 12991.1-2008/ISO /IEC 9075-1.2003
Foreword
GB/T 12991 in the "Information Technology Database Language SQL" general heading is divided into nine sections.
--- Part 1. Framework;
--- Part 2. Basic;
--- Part 3. Call Level Interface;
--- Part 4. Persistent Stored Modules;
--- Part 9. Management of External Data;
--- Part 10. Object Language Bindings;
--- Part 11. Information and Custom mode;
Part --- Article 13. SQL routines and types using the Java programming language;
--- Part 14. related specifications and XML.
e) Chapter 5, "GB/T 12991 in the Description of each", according to the concept of Chapter 4, "concept" described summarized GB/T 12991
The basic contents of each section.
f) Chapter 6, "GB/T 12991 in all other parts used in the notation and conventions," the definition of GB/T 12991 for use in other parts of the
Notation and conventions.
g) Chapter 7, "Appendix GB/T 12991 in various parts of", GB/T 12991 in other parts of the appendix related description.
h) Chapter 8, "Compliance", description of GB/T 12991 in whole or in part to meet the compliance requirements to be attained.
i) Appendix A "SQL maintenance of international standards and interpretations," are informative appendices. This appendix describes the maintenance and interpretation of ISO /
IEC 9075 standard formal procedures.
j) Appendix B "implementation-defined elements", are informative appendices. This appendix lists the syntax GB/T 12991 in this section,
Meaning, returning a result, the impact on SQL data and/or models, or any other act is partially or completely implementation-defined
Those features.
k) Appendix C "implementation-dependent element," are informative appendices. This appendix lists the syntax GB/T 12991 in this section,
Meaning, returning a result, the impact on SQL data and/or models, or any other act is partially or completely implementation-dependent
Those features.
l) Appendix NA "GB/T 12991 standard development process" is a data appendix. The appendix lists the GB/T 12991 development calendar
Cheng and various differences between versions.
m) Reference describes some of the Unicode Standard and related links.
GB/T 12991.1-2008/ISO /IEC 9075-1.2003
IT database language SQL
Part 1. Framework
1 Scope
GB/T 12991 This section describes the GB/T 12991 other part of the conceptual framework used in the provisions of the SQL syntax and
Results SQL implementation process statement.
This section also defines the GB/T 12991 Other terms and notation partially used.
2 Normative references
The following documents contain provisions which, through reference GB/T 12991 in this section constitute provisions of this section. For dated references,
All subsequent amendments (excluding corrections) or revisions do not apply to this section, however, encourage an agreement under this section
Parties to study the latest versions of these documents. For undated reference documents, the latest versions apply to this section.
GB/T 12991 all parts of the (ISO /IEC 9075.2003, IDT)
GB/T 16262.1-2006 Information technology - Abstract Syntax Notation One (ASN.1) - Part 1. Specification of basic notation (ISO /
IEC 8824-1.2002, IDT)
ISO /IEC 10646.2003 Information technology - Universal Multiple-Octet Coded Character Set (UCS)
ISO /IEC 14651.2001 Information technology - International string ordering and comparison compare strings and description of the common template tailorable
Sorting method
3 Definitions and use of terms
3.1 Definitions
3.1.1 The definitions provided in the standard
The following definitions apply GB /this part and other parts of the T 12991.
3.1.1.1
Can not be further divided.
3.1.1.2
Some may be of one or more subprograms executable code.
3.1.1.3
Set of values \u200b\u200bthat can be represented.
3.1.1.4
Coded representation of SQL objects. It includes a SQL all the information required to achieve compliance with the object.
3.1.1.5
All optional part with explicit instructions.
Note 1. For the fully qualified name uniquely identifies an object is not necessarily required. For example, although the directory name, the schema name and specific name composed entirely limit
Given name uniquely identifies a specific routine, but it does not have to be a fully qualified name of the routine.
GB/T 12991.1-2008/ISO /IEC 9075-1.2003
Tips & Frequently Asked Questions:Question 1: How long will the true-PDF of GB/T 12991.1-2008_English be delivered?Answer: Upon your order, we will start to translate GB/T 12991.1-2008_English as soon as possible, and keep you informed of the progress. The lead time is typically 3 ~ 5 working days. The lengthier the document the longer the lead time. Question 2: Can I share the purchased PDF of GB/T 12991.1-2008_English with my colleagues?Answer: Yes. The purchased PDF of GB/T 12991.1-2008_English will be deemed to be sold to your employer/organization who actually pays for it, including your colleagues and your employer's intranet. Question 3: Does the price include tax/VAT?Answer: Yes. Our tax invoice, downloaded/delivered in 9 seconds, includes all tax/VAT and complies with 100+ countries' tax regulations (tax exempted in 100+ countries) -- See Avoidance of Double Taxation Agreements (DTAs): List of DTAs signed between Singapore and 100+ countriesQuestion 4: Do you accept my currency other than USD?Answer: Yes. If you need your currency to be printed on the invoice, please write an email to [email protected]. In 2 working-hours, we will create a special link for you to pay in any currencies. Otherwise, follow the normal steps: Add to Cart -- Checkout -- Select your currency to pay. Question 5: Should I purchase the latest version GB/T 12991.1-2008?Answer: Yes. Unless special scenarios such as technical constraints or academic study, you should always prioritize to purchase the latest version GB/T 12991.1-2008 even if the enforcement date is in future. Complying with the latest version means that, by default, it also complies with all the earlier versions, technically.
|