1

CMPSCI 645: Database Design and Implementation

subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link | subglobal1 link
subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link | subglobal2 link
subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link | subglobal3 link
subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link | subglobal4 link
subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link | subglobal5 link
subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link | subglobal6 link
subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link | subglobal7 link
subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link | subglobal8 link

Schedule (subject to change)


week date day topic textbook slides homework
paper
project
Week 1
Jan 29 Tu Course Intro
Ch. 1
Jan 31 Th

Relational Model and Algebra

Ch. 4
Week 2
Feb 5 Tu Project Discussion
-
Feb 7 Th SQL
Ch. 5.
Week 3
Feb 12 Tu SQL
Ch. 5.
Feb 14 Th Data Modeling
Ch. 2, 19

pdf

pdf

Form Groups
Week 4
Feb 19 Tu No Class (Monday Schedule)
-
Feb 21 Th Theory 1
Week 5
Feb 26 Tu Theory 2
Feb 28 Th

Storage Indexing Overview

Ch. 8
Week 6
Mar 4 Tu Storage
Ch. 8, 9
Proposal
Mar 6 Th Hash and Tree Indexes
Ch. 10,11
Week 7
Mar 11 Tu Query Evaluation
Ch. 13,14
Mar 13 Th Query Evaluation
Ch 13,14
Week 8
Mar 18 Tu spring break      
Mar 20 Th
Week 9
Mar 25 Tu Query Optimization
Mar 27 Th Query Optimization
Week 10
Apr 1 Tu Transaction Management
Ch. 16,17
Apr 3 Th Transaction Management
Ch. 16,17
Week 11
Apr 8 Tu Transaction Management
Ch. 8
Midterm Report
Apr 10 Th Security
Week 12
Apr 15 Tu Security
Apr 17 Th No Class + Midterm 7PM (LGRT 117)
Week 13
Apr 22 Tu XML
Apr 24 Th XML
Week 14
Apr 29 Tu Incomplete/Probabilistic DBs
May 1 Th Parallel Databases
Week 15
May 6 Tu Column-oriented DBs (Guest Lecturer - Shilpa Lawande, Meets in CS 151)
May 8 Th Project Presentations
Presentation
Week 16
May 13 Tu Project Presentations (Extended 11am - 1pm, meets in CS 150)
Presentaion
May 15 Th
Week 17 May 20 Tu
Project Reports Due