Skip to main content

Buffer Pool

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems
  • 61 Accesses

Synonyms

I/O cache; Page cache

Definition

Cost constraints (dollars per gigabyte) prohibit in-memory databases in most cases, but processors can access and manipulate data only while it is in memory. The in-memory buffer pool holds database pages currently in use and retains those deemed likely to be used again soon.

The buffer pool and the buffer management component within the storage layer of a database management system provide fast access and fast recall of on-disk pages using in-memory images of those pages. In addition to the size of individual pages and of the entire buffer pool, key issues are (i) page replacement in response to buffer faults, and (ii) page retention and update in aid of database recovery.

A database buffer pool differs from virtual memory as it contributes to correctness and efficiency of query and update processing, e.g., by pinning pages while in use and by ensuring a write sequence that guarantees the ability to recover. In some systems, the buffer pool...

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Institutional subscriptions

Recommended Reading

  1. Bansal S, Modha DS. CAR: clock with adaptive replacement. In: Proceedings of the 3rd USENIX Conference on File and Storage Technologies; 2004. p. 187–200.

    Google Scholar 

  2. Chou H-T, DeWitt DJ. An evaluation of buffer management strategies for relational database systems. Algorithmica. 1986;1(3):311–36.

    Article  MathSciNet  Google Scholar 

  3. Effelsberg W, Härder T. Principles of database buffer management. ACM Trans Database Syst. 1984;9(4):560–95.

    Article  Google Scholar 

  4. Gray J, Putzolu GR. The 5 minute rule for trading memory for disk accesses and the 10 byte rule for trading memory for CPU time. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1987. p. 395–8.

    Google Scholar 

  5. Ramamurthy R, DeWitt DJ. Buffer-pool aware query optimization. In: Proceedings of the 2nd Biennial Conference on Innovative Data Systems Research; 2005. p. 250–61.

    Google Scholar 

  6. Stonebraker M. Operating system support for database management. Commun ACM. 1981;24(7):412–8.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Goetz Graefe .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media LLC

About this entry

Cite this entry

Graefe, G. (2016). Buffer Pool. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_682-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_682-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics