CSI 3317 -- Notes

The notes are copyrighted and adapted from Ramakrishnan and Gehrke's original notes; therefore they are intended for your private use. Never redistribute them 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): notes -- Sept 09 2005
2. The Entity-Relationship Model (RG Chap 2, 2.1--2.6,2.8): notes -- Sept 13 2005
3. The Relational Model (RG Chap 3): notes -- Sept 16&20 2005
4. Algebra and Relational Calculus (RG Chap 4):
   • notes: Algebra -- Sept 23 2005
   • notes: Relational Calculus -- Sept 27 2007
5. SQL: Queries, Constraints, and Triggers (RG Chap 5): notes -- Oct 4 & 7 & 11 2005 further notes on constraints and triggers -- Oct 11 2005
6. Database Application Development (RG Chap 6):
   • Sections 6.1--6.3 -- Oct 18 2005
   • Sections 6.4--6.5 -- Oct 18 2005
7. Internet Applications (RG Chap 7):
   • notes Sections 7.1--7.5 -- Oct 25 2005
     
   • notes Section 7.5--7.8 -- Oct 25 2005
8. Storage and indexing (RG Chap 8-11):
   • Overview -- Chap 8 -- Nov 1 & 4 2005
   • Disks and Files (Chap 9) -- Nov 8 2005
   • Topics in tree and hash indexes -- Nov 5 2005 (We'll cover only Sections 10.2, 10.3, and 10.8; Sections 11.1 and 11.2, the later if time permits)
9. Query processing (RG Chap 12, and selected sections of 13-14):
   • Overview -- Chap 12 -- Nov 15 2005
   • Selected topics (Sections 13.3, 13.5, 14.4.1-3) -- Nov 18 2005
10. Transaction processing (Chap 16; Sections of Chap 17,18)
    • Overview -- Chap 16 -- Nov 22 2005
    • Selected topics: 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 -- Nov 25 2005