ICS 321 Data Storage and Retrieval (Fall 2013 CRN 71688)

General Information

Topics

Grading (Tentative)

Class Schedule (tentative)

Week Date Topic Readings Remarks
  Mon Aug 26 Course Organization   slides (pdf).
1 Wed Aug 28 The Worlds of Database Systems Ch 1. slides (pdf). Exercise 1 (pdf).
2 Mon Sep 2 Labor Day Holiday   Quiz 1 due on Tue 1130h
2 Wed Sep 4 The Relational Model of Data Ch 2. slides (pdf). Exercise 2 (pdf).
3 Mon Sep 9 The Relational Model of Data Ch 2. slides (pdf). Exercise 3 (pdf). (html).
3 Wed Sep 11 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 4 (pdf).
4 Mon Sep 16 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 5 (pdf).
4 Wed Sep 18 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 6 (pdf).
5 Mon Sep 23 High-Level Database Models Ch 4. slides (pdf). Exercise 7 (pdf).
5 Wed Sep 25 Algebraic and Logical Query Languages Ch 5. slides (pdf). slides (pdf). Exercise 8 (pdf).
6 Mon Sep 30 The Database Language SQL Ch 6. Exercise 9 (pdf). slides (pdf). Exercise 10 (pdf).
6 Wed Oct 2 Pre-Midterm Review    
7 Mon Oct 7 Midterm Exam    
7 Wed Oct 9 The Database Language SQL Ch 6. slides (pdf). Exercise 11 (pdf).
8 Mon Oct 14 The Database Language SQL Ch 6. slides (pdf). Exercise 12 (pdf).
8 Wed Oct 16 SQL in a Server Environment Ch 9. slides (pdf). sqc (zip).
9 Mon Oct 21 SQL in a Server Environment Ch 9. slides (pdf). odbc (zip). jdbc (zip).
9 Wed Oct 23 Post-Midterm Review    
10 Mon Oct 28 Constraints, Triggers, Views and Indexes Ch 7., Ch 8 slides (pdf). Exercise 14 (pdf).
10 Wed Oct 30 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 15 (pdf).
11 Mon Nov 4 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 16 (pdf).
11 Wed Nov 6 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf).
12 Mon Nov 11 Veterans Day Holiday    
12 Wed Nov 13 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. Exercise 17 (pdf).
13 Mon Nov 18 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 18 (pdf).
13 Wed Nov 20 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. slides (pdf). Exercise 19 (pdf).
14 Mon Nov 25 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. Exercise 20 (pdf).
14 Wed Nov 27 The Semi-structured Data Model & Programming Languages for XML Ch 11.,Ch 12. slides (pdf). Exercise 21 (pdf).
15 Mon Dec 2 Data Warehousing & Other Topics    
15 Wed Dec 4 Final Exam Review & Project Presentations   mock final (pdf).
16 Mon Dec 9 Project Presentations    
16 Wed Dec 11 Project Presentations    

Software Setup

Other Readings

Videos

Useful Links