Regarding the computation of measures in a data cube: (a) Enumerate three categories of measures, based on the kind of aggregate functions used in com- puting a data cube. (b) For a data cube with the three dimensions time, location, and item, which category does the function variance belong to? Describe how to compute it if the cube is partitioned into many chunks. Hint: The formula for computing variance is Σ( - )², where F, is the average of 1,s. (c) Suppose the function is "top 10 sales." Discuss how to efficiently compute this measure in a data cube.

Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter21: Simulation
Section21.5: Simulations With Continuous Random Variables
Problem 4P
icon
Related questions
Question
. Regarding the computation of measures in a data cube:
(a) Enumerate three categories of measures, based on the kind of aggregate functions used in com-
puting a data cube.
(b) For a data cube with the three dimensions time, location, and item, which category does the
function variance belong to? Describe how to compute it if the cube is partitioned into many
chunks.
Hint: The formula for computing variance is
(₁ - 1)², where 7, is the average of 1,s.
(c) Suppose the function is "top 10 sales." Discuss how to efficiently compute this measure in a data
cube.
Transcribed Image Text:. Regarding the computation of measures in a data cube: (a) Enumerate three categories of measures, based on the kind of aggregate functions used in com- puting a data cube. (b) For a data cube with the three dimensions time, location, and item, which category does the function variance belong to? Describe how to compute it if the cube is partitioned into many chunks. Hint: The formula for computing variance is (₁ - 1)², where 7, is the average of 1,s. (c) Suppose the function is "top 10 sales." Discuss how to efficiently compute this measure in a data cube.
Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Dynamic Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole