Chapter 13: Problem 3
Define the following terms: disk, disk pack, track, block, cylinder, sector, interblock gap, read/write head.
Chapter 13: Problem 3
Define the following terms: disk, disk pack, track, block, cylinder, sector, interblock gap, read/write head.
All the tools & learning materials you need for study success - in one app.
Get started for freeSuppose we want to create a linear hash file with a file load factor of 0.7 and a block. ing factor of 20 records per bucket, which is to contain 112,000 records initially. a. How many buckets should we allocate in the primary area? b. What should be the number of bits used for bucket addresses?
Suppose that a file initially contains \(r=120,000\) records of \(R=200\) bytes each in an unsorted (heap) file. The block size \(B=2400\) bytes, the average seek time \(s=\) \(16 \mathrm{ms}\), the average rotational latency \(r d=8.3 \mathrm{ms}\) and the block transfer time \(b t t=\) \(0.8 \mathrm{ms} .\) Assume that 1 record is deleted for every 2 records added until the total number of active records is 240,000 a. How many block transfers are needed to reorganize the file? b. How long does it take to find a record right before reorganization? c. How long does it take to find a record right after reorganization?
Write pseudocode for the insertion algorithms for linear hashing and for extendible hashing.
Describe the mismatch between processor and disk technologies.
Suppose that a disk unit has the following parameters: seek time \(s=20\) msec; rota tional delay \(r d=10 \mathrm{msec} ;\) block transfer time \(b t t=1 \mathrm{msec} ;\) block size \(B=2400\) bytes; interblock gap size \(G=600\) bytes. An EMPLOYEE file has the following fields: \(\mathrm{SSN}, 9\) bytes; LASTNAME, 20 bytes; fIRSTNAYE, 20 bytes; MIDOLE INIT\(, 1\) byte; BIRTHOATE, 10 bytes; ADDRESS, 35 bytes; PHONE, 12 bytes; SUPERVISORSSN, 9 bytes; DEPARTMENT, 4 bytes; JOBCODE, 4 bytes; deletion marker, 1 byte. The EMPLOYEE file has \(r=30,000\) records, fixed-length format, and unspanned blocking. Write appropriate formulas and cal. culate the following values for the above eMPLoyee file: a. The record size \(R\) (including the deletion marker), the blocking factor \(b f r,\) and the number of disk blocks \(b\) b. Calculate the wasted space in each disk block because of the unspanned orga nization. c. Calculate the transfer rate \(t r\) and the bulk transfer rate brr for this disk unit (see Appendix B for definitions of tr and btr). d. Calculate the average number of block accesses needed to search for an arbitrary record in the file, using linear search. e. Calculate in msec the average time needed to search for an arbitrary record in the file, using linear search, if the file blocks are stored on consecutive disk blocks and double buffering is used. f. Calculate in msec the average time needed to search for an arbitrary record in the file, using linear search, if the file blocks are not stored on consecutive disk blocks. g. Assume that the records are ordered via some key field. Calculate the average number of block accesses and the average time needed to search for an arbitrary record in the file, using binary search.
What do you think about this solution?
We value your feedback to improve our textbook solutions.