Information technology database languages - Guidance for the use of database language SQL - Part 9: Online analytic processing (OLAP) capabilities

CSA Group
Standards Development Organisation:
Canadian Standards Association (operating as CSA Group)
Working Program:
View the CSA work program
Designation Number:
ISO/IEC TR 19075-9
Standard Type:
National Standard of Canada - Adoption of International Standard
Standard Development Activity:
New Standard
ICS code(s):
35.060
Status:
Proceeding to development
SDO Comment Period Start Date:
SDO Comment Period End Date:
Posted On:

Scope:

Information technology database languages - Guidance for the use of database language SQL - Part 9: Online analytic processing (OLAP) capabilities 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”.

Project need:

To align Canadian requirements with those of the respective international standards being proposed for adoption. To maintain alignment between Canadian information and communication technology standards and each respective international standard.

Note: The information provided above was obtained by the Standards Council of Canada (SCC) and is provided as part of a centralized, transparent notification system for new standards development. The system allows SCC-accredited Standards Development Organizations (SDOs), and members of the public, to be informed of new work in Canadian standards development, and allows SCC-accredited SDOs to identify and resolve potential duplication of standards and effort.

Individual SDOs are responsible for the content and accuracy of the information presented here. The text is presented in the language in which it was provided to SCC.