DM505, Spring 2006, 4th Quarter - Weekly Note 7

Thursday is a public holiday, and the lectures this day will be moved to the next week at

Wednesday, May 31, 12-14

Hence, there will be lectures Monday (May 22), and next Wednesday (May 31), and exercise classes Wednesday (May 24). For all classes, we meet at U2 unless you are otherwise notified.

Details of the exam will be given at the lecture Wednesday, and on the next Weekly Note.

Lecture May 17

More on tree index structures. Database application programming using JDBC. Stored procedures.

Reading

Chapters 8 and 10. Sections 6.3 and 6.5. Note on using JDBC with PostgreSQL at IMADA.

Lecture May 22 (Expected contents)

Index structures based on hashing. Start of concurrency control.

Reading

Chapter 11. Sections 16.1-4 and 17.1-2.

Lecture May 31 (Expected contents)

More on concurrency control. Discussion of oral exam.

Reading

Sections 16.5-6 and 17.3-5.

Exercises May 24

Exercises 11.1 (only questions 4, 5, and 7), 11.2 (only questions 4, 5, and 6), 11.7, 11.8, 16.1, 16.3, 17.2 (only questions 1, 2, 4, and 7), and 17.4 (only questions 1 and 2) in Ramakrishnan and Gehrke.