|
|
|
* GMUW refers to the book by Garcia-Molina, Ullman, and Widom.
| Week | Date | Topic | Reference* |
| 1 | 08-30 | Introduction | |
| 09-01 | Relational model & algebra | GMUW 3.1, 5.1, 5.2 |
| 2 | 09-06 | Database design in E/R model | GMUW 2 |
| 09-08 | Database design: E/R and relational translation | GMUW 3.2, 3.3 |
| 3 | 09-13 | Database design theory | GMUW 3.4-3.6.5 |
| 09-15 | SQL: basics, subqueries, aggregation | GMUW 6.6.1, 6.6.2, 6.1 (except 6.1.5, 6.1.6), 6.2, 6.3 (up to 6.3.5), 6.4 |
| 4 | 09-20 | SQL: NULL, outerjoin, modifications, constraints | GMUW 6.1.5, 6.1.6, 6.3.8, 6.5, 7.1, 7.2, 7.4.1 |
| 09-22 | SQL: triggers, views | GMUW 7.4.2, 7.4.3, 6.7 |
| 5 | 09-27 | SQL: indexes, transactions | GMUW 6.6.5, 6.6.6, 8.6 |
| 09-29 | SQL: programming | GMUW 8.1-8.5 |
| 6 | 10-04 | SQL: recursion | GMUW 10.4 |
| 10-06 | Midterm exam (in class) | |
| 7 | 10-11 | Fall break | |
| 10-13 | More database design theory | GMUW 3.6.6, 3.7 |
| 8 | 10-18 | XML, DTD, XPath | W3C XML/DTD and XPath standards |
| 10-20 | XQuery | W3C XQuery standard |
| 9 | 10-25 | XSLT | W3C XSLT standard |
| 10-27 | SAX & DOM | SAX and DOM standards |
| 10 | 11-01 | XML-relational mapping | |
| 11-03 | Physical data organization | GMUW 11.2, 11.3, 12 |
| 11 | 11-08 | Indexing | GMUW 13 |
| 11-10 | Indexing for Web searches | |
| 12 | 11-15 | Query processing | GMUW 15.1-15.6 |
| 11-17 | More query processing |
| 13 | 11-22 | Query optimization | GMUW 16.2, 16.4-16.6 |
| 11-24 | Thanksgiving recess | |
| 14 | 11-29 | Transaction processing | GMUW 18.1-18.6, 17.1-17.4 |
| 12-01 | Beyond traditional databases | |
| 15 | 12-06 | Beyond traditional databases | |
| 12-08 | Review | |
| 16 | 12-13 | Final exam (7pm-10pm) | |
|
