CSA - ISO/IEC TR 19075-9-21
Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities
inactive, Most Current
| Organization: | CSA |
| Publication Date: | 1 January 2021 |
| Status: | inactive |
| Page Count: | 68 |
| ICS Code (Languages used in information technology): | 35.060 |
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".
Document History
ISO/IEC TR 19075-9-21
January 1, 2021
Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities
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...