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

Publication details

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