| Publication CODE |
Title |
| ISO/IEC TR 19075-9:2020 (2020-09) |
INFORMATION TECHNOLOGY DATABASE LANGUAGES - GUIDANCE FOR THE USE OF DATABASE LANGUAGE SQL - PART 9: ONLINE ANALYTIC PROCESSING (OLAP) CAPABILITIES |
| |
| Price Excl. VAT |
Total number of pages, tables and drawings |
|
183.00 €
|
48. |
Description
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".
|
| Class |
C990
(IEC PUBLICATIONS IEC PUBLICATIONS)
|
| Status |
IEC PUBLICATION |
| Situation |
Currently active
|
|
| Committee |
ISO/IEC JTC 1/SC 32
DATA MANAGEMENT SERVICES
|
| BEC Approval |
2020-09-18 |
| ICS-Code (International Standards Classification) |
35.060
|
| NBN Status |
New |
|
| IEC publication date |
2020-09-18 |
| IEC file modification date |
2020-09-21 |
| IEC last modification date |
2020-09-21 |
|
