Discuss how OLAP functionality is provided by the ROLLUP and CUBE functions of the SQL standard.
What will be an ideal response?
Aggregation is a fundamental part of OLAP. To improve aggregation capabilities the SQL
standard provides extensions to the GROUP BY clause such as the ROLLUP and CUBE
functions.
ROLLUP supports calculations using aggregations such as SUM, COUNT, MAX, MIN, and
AVG at increasing levels of aggregation, from the most detailed up to a grand total. CUBE is
similar to ROLLUP, enabling a single statement to calculate all possible combinations of
aggregations. CUBE can generate the information needed in cross-tabulation reports with a
single query.
ROLLUP and CUBE extensions specify exactly the groupings of interest in the GROUP BY
clause and produces a single result set that is equivalent to a UNION ALL of differently
grouped rows.
You might also like to view...
For a non-empty linked list, select the code that should appear in a function that adds a node to the end of the list. newPtr is a pointer to the new node to be added and lastPtr is a pointer to the current last node. Each node contains a pointer nextPtr.
a. lastPtr->nextPtr = newPtr; lastPtr = newPtr b. lastPtr = newPtr; lastPtr->nextPtr = newPtr c. newPtr->nextPtr = lastPtr; lastPtr = newPtr d. lastPtr = newPtr; newPtr->nextPtr = lastPtr
At some point, alpha = 0.0 and beta = 0 . A possible move eval uates to -0 . Which of the following is true:
a. alpha is changed to -6.0 if we are evaluating a move for the com puter. b. alpha is changed to -6.0 if we are evaluating a move for the human. c. beta is changed to -6.0 if we are evaluating a move for the com puter. d. beta is changed to -6.0 if we are evaluating a move for the human. e. Neither alpha nor beta is changed
Which of the following is a free packet sniffer that is available for both Windows and Macintosh systems?
A) Wire shark B) Ether Detect C) Comm View D) Microsoft
What aspect of a signal does the Manchester Encoding use to represent a bit?
What will be an ideal response?