| Week | Date | Topic | Readings | Remarks |
|---|---|---|---|---|
| 1 | Mon Aug 22 | Course Organization | slides (pdf) | [v1] Data Explosion | |
| 1 | Wed Aug 24 | The Worlds of Database Systems | Ch 1. | slides (pdf) | Exercise 1 (pdf) |
| 2 | Mon Aug 29 | The Relational Model of Data | Ch 2. | Quiz 1 due. slides (pdf) | Exercise 2 (pdf) |
| 2 | Wed Aug 31 | The Relational Model of Data | Ch 2. |
slides (pdf) | Exercise 3 (html) |
| 3 | Mon Sep 5 | Labor Day Holiday | Quiz 2 due on Tuesday | |
| 3 | Wed Sep 7 | Design Theory for Relational Databases | Ch 3. |
Bring your laptops.
db2 commands (txt)
slides (pdf) | Exercise 4 (pdf) |
| 4 | Mon Sep 12 | Design Theory for Relational Databases | Ch 3. |
Quiz 3 due.
Bring back Exercise 4. slides (pdf) |
| 4 | Wed Sep 14 | Design Theory for Relational Databases | Ch 3. |
slides (pdf)
|
Exercise 5 (pdf)
Solutions to Ex 5 (txt) |
| 5 | Mon Sep 19 | Design Theory for Relational Databases | Ch 3. | Quiz 4 due. |
| 5 | Wed Sep 21 | High-Level Database Models | Ch 4. | slides (pdf) | Exercise 6 (pdf) |
| 6 | Mon Sep 26 | High-Level Database Models | Ch 4. | Quiz 5 due. Bring Ex 6 back. |
| 6 | Wed Sep 28 | Algebraic and Logical Query Languages | Ch 5. | slides (pdf) | Exercise 7 |
| 7 | Mon Oct 3 | Algebraic and Logical Query Languages | Ch 5. |
Quiz 6 due. slides (pdf) | Exercise 8 |
| 7 | Wed Oct 5 | Pre-Midterm Review | ||
| 8 | Mon Oct 10 | Midterm Exam | ||
| 8 | Wed Oct 12 | The Database Language SQL | slides (pdf) | |
| 9 | Mon Oct 17 |
Post-Midterm Review The Database Language SQL |
Ch 6. |
Quiz 7 due. Exercise 9 |
| 9 | Wed Oct 19 | The Database Language SQL | Ch 6. |
Bring your laptops. Bring back Ex 9. slides (pdf) | Exercise 10 |
| 10 | Mon Oct 24 | The Database Language SQL | Ch 6. |
Quiz 8 due.
Assignment 1 due. Bring back Ex. 10. slides (pdf) | Exercise 11 |
| 10 | Wed Oct 26 | The Database Language SQL Overview of Transaction Processing | Ch 6. Ch 18.{0-2}, Ch 17.1. | Bring back Ex. 11. slides (pdf) |
| 11 | Mon Oct 31 | Overview of Transaction Processing | Ch 18.{0-2}, Ch 17.1. | slides (pdf) |
| 11 | Wed Nov 2 |
Overview of Transaction Processing
SQL in a Server Environment |
Ch 9. | slides (pdf) | Exercise 12 | Exercise 13 |
| 12 | Mon Nov 7 |
SQL in a Server Environment Constraints, Triggers, Views and Indexes |
Ch 7., Ch 8 |
Quiz 10 due.
Assignment 3 due 2355 hours.
Exercise 14 (pdf) | sqc.zip (zip) | odbc.zip (zip) | jdbc.zip (zip) SQC Screencast for compiling and running the sqc sample program. JDK Screencast for installing jdk in ubuntu. ODBC Screencast for compiling and running the sample ODBC program. JDBC Screencast for compiling and running the sample JDBC program. Slides (pdf) | Exercise 15 (pdf) |
| 12 | Wed Nov 9 | Overview of Storage and Indexing | Ch 13.{0-2}, Ch 14.{0-2}. | Slides (pdf) | Exercise 16 (pdf) |
| 13 | Mon Nov 14 | Overview of Storage and Indexing | Ch 13.{0-2}, Ch 14.{0-2}. | Slides (pdf) | Exercise 17 (pdf) |
| 13 | Wed Nov 16 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3}. | Slides (pdf) | Exercise 18 (pdf) |
| 14 | Mon Nov 21 | Overview of Query Processing | Ch 16.1, Ch 15.{0-3}. | Exercise 19 (pdf) |
| 14 | Wed Nov 23 | The Semi-structured Data Model & Programming Languages for XML | Ch 11.,Ch 12. | Slides (pdf) | Exercise 20 (pdf) |
| 15 | Mon Nov 28 | Special Topics: unstructured data, graph structured data & key value stores | Slides (pdf) | TED talk Tim Berners Lee on LOD. | |
| 15 | Wed Nov 30 | Final Exam Review | Exercise 21 (pdf) | |
| 16 | Mon Dec 5 | Project Presentation | ||
| 16 | Wed Dec 7 | Project Presentation |