Account:  - Login  |  Webstore  |  Shopping basket cart
English  |  Français  |  Nederlands

Publication details

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)
Available files
EN version

Status
Status IEC PUBLICATION
Situation Currently active
Origin
Committee ISO/IEC JTC 1/SC 32
DATA MANAGEMENT SERVICES
Approval
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