skip to: page content | links on this page | site navigation | footer (site information)

Schedule (subject to change)

week	date	day	topic	textbook	slides	homework	paper	project
Week 1	Jan 30	Tu	Course introduction	Ch 1
Week 1	Feb 1	Th	Data Modeling	Ch 2, 3
Week 2	Feb 6	Tu	Relational Algebra	Ch 4
Week 2	Feb 8	Th	SQL	Ch 5
Week 3	Feb 13	Tu	Overview of DB Storage	Ch 8		assignment 1
Week 3	Feb 15	Th	Disks & Buffers	Ch 9			DBMin
Week 4	Feb 20	Tu	Indexing 1	Ch 10, 11				groups formed
Week 4	Feb 22	Th	Indexing 2				R*-tree
Week 5	Feb 27	Tu	Query Processing 1	Ch 13, 14
Week 5	Mar 1	Th	Query Processing 2	Ch 14
Week 6	Mar 6	Tu	Query Processing 3	Ch 14				proposal due
Week 6	Mar 8	Th	Query Optimization 1	Ch 15			System R
Week 7	Mar 13	Tu	Query Optimization 2	Ch 15		assignment 2
Week 7	Mar 15	Th	Transaction Mgmt	Ch 16
Week 8	Mar 20	Tu	spring break
Week 8	Mar 22	Th	spring break
Week 9	Mar 27	Tu	Concurrency Control 1	Ch 17		Degrees of Consistency
Week 9	Mar 29	Th	Concurrency Control 2	Ch 17
Week 10	Apr 3	Tu	Recovery	Ch 18		assignment 3
Week 10	Apr 5	Th	Database Design	Ch 19
Week 11	Apr 10	Tu	Database Tuning	Ch 20
Week 11	Apr 12	Th	XML Basics	Ch 27
Week 12	Apr 17	Tu	Midterm (in the evening)
Week 12	Apr 19	Th	XML Query Language					project update
Week 13	Apr 24	Tu	XML Query Processing			assignment 4	DataGuides
Week 13	Apr 26	Th	Data Streams 1
Week 14	May 1	Tu	Data Streams 2
Week 14	May 3	Th	Views and Security 1
Week 15	May 8	Tu	Views and Security 2
Week 15	May 10	Th	Project Presentations 1					presentation
Week 16	May 15	Tu	Project Presentations 2					presentation
Week 16	May 17	Th
Week 17	May 22	Tu						final report due
Week 17	May 24	Th