At times a user may want to drill through the cube to the


Suppose that a data warehouse contains 20 dimensions, each with about five levels of granularity.

(a) Users are mainly interested in four particular dimensions, each having three frequently accessed levels for rolling up and drilling down. How would you design a data cube structure to support this preference efficiently?

(b) At times, a user may want to drill through the cube to the raw data for one or two particular dimensions. How would you support this feature?

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: At times a user may want to drill through the cube to the
Reference No:- TGS01605700

Expected delivery within 24 Hours