A database must store an employee table consisting of 100000records each of which is 80bytes long. Answer the following questions by assuming these congurations/parameters: B = 512bytes, interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace = 400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads), rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, and btt = 0.03255ms. 1. How many records can be stored per block (blocking factor) using spanned and unspanned congurations? 2. What is the utilization (%) for the unspanned conguration? 3. If the le is physically ordered, what is the average time in milli second to read a record in each conguration?
A
long. Answer the following questions by assuming these congurations/parameters: B = 512bytes,
interblock gap size G = 128bytes, numberof blockspertrack = 256, numberof trackspersurf ace =
400. The disk has 8 platters each with two heads (only one head can read at a time of all 16 heads),
rotates at 7200rpm, has a track − to − trackseektime(m) of 1ms, s = 12ms, r = 4.16ms, and
btt = 0.03255ms.
1. How many records can be stored per block (blocking factor) using spanned and unspanned
congurations?
2. What is the utilization (%) for the unspanned conguration?
3. If the le is physically ordered, what is the average time in milli second to read a record in
each conguration?
Step by step
Solved in 3 steps