MIT OpenCourseWare, 6.830 Database Systems, Fall 2010, Prof. Carlo Curino and Prof. Michael Stonebraker. Licensed CC BY-NC-SA 4.0. Reorganized into modules by Sequence 106. No lecture videos were published for this course; each session is notes plus readings. Source · CC BY-NC-SA 4.0
Module 2 · Database internals: storage, operators, indexing, buffer pool · Activity 8 of 32
Lecture 7: Buffer pool design and memory management
Lecture notes · Carlo Curino
Readings and discussion questions
This lecture will cover buffer and memory management strategies in database systems.
Read the following paper:
Chou, Hong-Tai, and David DeWitt. An Evaluation of Buffer Management Strategies for Relational Database Systems. Proceedings of VLDB, 1985, pp. 127-141.
As you read, think about and come to class prepared to answer the following questions:
- How much better is the hot-set model than simple LRU?
- Under what circumstances is LRU a bad idea?
- Why can these techniques be applied in database systems but not operating systems?
Assigned by MIT for this session; links go to the papers where MIT linked them. Books: Readings in Database Systems (the Red Book, 4th ed.) and Ramakrishnan & Gehrke.