Design a data warehouse to facilitate effective registration

Assignment Help Basic Computer Science
Reference no: EM131222062

Radio-frequency identification is commonly used to trace object movement and perform inventory control. An RFID reader can successfully read an RFID tag from a limited distance at any scheduled time. Suppose a company wants to design a data warehouse to facilitate the analysis of objects with RFID tags in an online analytical processing manner. The company registers huge amounts of RFID data in the format of (RFID, at location, time), and also has some information about the objects carrying the RFID tag, for example, (RFID, product name, product category, producer, date produced, price).

(a) Design a data warehouse to facilitate effective registration and online analytical processing of such data.

(b) The RFID data may contain lots of redundant information. Discuss a method that maximally reduces redundancy during data registration in the RFID data warehouse.

(c) The RFID data may contain lots of noise such as missing registration and misread IDs. Discuss a method that effectively cleans up the noisy data in the RFID data warehouse.

(d) You may want to perform online analytical processing to determine how many TV sets were shipped from the LA seaport to Best Buy in Champaign, IL, by month, brand, and price range. Outline how this could be done efficiently if you were to store such RFID data in the warehouse.

(e) 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.

Reference no: EM131222062

Questions Cloud

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.
Problem regarding the emotional intelligence : "Emotional Intelligence" Please respond to the following: Read the blog post on emotional intelligence titled, "The Case for Hiring Emotionally Intelligent Leaders". Next, give your opinion on the most important competency of emotional intelligenc..
Plot given index and a second line : The Federal Reserve Bank of St. Louis publishes a weekly index of financial stress (FRED code: STLFSI) that summarizes strains in financial markets, including liquidity problems.
According to the control chart parameter table : 1. What is X-bar-bar? Round your answer to two decimals. 2. What is R-bar? Round your answer to two decimals. 3. According to the control chart parameter table, what is A2? Round your answer to two decimals.
Analyze relationship between the organizational structure : Suggest how a typical software engineering team could be staffed and describe each team member's role. Determine the skills that are required for each team member for the success of the software project development.

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Current checking account of the corporation

The current checking account of the corporation has an EAR of 0.1 percent. The corporation is in the 33 percent federal marginal tax bracket and in a 6 percent state marginal tax bracket. You expect inflation to be .5 percent this year. There are ..

  What is the benefit of segmentation for the 370

Which advantages of segmentation does this scheme lack? What is the benefit of segmentation for the 370?

  How then does cobit help us with sox compliancy

How then does COBIT help us with SOX compliancy? Is COBIT the best framework to assist in the ambiguity SOX compliance has toward IT?

  The opportunity to do analysis on the data

Task Background: Graphs and trees provide you with ways to visualize data sets, and the opportunity to do analysis on the data (e.g., shortest path). Knowing the structure of a database enables you to choose a proper algorithm for searching for..

  Create a powerpoint presentation on a person that admire you

Select a person that you admire the most. The person can be a family member, friend, musician, etc. Create a four (4) slide PowerPoint presentation

  What is meant by transaction rollback

Which recovery techniques do not require any rollback?

  Write the expressions

Write the expressions for (g*f)(x) and (g-f)(x)and evaluate  (g+f)(2)

  Apply programming design concepts through creation

The task is to animate a cat chasing a mouse as it tries to get close enough to catch it (within 1 foot). Of course, as the cat continues to chase the mouse, the mouse is also running away and moves to random positions, trying to lose the cat. You wa..

  Why is strict or rigorous two-phase locking often preferred

Why is strict or rigorous two-phase locking often preferred?

  Abbreviation css in web design represent

What does the abbreviation CSS in web design represent?

  Write a program that demonstrates the class

Write a program that demonstrates the class. The program should ask the user to enter a temperature, and then display a list of the substances that will freeze at that temperature and those that will boil at that temperature. For example, if the t..

  Advising about a software purchase

Your local art museum recently purchased a quad-core computer with 16 GB of RAM. The curator read an article about an art collection inventory system software package that could go on the new computer. You have a long experience with end users has..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd