Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications Dexa 2021 Workshops Biokdd Iwcfs Mlkgraphs Al Cares Protime Alsys 2021 Virtual Event September 27 30 2021 Proceedings

Authors: Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil ,Bernhard Moser ,Atif Mashkoor ,Johannes Sametinger ,Anna Fensel ,Jorge Martinez-Gil ,Lukas Fischer

1st Edition

3030871002, 978-3030871000

More Books

Students also viewed these Databases questions