The database stores an employee table consisting of 500,000 records each of which is 400 bytes long. A SSD has storage capacity of 1 TB, read bandwidth of 1 GB/sec., and a block size of 4096 bytes. The database designer wants to add a large description field of 1,000 bytes to each employee record. However, this field will only have data in it 20% of the time and is only accessed in 25% of the queries. 1)Calculate: The average time (in seconds) to read the whole table when using spanned, fixed records and no splitting. 2)Calculate: The average time (in seconds) to read the whole table when using spanned, variable records. Assume a variable length record requires 20 bytes of overhead to store record information. 3)Calculate: The average time (in seconds) to read the whole table when using spanned records and splitting. Assume using splitting requires 20 bytes of overhead. The large 1000 byte field is only access 25% of the time
The
1)Calculate: The average time (in seconds) to read the whole table when using spanned, fixed records and no splitting.
2)Calculate: The average time (in seconds) to read the whole table when using spanned, variable records. Assume a variable length record requires 20 bytes of overhead to store record information.
3)Calculate: The average time (in seconds) to read the whole table when using spanned records and splitting. Assume using splitting requires 20 bytes of overhead. The large 1000 byte field is only access 25% of the time.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
