Codes & Standards - Purchase
CAN/CSA-ISO/IEC 9075-1A-02
Amendment 1:2003 to CAN/CSA-ISO/IEC 9075-1:02, Information Technology - Database Languages - SQL - Part 1: Framework (SQL/Framework) - Amendment 1: On-Line Analytical Processing (SQL/OLAP) (Adopted Amendment 1:2001 to ISO/IEC 9075-1:1999)
SKU: 2416173
Published by CSA Group
Publication Year 2002
106 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).