ISO/IEC TR 19075-9
Information technology database languages — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities
active, Most Current
Buy Now
| Organization: | ISO |
| Publication Date: | 1 September 2020 |
| Status: | active |
| Page Count: | 58 |
| 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
September 1, 2020
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...