Q52
NAT2 marksConsider a database of fixed-length records, stored as an ordered file. The database has records, with each record being bytes, of which the primary key occupies bytes. The data file is block-aligned in that each data record is fully contained within a block. The database is indexed by a primary index file, which is also stored as a block-aligned ordered file. The figure below depicts this indexing scheme.

Suppose the block size of the file system is bytes, and a pointer to a block occupies bytes. The system uses binary search on the index file to search for a record with a given key. You may assume that a binary search on an index file of blocks takes block accesses in the worst case. Given a key, the number of block accesses required to identify the block in the data file that may contain a record with the key, in the worst case, is _____________.
Loading…