Codes & Standards - Purchase
CAN/CSA-ISO/IEC 9075-2A-01
Amendment 1:2003 to CAN/CSA-ISO/IEC 9075-2:01, Information Technology - Database Languages - SQL - Part 2: Foundation (SQL/Foundation) - Amendment 1: On-Line Analytical Processing (SQL/OLAP) (Adopted Amendment 1:2001 to ISO/IEC 9075-2:1999)
SKU: 2416174
Published by CSA Group
Publication Year 2001
105 pages
Withdrawn
Product Details
Scope
This Amendment specifies the syntax and semantics of database language facilities that support on-line analytical processing.
The database language facilities that support on-line analytical processing include:
. Rank functions.
. Distribution functions.
. Inverse distribution functions (percentiles).
. Hypothetical set functions.
. Cumulative and other forms of moving aggregates.
. Variance, standard deviation, covariance, correlation, and linear regression functions.
This amendment also incidentally defines several new numeric functions.
NOTE 1 . The context for this Amendment is described by the Reference Model of Data Management (ISO/IEC 10032:1993)
This Amendment specifies the syntax and semantics of database language facilities that support on-line analytical processing.
The database language facilities that support on-line analytical processing include:
. Rank functions.
. Distribution functions.
. Inverse distribution functions (percentiles).
. Hypothetical set functions.
. Cumulative and other forms of moving aggregates.
. Variance, standard deviation, covariance, correlation, and linear regression functions.
This amendment also incidentally defines several new numeric functions.
NOTE 1 . The context for this Amendment is described by the Reference Model of Data Management (ISO/IEC 10032:1993)