Tiêu chuẩn quốc tế

Số hiệu

Standard Number

ANSI INCITS/ISO/IEC 9075-2:2008
Năm ban hành 2008

Publication date

Tình trạng A - Còn hiệu lực

Status

Tên tiếng Anh

Title in English

Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
Thay thế cho

Replace

ANSI INCITS/ISO/IEC 9075-2:2003
Số trang

Page

1
Giá:

Price

Liên hệ / Contact us
Phạm vi áp dụng

Scope of standard

This part of ISO/IEC 9075 defines the data structures and basic
operations on SQL-data. It provides functional capabilities for
creating, accessing, maintaining, controlling, and protecting
SQL-data.

This part of ISO/IEC 9075 specifies 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 embedded
SQL-statement has been replaced by one or more statements in the
host language, some of which invoke an SQL externally-invoked
procedure that, when executed, has an effect equivalent to
executing the SQL-statement.

- For direct invocation of SQL-statements.

- To support dynamic preparation and execution of
SQL-statements.

This part of ISO/IEC 9075 provides a vehicle for portability of
data definitions and compilation units between
SQL-implementations.

This part of ISO/IEC 9075 provides a vehicle for interconnection
of SQL-implementations. Implementations of this part of ISO/IEC
9075 may exist in environments that also support application
programming 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.