Lecture 5. DBMS architecture
Readings:
- Paper to review: Joseph Hellerstein and Michael Stonebraker. The Anatomy of a Database System. In Red Book (4th ed). Focus on Sections 1-4 and skim the rest [pdf].
- The following paper is a very short read: Michael Stonebraker. Operating System Support for Database Management. Communications of the ACM. Vol 24. Number 7. July 1981. Also in Red Book (3rd ed and 4th ed). [pdf]
The Hellerstein paper should be straightforward to read, so we are not posting
any specific reading questions.
Lecture notes:
Optional, additional readings:
- Joseph Hellerstein, Michael Stonebraker, and James Hamilton. Architecture of a Database System. Foundations and Trends® in Databases. Volume 1. Issue 2.
- Chapter 41. Overview of PostgreSQL Internals.
- M.M. Astrahan et al. System R: Relational Approach to Database Management. ACM TODS 1(2), 1976. Pages 97-137. Read only the following: Section 1, Section 2 up to page 110, Section 3 up to page 122. Also in the Red Book (3rd ed). [pdf]
- A History and Evaluation of System R. Donald D. Chamberlin, Morton A. Astrahan, Michael W. Blasgen, James N. Gray, W. Frank King, Bruce G. Lindsay, Raymond Lorie, James W. Mehl, Thomas G. Price, Franco Putzolu, Patricia Griffiths Selinger, Mario Schkolnick, Donald R. Slutz, Irving L. Traiger, Bradford W. Wade and Robert A. Yost. Communications of the ACM. 24(10): 632 - 646. 1981. Also in Red Book (3rd ed).
[pdf]