Responsibility of buffer manager - Database

Q.  What is the responsibility of the buffer manager?

- Published on 19 Oct 15

a. Fetching data from disk storage into main memory, and deciding what data to cache in main memory.
b. Allocation of space on disk storage and the data structures used to represent information stored on disk.
c. Storing details such as how many users, which user has which permissions etc.
d. None of the above

ANSWER: Fetching data from disk storage into main memory, and deciding what data to cache in main memory.
 

    Discussion

  • Nirja Shah   -Posted on 29 Oct 15
    -The responsibilities of the buffer manager are:

    1. He controls main memory directly as in many relational DBMS.

    2. It allocates buffers in virtual memory, allowing the operating system to decide which buffers are actually in main memory at any time and which are in the "swap space" on disk that the operating system manages. Many "main-memory" DBMS's and "object-oriented" DBMS's operate this way.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)