CSE444 Introduction to Database Systems - Fall 2005

CSE Home

About Us

Search

Contact Info

Administration  Home Page  Syllabus  Calendar/Lecture Notes  E-mail Archive  Project  Description  Resources Homeworks  Assignments and Solutions Exams  Problem sets and Solutions

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 26 Intro to DB Systems SQL October 3 SQL SQL SQL October 10 E/R Diagrams E/R Diagrams HW1 Due Database Design October 17 XML XPath/XQuery XQuery October 24 XML Publishing &  XML Storage Transactions in SQL HW2 Due Security October 31 MidTerm Review HW3 Part I Due Midterm Recovery November 7 No Lecture Notes Concurrency Control HW3 Part II Due Holiday November 14 Concurrency Control No Lecture Notes Indexes November 21 Relational Algebra Query Execution HW4 Due Holiday  November 28 Query Execution  Query Execution  Query Optimization December 5 Size/Cost Estimation   HW5 Due Optimizations with Semi-Joins * Read on your own, not covered in lecture Additional Readings Oct 21, 2005: Indexing XML Data Stored in a Relational Database Oct 28, 2005: Advanced SQL Injection in SQL Server Applications Department of Computer Science & Engineering University of Washington Box 352350 Seattle, WA  98195-2350 (206) 543-1695 voice, (206) 543-2969 FAX [comments to akgupta[AT]cs.washington.edu]