TOPICS (Click to Navigate)
Thursday, 15 December 2016
Database buffer cache and its role in DBMS
Buffer Cache is a shared and reserved memory area that stores the most recently accessed data blocks from hard disk in RAM. It is also called as data cache. It may contain “dirty” (modified data blocks) and “clean” (unused) blocks. Buffer cache is mainly used to take advantage of a computer’s fast primary memory compared to the slower secondary memory, thereby minimizing the number of input/output (I/O) operations between the primary and secondary memories.
For example, when you execute a query to find some information the DBMS will fetch the data blocks that might contain the required records into buffer cache. Then the data blocks in the buffer cache will be searched for the required records.
Go to Database Glossary - DBMS Important Keywords page
SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...
Advanced concepts in DBMS Advanced Database Topics (Click on the links to navigate) Advanced Concepts in D...
Set of solved exercises in Normalization / Normalization Solved Examples / How to find candidate keys, and primary keys in database? /...
Query Processing in DBMS / Steps involved in Query Processing in DBMS / How is a query gets processed in a Database Management System? / Q...