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 [hard copies will be given in class].
- 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 (we will not discuss them in class):
- Unlike "additional resources" that will directly help you understand the material we cover in class, "optional, additional readings" are only there if you are interested in a topic and would like to read more about it.
- 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]