Temple University Home     CIS Home 

 
 

CIS 9616 Course Schedule

This is the planned schedule, but it may change.

Readings are listed on the day they are due.

Week Lecture (Monday) Handouts & Resources
Week 1:
1/21-1/25 		No Class

(Martin Luther King, Jr. Day) 		Course Syllabus
Week 2:
1/28-2/1 		Introduction to Databases

The Relational Model

Reading: Chapters 1 and 2
Week 3:
2/4-2/8 		SQL

Reading: Chapter 3
Week 4:
2/11-2/15 		Advanced SQL

Reading: Chapter 4
Week 5:
2/18-2/22 		Relational Database Design

The Entity-Relationship Model

 Reading: Chapters 6 and 7
Week 6:
2/25-2/29 		Database Application Design

Reading: Chapters 8 and 10 		Database Design Slides (by Magda Balazinska)
Week 7:
3/3-3/7 		Database Architecture

Storage and Indexing

Reading: Two papers, available on Blackboard

Background Reading: Section 1.11 and 12.1-12.8 in Textbook 		DBMS Architecture Slides (by Magda Balazinska)

Storage and Indexing Slides (by Magda Balazinska)

Query Execution Slides (by Magda Balazinska)
Week 8:
3/10-3/14 		Spring Break!
Week 9:
3/17-3/21 		Query Execution and Optimization

Reading: Three papers available on Blackboard

Background Reading: Chapters 13 & 14 		Operator Algorithm Slides (by Magda Balazinska)

Query Optimization Slides (by Magda Balazinska)
Week 10:
3/24-3/28 		Transactions

Reading: One paper available on Blackboard

Background Reading: Chapters 15-17 		Concurrency Control Slides (by Magda Balazinska)

Recovery Slides (by Magda Balazinska)
Week 11:
3/31-4/4 		Midterm

No Reading
Week 12:
4/7-4/11 		Distributed Databases

Reading: two papers available on Blackboard

Background Reading: Chapters 20 and 22 (optional) 		Distributed Query Optimization Slides (by Magda Balazinska)

Distributed Transaction Slides (by Magda Balazinska)
Week 13:
4/14-4/18 		Guest Lecture: Yuan Shi

Parallel Architectures

Background Reading: Chapter 21 (optional) 		Replication Slides (by Magda Balazinska)
Week 14:
4/21-4/25 		Data Warehousing and Mining

Reading: 1 paper available on Blackboard

Background Reading: Chapter 18 (optional) 		Data Warehousing Slides (by Magda Balazinska)
Week 15:
4/28-5/2 		Natural Language and Databases

Information Extraction and Retrieval

Reading: 2 papers available on Blackboard

Background Reading: Chapter 19 (optional)
Week 16:
5/5-5/9 		Project Presentations

No Reading