Question

Please help with the answer to the question below...Thanks

Why is a buffer pool helpful (or necessary) in an RDBMS? Explain how it helps

Answer 1

A Relational Database Management System (RDBMS) is a collection of programs and capabilities that enables users to create , update , administrate and otherwise interact with a relational database. Most Commercial RDMS's use Structured Query Language (SQL) to access the database, although SQL was invented after the initial development of the relational model and is not necessary for it's use.

A Buffer Pool is also called as an buffer cache. Buffer pool is an area in a system memory that is used for caching table and index data pages as they are modified or read from disk. Buffer pool is mainly used to improve the efficiency of read and write operations i.e., to read and write as much fast as possible.

The main purpose of the Buffer Pool is to reduce database file I/O and improve the response time for data retrieval. Buffer pool only stores clean pages in order to minimize the risk of data loss.