How a system may use the data in this warehouse to work

Assignment Help Basic Computer Science

Reference no: EM131222066

Suppose a company wants to design a data warehouse to facilitate the analysis of moving vehicles in an online analytical processing manner. The company registers huge amounts of auto movement data in the format of (Auto ID, location, speed, time). Each Auto ID represents a vehicle associated with information (e.g., vehicle category, driver category), and each location may be associated with a street in a city. Assume that a street map is available for the city.

(a) Design such a data warehouse to facilitate effective online analytical processing in multidimensional space.

(b) The movement data may contain noise. Discuss how you would develop a method to automatically discover data records that were likely erroneously registered in the data repository.

(c) The movement data may be sparse. Discuss how you would develop a method that constructs a reliable data warehouse despite the sparsity of data.

(d) If you want to drive from A to B starting at a particular time, discuss how a system may use the data in this warehouse to work out a fast route.

Reference no: EM131222066

Questions Cloud

Maker of winglow is purchasing new stamping machine : The maker of Winglow is purchasing a new stamping machine. Two options are being considered, Rooney and Blair. The sales forecast for Winglow is 8,750 units for next year. If variable costs are now $20 per unit, which machine should be purchased? Bl..

Determine whether f is a mnetion from z to r it if : Determine whether f is a Mnetion from Z to R It if. Determine whether each of these function from Z to Z is 1-1 or is an injection. Justify your answer.

What is the inventory turnover : Net sales on account during year $517, 500 Cost of merchandise sold during year 450,000 Accounts receivable. -Based on the following data for the current year, what is the inventory turnover?

Development of a new product : A new engineering team is put together for the development of a new product. This new product will be built through an assembly line. The production manager designs the assembly line. He has been advised that the assembly line must be ready in fou..

How a system may use the data in this warehouse to work : The movement data may be sparse. Discuss how you would develop a method that constructs a reliable data warehouse despite the sparsity of data.

Describe how the defects detected during the acceptance : Develop a workflow model that can be used to inspect and detect defects during the acceptance of this mobile product through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically de..

What special challenges are agencies and specifically : What special challenges are agencies and specifically Chief's of police facing in this current environment? What steps would you take to address those current challenges? Please provide examples.

What is the value of the call option : Suppose the current price of MDD stock is $90. -What is the value of the call option if the exercise price is $75 per share?

Design a data warehouse to facilitate effective registration : If a customer returns a jug of milk and complains that is has spoiled before its expiration date, discuss how you can investigate such a case in the warehouse to find out what the problem is, either in shipping or in storage.

User Account

All Pages