What is Buffer Pool Metadata?
For each frame, the buffer manager keeps some information in the pool. This is done to track frames more easily.
Frame ID: The ID of each frame in the random pool.
Page ID: Used to determine which page is currently available.
dirty: Used to determine whether the page has been updated since being brought to the impure pool disk. It is a boolean variable. If the page has been updated then dirty is set to 1 otherwise 0.
pin_count: used to track the number of requests using a page. “pin_count” will increment each time a page is requested. When the request is met, “pin_count” will increase and pin_count will decrease.
What is Buffer Manager?
Buffer Management in DBMS is used to allocate the space in the main memory so that the user can access data from the main memory immediately. In this article, we will learn about buffer managers in DBMS. We will also understand the methods that are used by buffer managers.
Contact Us