DM26, Fall 2004 - Weekly Note 8

Lecture October 27

Start on second part of the course (DBMS implementation): Data storage in a DBMS.

Reading

Ramakrishnan and Gehrke: Section 8.1, Chapter 9.

Lecture November 3 (Expected Contents)

Indexes.

Reading

Ramakrishnan and Gehrke: Sections 8.2-5, Chapters 10 and 11.

Exercises November 1

Exercises 6.1, 6.8 (note that test data for this exercise was given on Weekly Note 4, so you can easily test your code), 6.9 (same note), 9.2, 9.4, 9.5, 9.6 (only question 5 and 6) in Ramakrishnan and Gehrke.

Exercises November 8

Exercises 8.1, 9.13, 9.14, 9.15, 8.2, 8.9, 8.11, 10.1 (only questions 1, 2, and 3), and 10.3 in Ramakrishnan and Gehrke.