ISO/IEC 19075-10-2024 PDF

ISO/IEC 19075-10-2024 PDF

Information technology-Guidance for the use of database language SQL-Part 10: SQL model (Guide/Model)

$145.50 $291.00 -50%
Product Code: ISO/IEC 19075-10
Stock In Stock
Edition: 1.
Published: 10/2024
Number of Pages: 74
File Size: 1 file, 1 Byte

Available Options

Product Description

Information technology — Guidance for the use of database language SQL — Part 10: SQL model (Guide/Model)

Introduction: This document describes the model of database language SQL, as defined primarily in ISO/IEC 9075-1 and ISO/IEC 9075-2. It supplies some background in the form of a brief history of the relational data model, plus a brief overview of some SQL features relevant to the SQL model. The SQL model, of course, existed from the initial definition of the language, but was not explicitly recognized until the language became sufficiently complex that appropriate vocabulary and definitions were required to accurately specify all capabilities required. This document summarizes the result of hundreds of hours of discussion and analysis that were required in order to create a coherent and useful definition of the SQL model of operation. This document briefly outlines the Relational model popularized by E.F. Codd. However, the fundamental structure and content of this document addresses SQL language facilities such as tables, column, relationships, and operations, not the Relational model itself. Since SQL’s adoption in 1986 as a database language standard, many extensions have been proposed, defined, reviewed, modified, and adopted by members of SQL-related standards committees across the world. While the SQL model herein addresses only a small subset of the SQL language’s data management facilities, SQL’s overall scope includes non-relational data types, object classes, multi-level data structures, and even DBMS-generated pointers to rows that appear as if they were user-based values. Suppo

Scope: This document describes the model of database language SQL as defined in ISO/IEC 9075-1, ISO/IEC 9075-2, and ISO/IEC 9075-11. The meanings of and the relationships between various concepts of that model are described in text and illustrated graphically. Background in the form of some historical review and a brief overview of key SQL features is included. NOTE 2 — In spite of the fact that the names of the ISO/IEC 9075 series of standards contain the phrase “database language”, the standards do not use the word “database” to describe the thing that SQL creates and on which it operates. The word “database” is used in many different contexts and has meanings wholly unrelated to the intent of the ISO/IEC 9075 series. Consequently, a variety of other terms are defined and used by the ISO/IEC 9075 series. The word “database” is frequently used in this document informally to mean “a collection of data managed by an SQL-implementation at any given time.” © ISO/IEC 2024 – All rights reserved

Be the first to write a review for this product.

Write a review

Note: HTML is not translated!
Bad           Good
ISO/IEC 19075-10-2024 PDF

ISO/IEC 19075-10-2024 PDF

$145.50 $291.00