Discuss how OLAP functionality is provided by elementary operators such as moving windows and ranking functions of the SQL standard.
What will be an ideal response?
The Elementary OLAP operators of the OLAP package of the SQL standard supports a variety
of operations such as rankings and window calculations. Ranking functions include
cumulative distributions, percent rank, and N-tiles. Windowing allows the calculation of
cumulative and moving aggregations using functions such as SUM, AVG, MIN, and
COUNT.
You might also like to view...
Which of the following is a small text file that web pages can place on your computer to keep track of your browsing activity?
A) Spyware B) Cookie C) Key logger D) Trojan
How would you add Category information to a PivotTable?
A. Click the Category check box in the Field List. B. Click the More check box in the Field List. C. Type "Category" directly into the PivotTable. D. Click the Field check box in the Category List.