Discuss the difference in storage requirements for a data cube implemented as a multidimensional array and a fact table.
What will be an ideal response?
If the data cube has m dimensions, and the attribute in the jth dimension can take on nj values (e.g., there are 100 markets in the market dimension), the complete description of that cube in a multidimensional array or a fact table would take n1 ? n2 ? ... ? nm storage locations. However, if some items are missing (e.g. Market 10 had no sales of Product 4 in the time period T4), that rowcan be omitted from the fact table, but the space has already been allocated in the array. Thus in practice the fact table is considerably smaller than the multidimensional array.
You might also like to view...
Which of the following statements will remove all items from the list box?
(A) ``` lstBox.Items.RemoveAll ``` (B) ``` lstBox.Clear() ``` (C) ``` lstBox.Items.Clear() ``` (D) ``` For i As Integer = 1 To lstBox.Items.Count lstBox.Items.RemoveAt(i) Next ```
3 Suppose circle1 and circle2 are two Circle objects. What does the following statement do?
circle2 = circle1; A. This statement is illegal. B. It makes circle2 and circle1 the same object. C. It copies the contents of circle2 to circle1. D. It copies the contents of circle1 to circle2.
A(n) ________ provides a visual connection between widely separated text
Fill in the blank(s) with correct word
____ measures the resources a user consumes during each network session.
A. Accounting B. Authorization C. Authentication D. Integrity