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 |
|