Publication CODE |
Title |
ISO/IEC 19075-9:2022 (2022-10) |
INFORMATION TECHNOLOGY - GUIDANCE FOR THE USE OF DATABASE LANGUAGE SQL - PART 9: ONLINE ANALYTIC PROCESSING (OLAP) CAPABILITIES (GUIDE/OLAP) |
|
Price Excl. VAT |
Total number of pages, tables and drawings |
183.00 €
|
49. |
Description
ISO/IEC 19075-9:2022 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 |
2022-10-03 |
ICS-Code (International Standards Classification) |
35.060
|
NBN Status |
New |
|
IEC publication date |
2022-10-03 |
IEC file modification date |
2022-10-10 |
IEC last modification date |
2022-10-10 |
|