Buffer management in DBMS Theory - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is buffer management in a database management system (DBMS)?

Buffer management is the process of efficiently handling the temporary storage area (buffer) in memory where data pages are kept while being read from or written to disk. It helps speed up data access by reducing disk I/O operations.

beginner

Why is buffer management important in DBMS?

Because accessing data from memory is much faster than from disk, buffer management improves performance by minimizing slow disk reads and writes. It ensures frequently used data stays in memory for quick access.

beginner

What is a buffer pool?

A buffer pool is a reserved area in main memory where the DBMS stores copies of disk pages temporarily. It acts like a cache to hold data pages that are being used or modified.

intermediate

What is the role of a replacement policy in buffer management?

A replacement policy decides which data page to remove from the buffer pool when new pages need space. Common policies include Least Recently Used (LRU) and First-In-First-Out (FIFO).

intermediate

Explain the difference between a dirty page and a clean page in buffer management.

A dirty page is a page in the buffer that has been modified but not yet written back to disk. A clean page has not been changed since it was loaded or was already saved to disk.

What is the main purpose of buffer management in a DBMS?

A To permanently store data on disk

B To encrypt data before storage

C To reduce disk access by storing data temporarily in memory

D To backup data to external devices

Buffer management reduces slow disk access by keeping data pages in memory temporarily for faster access.

Which of the following is a common buffer replacement policy?

A Least Recently Used (LRU)

B Binary Search

C Round Robin

D Depth First Search

LRU removes the page that has not been used for the longest time to make space in the buffer.

What does a 'dirty page' in buffer management mean?

A A page that is read-only

B A page that is corrupted

C A page that is empty

D A page that has been modified but not saved to disk

Dirty pages have changes in memory that are not yet written back to disk.

What is a buffer pool?

A A disk storage area

B A memory area holding copies of disk pages

C A network connection pool

D A backup storage system

The buffer pool is a reserved memory area where data pages from disk are temporarily stored.

Why does buffer management improve DBMS performance?

A Because memory access is faster than disk access

B Because it compresses data

C Because it encrypts data

D Because it deletes old data

Accessing data in memory is much faster than reading from or writing to disk, so buffer management speeds up operations.

Describe what buffer management is and why it is used in database systems.

Think about how data is accessed faster from memory than disk.

Explain the difference between a dirty page and a clean page in the context of buffer management.

Consider what happens when data in memory changes before saving.