subject

2) Suppose a company would like to design a data warehouse to facilitate the analysis of objects with RFID tags in an online analytical processing manner. Since recently, the Radio-Frequency Identification (RFID) 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.) 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, e. g., (RFID, product name, product category, producer, date produced, price). a) Design a data warehouse using a Star schema to facilitate effective registration and online analytical processing of such data. b) Design the above data warehouse using a snowflake schema. c) Design the above data warehouse using a fact constellation schema. d) (Optional) The RFID data may contain lots of noise, such as missing registration and misreading of IDs. Discuss a method that effectively cleans up the noisy data in the RFID data warehouse. e) (Optional) If a customer returns a jug of milk and complains that it has spoiled before its expiration data, discuss how you could investigate such a case in the warehouse to find out what could be the problem, either in shipping or in storage.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 17:10
Can be categorized as popularity, relevancy, and user satisfaction. select one: a. mobile search seo b. ranking factors c. serp d. web analytics
Answers: 1
question
Computers and Technology, 22.06.2019 02:30
The cm is responsible for overseeing the actions of the crisis management team and coordinating all crisis management efforts in cooperation with disaster recovery and/or business continuity planning, on an as-needed basis
Answers: 1
question
Computers and Technology, 22.06.2019 10:00
Create a word problem that involves calculating the volume and surface area of a three-dimensional object. cube: surface area 6 s2 , volume s3
Answers: 3
question
Computers and Technology, 23.06.2019 08:30
Helen's credit card has an apr of 15.32% and a grace period of 17 days and helen pays her balance in the full every month. if her last billing cycle ended on september 26, 2009, and she made her payment on october 11, 2009, did she owe any interest on her last statement's balance?
Answers: 3
You know the right answer?
2) Suppose a company would like to design a data warehouse to facilitate the analysis of objects wit...
Questions
question
Business, 13.04.2021 20:00
question
Mathematics, 13.04.2021 20:00
question
Mathematics, 13.04.2021 20:00
question
Geography, 13.04.2021 20:00
question
Mathematics, 13.04.2021 20:00
question
Mathematics, 13.04.2021 20:00
question
Biology, 13.04.2021 20:00
Questions on the website: 13722360