Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain how you got the answer for further understanding Problem 3 You're the leader of the infrastructure team of a popular-enough startup. You're concerned

image text in transcribed

Please explain how you got the answer for further understanding

Problem 3 You're the leader of the infrastructure team of a popular-enough startup. You're concerned with performance metrics for a particular table that is queried frequently. The table has the following specs, - Row size: 64KB - Number of rows: 5107 - Total Data: Number of rows * Row size =3200GB=3.2TB The table is stored on a system with the following specs, - RAM: 64GB - HDD Space: 10TB The system receives numerous queries each second; each query consists of fetching some random row of the table. For this problem, let's assume parsing and transferring queries take zero time. We'll also assume accesses in RAM take zero time. Note: Remember that the average time for finding a record during a full scan is half of the maximum time. Question 3.1 The current architecture involves having all the data stored on the system's HDD. All rows are randomly stored on the HDD. Any fetch queries need to fetch the associated data from there. What is the average response time in secs for a query, i.e., time to fetch a row? Assume that all rows are equally likely to be queried. Question 3.2 While you're surprised at the high response time, an Analytics expert drops by your office. She mentions that a fixed 1% of the table rows are responsible for 90% of the query traffic. Would you suggest any change to the current architecture given this information? State your suggestion concisely. What's the average response time in secs after your suggestion? Notes: - Assume the table rows in the described 1% are equally responsible for 90% of the query traffic. The remaining 99% of rows have equally likely queries. - To reduce calculations, assume the architecture change we're looking for does not involve grouping blocks to be contiguous. Try to think of another way to reduce response time using other resources. Hint: RAM has more uses than just running Chrome

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

Navigating The Supply Chain Maze A Comprehensive Guide To Optimize Operations And Drive Success

Authors: Michael E Kirshteyn Ph D

1st Edition

B0CPQ2RBYC, 979-8870727585

More Books

Students also viewed these Databases questions

Question

=+1. What is the nature and type of each key public?

Answered: 1 week ago