CSE logo University of Washington Department of Computer Science & Engineering
 CSE444 Fall 2002
  CSE Home   About Us    Search    Contact Info 

Administration
 Home Page
 Syllabus
 Calendar/Lecture Notes
 Email archive
 Alternative Archive option
Project
 Description
 Resources
Homeworks
 Assignments and Solutions
Exams
   

Daily Schedule for 444

Note that this schedule will be altered during the quarter. Please make sure to check it every week.

Key:

  • Lecture topic
  • Reading assignment
  • Homework information
  • Project milestones
  • Special events

Week of Monday Wednesday Friday
September 30 Introduction
ppt  ps  pdf*
SQL
Sql for Web Nerds
ppt  ps  pdf (revised)
SQL
Sql for Web Nerds--ch3
ppt  ps  pdf (revised)
October 7 SQL
ppt  ps  pdf
6.2.5,6.4.2; 6.3; 6.4.3-6.4.6
M1: Project groups formed
SQL
ppt  ps  pdf
Homework Notes
6.1.6,6.3.8; 6.5; 6.6;6.7
  SQL System Aspects
ppt  ps  pdf
6.7;7
October 14 Data Modeling: E/R Diagrams
ppt  ps  pdf
8.1;8.6
HW1 due
E/R Diagrams Continued
ppt  ps  pdf
2;3.2;3.3
 
  Functional Dependencies/Normalization
ppt  ps  pdf
2;3.1-3.4
 
October 21 Relational Algebra
ppt  ps  pdf
3.4-3.6
M2: E/R, Create/populate database,
access db through dumb Website
XML and Semistructured Data
ppt  ps  pdf
3.6;5.2;5.3*;5.4*
HW2 due
 
XML,XPath and XQuery
ppt  ps  pdf
5.2-5.4; 4.6; 4.7
Additional Readings
October 28 XQuery
ppt  ps  pdf (updated)
Lecture 12 Readings
XML Publishing and Storage
ppt  ps  pdf
MIDTERM
HW3 due
November 4 Project Help
ppt
Implement the Week View
Data Storage
ppt  ps  pdf
Data Storage
ppt  ps  pdf
November 11 Veteran's Day B Trees
ppt  ps  pdf
Add user authentication
Hash Tables
ppt  ps  pdf
November 18 Query Execution
ppt  ps  pdf
Hwk4 due
Query Execution
ppt  ps  pdf
Query Execution
ppt  ps  pdf
November 25 Query Optimization
ppt  ps  pdf
Query Optimization
ppt  ps  pdf
Implement Week Web service
Thanksgiving
December 2 Query Optimization
ppt  ps  pdf
Query Optimization
ppt  ps  pdf
Transactions
ppt  ps  pdf
Project Demo Instructions
December 9
ppt  ps  pdf
HW5 due
Project demos (*Tuesday*)
ppt  ps  pdf
FINAL

*Other formats for the slides could be made available given enough interest. Contact your TAs with such requests.
* Read on your own, not covered in lecture

Additional Materials

Homework 1 Notes ppt  ps  pdf

Additional Readings

http://www.w3.org/XML/1999/XML-in-10-points
www.zvon.org/xxl/XMLTutorial/General/book_en.html

Readings for Lecture 12

XPath:
http://java.sun.com/webservices/docs/ea2/tutorial/doc/JAXPXSLT2.html

XQuery:
http://www.w3.org/TR/xmlquery-use-cases/
http://www.xmlportfolio.com/xquery.html


CSE logo Department of Computer Science & Engineering
University of Washington
Box 352350
Seattle, WA  98195-2350
(206) 543-1695 voice, (206) 543-2969 FAX
[comments to yana[at]washington.edu]