ISO/IEC 9075-2:2016 信息技术 数据库语言 SQL 第2部分：基本原则（SQL/基本原则）
标准编号：ISO/IEC 9075-2:2016
中文名称：信息技术 数据库语言 SQL 第2部分：基本原则（SQL/基本原则）
英文名称：Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
发布日期：2016-12
标准范围
ISO/IEC 9075-2:2016规定了SQL数据的数据结构和基本操作。它提供了创建、访问、维护、控制和保护SQL数据的功能。ISO/IEC 9075-2:2016规定了数据库语言的语法和语义:-用于指定和修改SQL数据的结构和完整性约束。-用于声明和调用SQL数据和游标上的操作。-用于声明数据库语言过程。-用于在编译单元中嵌入SQL语句，而编译单元是用特定的编程语言（宿主语言）编写的。-用于派生宿主语言中的等效编译单元。在该等效编译单元中，每一个调用外部调用的SQL过程的程序在执行时，其效果相当于执行SQL语句的exe。-用于直接调用SQL语句。-支持SQL语句的动态准备和执行。ISO/IEC 9075-2:2016为SQL实现之间的数据定义和编译单元的可移植性提供了一种工具。ISO/IEC 9075-2:2016提供了SQL实现互连的工具。本ISO/IEC 9075的实施-2:2016可以存在于支持应用程序语言、最终用户查询语言、报表生成器系统、数据字典系统、程序库系统和分布式通信系统的环境中，以及用于数据库设计、数据管理和性能优化的各种工具中。
ISO/IEC 9075-2:2016 de？nes the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.ISO/IEC 9075-2:2016 speci？es the syntax and semantics of a database language:- For specifying and modifying the structure and the integrity constraints of SQL-data.- For declaring and invoking operations on SQL-data and cursors.- For declaring database language procedures.- For embedding SQL-statements in a compilation unit that is otherwise written in a particular programming language (host language).- For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to exe-cuting the SQL-statement.- For direct invocation of SQL-statements.- To support dynamic preparation and execution of SQL-statements.ISO/IEC 9075-2:2016 provides a vehicle for portability of data de？nitions and compilation units between SQL-implementations.ISO/IEC 9075-2:2016 provides a vehicle for interconnection of SQL-implementations.Implementations of this ISO/IEC 9075-2:2016 can exist in environments that also support application program-ming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and performance optimization.
标准预览图
