Find a list of entries whose insertion into the original


Consider the Linear Hashing index shown in Figure 10.15. Assume that we split whenever an overflow page is created. Answer the following questions about this index:

1. What can you say about the last entry that was inserted into the index?

2. What can you say about the last entry that was inserted into the index if you know that there have been no deletions from this index so far?

3. Suppose you know that there have been no deletions from this index so far. What can you say about the last entry whose insertion into the index caused a split?

4. Show the index after inserting an entry with hash value 4.

5. Show the original index after inserting an entry with hash value 15.

6. Show the original index after deleting the entries with hash values 36 and 44. (Assume that the full deletion algorithm is used.)

7. Find a list of entries whose insertion into the original index would lead to a bucket with two overflow pages. Use as few entries as possible to accomplish this. What is the maximum number of entries that can be inserted into this bucket before a split occurs that reduces the length of this overflow chain?

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Find a list of entries whose insertion into the original
Reference No:- TGS01594644

Expected delivery within 24 Hours