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.
- Overview of DBMSs (RG Chap 1):
notes -- Sept 09 2005
- The Entity-Relationship Model (RG Chap 2, 2.1--2.6,2.8):
notes -- Sept 13 2005
- The Relational Model (RG Chap 3):
notes -- Sept 16&20 2005
- Algebra and Relational Calculus (RG Chap 4):
- SQL: Queries, Constraints, and Triggers (RG Chap 5):
notes -- Oct 4 & 7 & 11 2005
further
notes on constraints and triggers -- Oct 11 2005
- Database Application Development (RG Chap 6):
- Internet Applications (RG Chap 7):
- Storage and indexing (RG Chap 8-11):
- Query processing (RG Chap 12, and selected sections of 13-14):
- 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