Question
decide whether to use a data warehouse or a data lake to store and manage the data. Justify your answer in terms of the variety
decide whether to use a data warehouse or a data lake to store and manage the data. Justify your answer in terms of the variety of data, the volume of the data, and the velocity of the data as well as what sorts of applications need to be supported in these scenarios.
Scenario 1
A car rental company has over 600,000 cars. Each car has about 30 sensors which the car rental company wants to monitor at 15 minute intervals. The company wants to collect that data for multiple purposes. First, they would like to understand how the car is being driven during rental period (How far? At what speeds? How much time spent in the idling mode? Etc.) in order to possibly make adjustments to their business model as well as to make adjustments the type of routine maintenance of the cars. Second, they would like to know where the cars are located (in order to possibly alert emergency crews, should the need arise). And, third, they would like to determine the current driving condition of the car (that is, the probability that it will need non-routine maintenance work in the immediate future) in order to possibly substitute another car for a car with a high probability of needing non-routine maintenance work. You are tasked to design a system that allows the company to store the data with the ability to analyze and report on it.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started