ISO/IEC TR 19075-9:2020 情報技術データベース言語—データベース言語SQLの使用に関するガイダンス—パート9：オンライン分析処理（OLAP）機能 | ページ 2

Foreword

ISO (the International Organization for Standardization) and IEC (the International Electrotechnical Commission) form the specialized system for worldwide standardization. National bodies that are members of ISO or IEC participate in the development of International Standards through technical committees established by the respective organization to deal with particular fields of technical activity. ISO and IEC technical committees collaborate in fields of mutual interest. Other international organizations, governmental and non-governmental, in liaison with ISO and IEC, also take part in the work.

The procedures used to develop this document and those intended for its further maintenance are described in the ISO/IEC Directives, 1. In particular, the different approval criteria needed for the different types of document should be noted. This document was drafted in accordance with the editorial rules of the ISO/IEC Directives, 2 (see www.iso.org/directives ).

Attention is drawn to the possibility that some of the elements of this document may be the subject of patent rights. ISO and IEC shall not be held responsible for identifying any or all such patent rights. Details of any patent rights identified during the development of the document will be in the Introduction and/or on the ISO list of patent declarations received (see www.iso.org/patents ), or the IEC list of patent declarations received (see http://patents.iec.ch ).

Any trade name used in this document is information given for the convenience of users and does not constitute an endorsement.

For an explanation of the voluntary nature of standards, the meaning of ISO specific terms and expressions related to conformity assessment, as well as information about ISO's adherence to the World Trade Organization (WTO) principles in the Technical Barriers to Trade (TBT) see www.iso.org/iso/foreword.html .

This document was prepared by Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.

This document is intended to be used in conjunction with the following editions of the parts of ISO/IEC 9075:

• ISO/IEC 9075-1, sixth edition or later
• ISO/IEC 9075-2, sixth edition or later
• ISO/IEC 9075-3, sixth edition or later
• ISO/IEC 9075-4, seventh edition or later
• ISO/IEC 9075-9, fifth edition or later
• ISO/IEC 9075-10, fifth edition or later
• ISO/IEC 9075-11, fifth edition or later
• ISO/IEC 9075-13, fifth edition or later
• ISO/IEC 9075-14, sixth edition or later
• ISO/IEC 9075-15, second edition or later
• ISO/IEC 9075-16, first edition or later

A list of all parts in the ISO/IEC 19075 series can be found on the ISO website.

Introduction

This document discusses the syntax and semantics for including online analytic processing (OLAP) capabilities in SQL, as defined in ISO/IEC 9075-2.

The organization of this document is as follows:

• 1) Clause 1, “Scope”, specifies the scope of this document.
• 2) Clause 2, “Normative references”, identifies standards that are referenced as part of requirements by this document.
• 3) Clause 3, “Terms and definitions”, defines the terms and definitions used in this document.
• 4) Clause 5, “Windows”, discusses Feature T611, “Elementary OLAP operations” and Feature T612, “Advanced OLAP operations”, introducing the concept of a window in an SQL query.
• 5) Clause 6, “Window functions”, further discusses Feature T611, “Elementary OLAP operations” and Feature T612, “Advanced OLAP operations”, as well as Feature T614, “NTILE function”, Feature T615, “LEAD and LAG functions”, Feature T616, “Null treatment option for LEAD and LAG functions”, Feature T617, “FIRST_VALUE and LAST_VALUE functions”, and Feature T618, “NTH_VALUE function”.
• 6) Clause 7, “Nested window functions”, discusses the additional window functionality in Feature T619, “Nested window functions”.
• 7) Clause 8, “Enhanced aggregate functions”, discusses Feature T621, “Enhanced numeric functions” and its introduction of enhanced aggregate functions in SQL.

1 Scope

This document discusses the syntax and semantics for including online analytic processing (OLAP) capabilities in SQL, as defined in ISO/IEC 9075-2.

It discusses the following features regarding OLAP capabilities of the SQL language:

• Feature T611, “Elementary OLAP operations”,
• Feature T612, “Advanced OLAP operations”,
• Feature T614, “NTILE function”,
• Feature T615, “LEAD and LAG functions”,
• Feature T616, “Null treatment option for LEAD and LAG functions”,
• Feature T617, “FIRST_VALUE and LAST_VALUE functions”,
• Feature T618, “NTH_VALUE function”,
• Feature T619, “Nested window functions”,
• Feature T620, “WINDOW clause: GROUPS option”,
• Feature T621, “Enhanced numeric functions”.

2 Normative references

There are no normative references in this document.

3 Terms and definitions

No terms and definitions are listed in this document.

ISO and IEC maintain terminological databases for use in standardization at the following addresses:

Bibliography