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, 22.06.2019 16:30
What type of file does a cookie place on web site visitors' computers so that web site managers can customize their sites to their visitors' preferences?
Answers: 1
question
Computers and Technology, 22.06.2019 19:20
Write a program that prompts the user to input a string. the program then uses the function substr to remove all the vowels from the string. for example, if str = "there", then after removing all the vowels, str = "thr". after removing all the vowels, output the string. your program must contain a function to remove all the vowels and a function to determine whether a character is a vowel.
Answers: 2
question
Computers and Technology, 24.06.2019 02:00
How are we able to create photographs differently than 100 years ago? explain your answer in relation to your photograph you selected.
Answers: 1
question
Computers and Technology, 24.06.2019 08:00
Arah has entered data about football players from team a and team b in a worksheet. she enters names of players from team a with details about each player in different columns of the worksheet. similarly, she enters details of all the players from team b. which option will her view the data for team a and team b in two separate sections after printing? a. page break view b. freeze pane view c. split screen view d. full screen view e. zoom out view
Answers: 1
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
Mathematics, 08.08.2019 18:10
question
Mathematics, 08.08.2019 18:10
Questions on the website: 13722362