DM26, Fall 2006 - Weekly Note 13

Lecture December 1

More algorithms for evaluating relational operators. Query optimization.

Reading

Ramakrishnan and Gehrke: Rest of Chapter 14, Sections 15.1-2 and 15.4.

Lecture December 8 (Expected Contents)

A bit more on query optimization. Transactions and concurrency control.

Reading

Ramakrishnan and Gehrke: Rest of Chapter 15. Sections 16.1-6 and 17.1-4.

Exercises December 11

Exercises 12.5, 14.1 (only questions 2, 4, 5, 6, 7, and 8), 14.2, 14.4 (only questions 1 to 4), 14.5 (the query referred to is from Exercise 14.4), 15.3 (only questions 1, 3, and 5), and 15.5 in Ramakrishnan and Gehrke.