db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "OLAPOperations" by BryanPendleton
Date Wed, 18 Jul 2007 22:41:16 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by BryanPendleton:
http://wiki.apache.org/db-derby/OLAPOperations

------------------------------------------------------------------------------
- The SQL-99 standard includes definitions for a number of new features, which are collectively
referred to as OLAP Operations. The features are grouped into two classifications, as follows:
+ The SQL-2003 standard includes definitions for a number of new features, which are collectively
referred to as OLAP Operations. The features are grouped into two classifications, as follows:
   * T611: Elementary OLAP operations
   * T612: Advanced OLAP operations
  
  This page, which is currently a stub, is intended to contain information about OLAP operations
and Derby.
  
+ == T611: Elementary OLAP operations ==
+ 
+ Feature T611 of the 2003 SQL standard specifies the following items:
+  * Window functions (ROW_NUMBER, RANK, and DENSE_RANK)
+  * Unnamed window specifications:
+    * window partitioning (PARTITION BY)
+    * window ordering (ORDER BY)
+    * window framing (ROWS/RANGE PRECEDING/FOLLOWING)
+  * null ordering
+ 
+ == T612: Advanced OLAP operations ==
+ 
+ Feature T612 of the 2003 SQL standard specifies the following items:
+  * Window functions PERCENT_RANK and CUME_DIST
+  * Window naming
+  * Window clauses
+  * Window frame exclusions
+  * Width buckets
+ 

Mime
View raw message