Question: Consider a database buffer manager that uses 1GB of main memory (buffer space) and keeps data on a hard drive which reads 100MB per second
Consider a database buffer manager that uses 1GB of main memory (buffer space) and keeps data on a hard drive which reads 100MB per second and takes 10 milliseconds per disk seek.
Assume that (1) the size of each disk block is 10KB and (2) for each block kept in the buffer, the probability that the buffer manager can handle the next data request using that block (i.e., the probability that the block contains the requested data) is 5 106 . In this case, calculate the expected data access time (i.e., how much time the buffer manager on average spend to provide a requested disk block). For this calculation, assume that the buffer is already full (i.e., the entirety of the 1GB buffer space is already used to hold 105 disk blocks), and no disk blocks are updated (i.e., no need to write dirty blocks back to the hard drive). Also, ignore the time spent for reading/writing data in the main memory.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
