Design a data cube structure to support this preference

Assignment Help Basic Computer Science

Reference no: EM131222025

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?

Reference no: EM131222025

Questions Cloud

Compute the number of units transferred to finished goods : During April, the production department of a process manufacturing system completed a number of units of a product and transferred them to finished goods.Compute the number of units transferred to finished goods.

What is the purpose of an in-circuit emulator : Cloud Computingis used as a means to provide off-site computing power to an organization. Describe the three main types of Cloud Computing platforms. What is the purpose of the control unit in a channel architecture? What type of computer generall..

Impacted as result of this change in accounting principle : At the beginning of 2012, Lion Company decided to change from the average cost inventory cost flow assumption to the FIFO cost flow assumption for financial reporting purposes. What is the adjustment required to Retained Earnings at the beginning of ..

Does a rights offer cause a share price decrease : Describe the role that the "winner's curse" may play in the underpricing of IPOs. - Does a rights offer cause a share price decrease? Why or why not?

Design a data cube structure to support this preference : 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?

Determine unit sales that are required to earn target profit : Lin Corporation has a single product whose selling price is $135 and whose variable expense is $81 per unit. The company’s monthly fixed expense is $23,580. Using the equation method, determine for the unit sales that are required to earn a target pr..

Summarize your findings in a simple bullet-point list : Refer to the case scenario that was provided to you in this unit's lab. By now, you will have created the comprehensive asset list in order of importance of each asset. For this assignment, you need to create an executive summary that explains you..

Tax tables and the tax rate schedules : Jayden calculates his 2015 income tax by using both Tax Tables and the Tax Rate Schedules. Because the Tax Rate Schedules yeild a slightly lower tax liability, he plans to pay this amount. Why is there a difference? Is Jayden's approach permissible? ..

Main types of sandwiches : Panbo Inc. is a fast food restaurant which offers 4 main types of sandwiches: Pando - classic (C), Pando - premium (P), Pando - exotic (E), and Pando - ultimate (U). Every day, the restaurant operates for 10 hours and it is expecting to sell 500 s..

User Account

All Pages