CSI 3317 -- Notes

The notes are copyrighted. They are an adapted and largely modified personal version of Ramakrishnan and Gehrke's original notes; therefore they are intended for your private use and should not be redistributed in any form whatsoever.

To print these notes in a 4-on-one-page format, do the following: point the mouse on the open slides and click on the right mouse button; go to the print menu; in the menu "Print what", choose "handouts", then set the "Slides per page" value to 4; finally, hit the "ok" button.

1. Overview of DBMSs (RG Chap 1): slides -- Sept 12, 2006
2. The Entity-Relationship Model (RG Chap 2, 2.1--2.6,2.8): slides -- Sept 15, 2006
3. The Relational Model (RG Chap 3): slides -- Sept 19 & 22, 2006
4. Algebra and Relational Calculus (RG Chap 4):
   • Algebra: slides -- Sept 25, 2006
   • Calculus: slides -- Sept 29 / Oct 2, 2006
5. SQL: Queries, Constraints, and Triggers (RG Chap 5): slides-1; slides-2 -- Oct 5, 9 and 12, 2006
6. Database Application Development (RG Chap 6):
   • slides Sections 6.1--6.3 -- Oct 27, 2006
   • slides Sections 6.4--6.5 -- Oct 31, 2006
7. Internet Applications (RG Chap 7):
   • slides Sections 7.1--7.5 -- Nov 3, 2006
   • slides Section 7.5--7.8 -- Nov 7, 2006
8. Storage and indexing (RG Chap 8-11):
   • Overview (Chap 8): slides -- Nov 10, 2006
   • Disks and Files (Chap 9): slides -- Nov 14, 2006
   • Topics in tree and hash indexes -- Sections 10.2, 10.3, and 10.8: slides -- Nov 17, 2006
9. Query processing (RG Chap 12, and selected sections of Chap 14): slides -- Nov 21, 2006
10. Transaction processing (Chap 16; Sections of Chap 17,18)
    • Overview (Chap 16): slides -- Nov 28, 2006
    • Selected topics (Chap 17): slides -- Sections 17.1 (no 17.1.1), 17.2 (No latches and convoys), 17.3, 17.4, 17.6.1 (ignore "Improved conflict resolution"), 17.6.2 -- Dec 1, 2006