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.
- Overview of DBMSs (RG Chap 1):
slides -- Sept 12, 2006
- The Entity-Relationship Model (RG Chap 2, 2.1--2.6,2.8):
slides -- Sept 15, 2006
- The Relational Model (RG Chap 3):
slides -- Sept 19 & 22, 2006
- Algebra and Relational Calculus (RG Chap 4):
- Algebra:
slides -- Sept 25, 2006
- Calculus:
slides -- Sept 29 / Oct 2, 2006
- SQL: Queries, Constraints, and Triggers (RG Chap 5):
slides-1;
slides-2
-- Oct 5, 9 and 12, 2006
- Database Application Development (RG Chap 6):
-
slides Sections 6.1--6.3 -- Oct 27, 2006
-
slides Sections 6.4--6.5 -- Oct 31, 2006
- Internet Applications (RG Chap 7):
- slides
Sections 7.1--7.5 -- Nov 3, 2006
- slides
Section 7.5--7.8 -- Nov 7, 2006
- 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
- Query processing (RG Chap 12, and selected sections of Chap 14):
slides
-- Nov 21, 2006
- 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