5pt] Dr. Mark Dogfury, the world-famous database researcher, decided that a page

Question

5pt] Dr. Mark Dogfury, the world-famous database researcher, decided that a page as in Question la and Fig. 1 should be packed whenever it is read into the buffer pool (and it is not already packed). He claims this will ultimately be more efficient, since the page will never need to be packed any time just before a new record is added to the page. To support this, Dr. Dogfury makes changes to the database-system code to includea packedBit on each page. The packedBit is set to true after being packed, and to false after any operation that might leave the page unpacked After the changes, however, the database system's I/O performance worsened. Surmise why.

Explanation / Answer

A buffer pool is a part of main memory which is used by the database manager. The most recently accessed information is being cached. The response time would be higher if there are multiple same time of operations involved in the database.

The idea of having packedBit within buffer pool of a database has worsened the performance of the database and I/O for many reasons. Some of them are:
-> It has created additional overhead for maintaining the packedBits.
-> Each time the information is accessed the packedBit read and response time was very high if a load is more.
-> The time takes for an update is high.
-> The main idea of caching is gone since so much of the time spent on data update, dirty bit clean and so on.
-> Buffer pool memory capacity was less and since additional information needs to be maintained, it further reduced the cache capability and accessibility.
-> Buffer pool need to be modified each time.

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.