ICS 321 Data Storage and Retrieval (Fall 2012)

General Information

Topics

Grading (Tentative)

Class Schedule (tentative)

Week Date Topic Readings Remarks
1 Mon Aug 20 Course Organization   slides (pdf)
1 Wed Aug 22 The Worlds of Database Systems Ch 1. slides (pdf). Exercise 1 (pdf).
2 Mon Aug 27 The Relational Model of Data Ch 2. Quiz 1 due. slides (pdf). Exercise 2 (pdf).
2 Wed Aug 29 The Relational Model of Data Ch 2. slides (pdf). Exercise 3 (pdf). (html).
3 Mon Sep 3 Labor Day Holiday   Quiz 2 due on Tue 11:30am
3 Wed Sep 5 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 4 (pdf).
4 Mon Sep 10 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 5 (pdf). Soln(txt). Quiz 3 due.
4 Wed Sep 12 Design Theory for Relational Databases Ch 3. slides (pdf). Exercise 6 (pdf).
5 Mon Sep 17 High-Level Database Models Ch 4. Assignment 1 due at 5PM. slides (pdf). Exercise 7 (pdf). Quiz 4 due.
5 Wed Sep 19 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 8 (pdf).
6 Mon Sep 24 Algebraic and Logical Query Languages Ch 5. slides (pdf). Exercise 9 (pdf). Quiz 5 due.
6 Wed Sep 26 The Database Language SQL Ch 6. slides (pdf). Exercise 10 (pdf). Assignment 2 due 2200.
7 Mon Oct 1 Pre-Midterm Review   Quiz 6 due. mock-midterm(pdf).
7 Wed Oct 3 Midterm Exam    
8 Mon Oct 8 Post-Midterm Review   Quiz 7 due.
8 Wed Oct 10 The Database Language SQL Ch 6. slides (pdf). Exercise 11 (pdf). Project Proposals due 2355.
9 Mon Oct 15 The Database Language SQL Ch 6. slides (pdf). Exercise 12 (pdf). data(zip). Quiz 8 due.
9 Wed Oct 17 SQL in a Server Environment Ch 9. slides (pdf). Networking Intro(pdf). sqc (zip).
10 Mon Oct 22 SQL in a Server Environment Ch 9. slides (pdf). Exercise 13 (pdf). odbc (zip). jdbc (zip). Quiz 9 due.
10 Wed Oct 24 Constraints, Triggers, Views and Indexes Ch 7., Ch 8 slides (pdf). Exercise 14 (pdf).
11 Mon Oct 29 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 15 (pdf). Quiz 10 due. http://www.youtube.com/watch?v=AKJ9BMWIPiY http://www.youtube.com/watch?v=2RxXrMtj2bs
11 Wed Oct 31 Overview of Transaction Processing Ch 18.{0-2}, Ch 17.1. slides (pdf). Exercise 16 (pdf). http://www.youtube.com/watch?v=zYzqKHhxDBM http://www.youtube.com/watch?v=NcwRurRueYA
12 Mon Nov 5 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. slides (pdf). Exercise 17 (pdf). Quiz 11 due.
12 Wed Nov 7 Overview of Storage and Indexing Ch 13.{0-2}, Ch 14.{0-2}. Project Progress Report due. slides (pdf). Exercise 18 (pdf).
13 Mon Nov 12 Veteran's Day Holiday    
13 Wed Nov 14 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. slides (pdf). Exercise 19 (pdf).
14 Mon Nov 19 Overview of Query Processing Ch 16.1, Ch 15.{0-3}. Exercise 20 (pdf).
14 Wed Nov 21 The Semi-structured Data Model & Programming Languages for XML Ch 11.,Ch 12. slides (pdf). Exercise 21 (pdf).
15 Mon Nov 26 Special Topics   ics321-23-other.
15 Wed Nov 28 Project Presentation    
16 Mon Dec 3 Project Presentation    
16 Wed Dec 5 Final Exam Review   mock-final(pdf).

Software Setup

Other Readings

Videos

Useful Links