ISO/IEC TR 19075-9:2020Withdrawn

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

Langages de bases de données utilisés dans les technologies de l'information — Recommandations pour l'utilisation du langage de base de données SQL — Partie 9: Capacités de traitement analytique en ligne

This edition has been replaced by ISO/IEC 19075-9:2022.

Abstract / scope

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

Life cycle

Replaced by

ISO/IEC 19075-9:2022PublishedInformation technology — Guidance for the use of database language SQL — Part 9: Online analytic processing (OLAP) capabilities (Guide/OLAP)International Standard · Published 3 Oct 2022 · ISO/IEC JTC 1/SC 32