Synonyms
Cache manager
Definition
If a buffer pool is employed in a database management system, the associated software must provide appropriate services for efficient query processing, correct transaction execution, and effective sharing and reuse of database pages. It must provide interfaces for page access including pinning and latching pages, and it must invoke primitives for disk I/O and synchronization.
Historical Background
Database buffer pool management was studied heavily in the 1970s and 1980s as the new relational database management system posed new challenges, in particular non-procedural queries with range scans. Reliance of virtual memory and file system buffer pool was investigated but rejected due to performance issues (read-ahead, prefetch) and correctness issues (transaction management, write-behind, write-through).
Buffer pool management is currently not a very active research area. It may be revived in order to serve deep storage hierarchies, e.g., slow disk, fast...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
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.
Chou H-T, DeWitt DJ. An evaluation of buffer management strategies for relational database systems. Algorithmica. 1986;1(3):311–36.
Effelsberg W, Härder T. Principles of database buffer management. ACM Trans Database Syst. 1984;9(4):560–95.
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.
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.
Stonebraker M. Operating system support for database management. Commun ACM. 1981;24(7):412–8.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Graefe, G. (2018). Buffer Manager. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_677
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_677
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering