|
|
|
* GMUW refers to the required textbook by Garcia-Molina, Ullman, and Widom.
| Week | Date | Topic | Reference* |
| 1 | 08-25 |
Introduction |
|
| 08-27 |
Relational model and algebra |
GMUW 3.1, 5.1, 5.2 |
| 08-29 |
More relational algebra |
| 2 | 09-01 |
Database design in E/R model |
GMUW 2, 3.2, 3.3 |
| 09-03 |
More database design in E/R model |
| 3 | 09-08 |
Relational database design theory |
GMUW 3.4-3.6 |
| 09-10 |
SQL: basics |
GMUW 6.6.1, 6.6.2, 6.1.1-6.1.4, 6.1.7, 6.2, 6.4.1, 6.4.2 |
| 4 | 09-15 |
SQL: subqueries, aggregation, grouping, NULL's, outerjoins |
GMUW 6.3, 6.4.3-6.4.6 |
| 09-17 |
SQL: modifications, constraints, triggers |
GMUW 6.1.5, 6.1.6, 6.5, 7.1, 7.2, 7.4 |
| 5 | 09-22 |
SQL: views, indexes, transactions |
GMUW 6.6.5, 6.6.6, 6.7, 8.6 |
| 09-24 |
SQL: programming |
GMUW 8.1-8.5 |
| 6 | 09-29 |
SQL: recursion |
GMUW 10.4 |
| 10-01 |
More relational database deisgn theory |
GMUW 3.7 |
| 7 | 10-06 |
Student presentation: keyword search on relational databases |
|
| 10-08 |
Midterm exam (in class) |
|
| 8 | 10-13 |
Fall break |
|
| 10-15 |
XML and DTD |
W3C XML/DTD standards |
| 9 | 10-20 |
XPath and XQuery |
W3C XPath and XQuery standard |
| 10-22 |
XSLT |
W3C XSLT standard |
| 10 | 10-27 |
SAX and DOM |
SAX and DOM standards |
| 10-29 |
Supporting XML in relational databases |
|
| 11 | 11-03 |
Physical data organization |
GMUW 11.2, 11.3, 12 |
| 11-05 |
Indexing |
GMUW 13 |
| 12 | 11-10 |
Query processing |
GMUW 15.1-15.6 |
| 11-12 |
More query processing |
| 13 | 11-17 |
Query optimization |
GMUW 16.2, 16.4-16.6 |
| 11-19 |
Transaction processing |
GMUW 18.1-18.5, 17.1-17.4 |
| 14 | 11-24 |
Slack day |
|
| 11-26 |
Thanksgiving recess | |
| 15 | 12-01 |
Student presentation: stream data processing |
|
| 12-03 |
Student presentation: semantic Web |
|
| 16 | 12-13 |
Final exam (Saturday 2-5pm) | |
|