Course Schedule and Notes

Attention: The information contained in this page is subject to changes.

Week

Lecture 
Dates

Topics

Summary

Notes(Hector) 

1

1/06
1/08

Introduction
Hardware

 

2

1/13
1/15

Disk Organization

Indexing(1)

3

1/20
1/22

Indexing(2)

Index and Hashing

 

4

1/27
1/29

Hashing

Hashing + Query Processing

 

5

2/03
2/05

Query Processing + Optimization

Query Optimization + Buffer Management

 

6

2/10
2/12

Midterm1 review

Midterm1

04-11.review.ppt

04-11.review.pdf

 

 

7

2/17
2/19

Midterm Evaluation + Failure Recovery (1)

Failure Recovery (2)

04-12.midterm1.pdf

8

2/24
2/26

Concurrency Control (1)

Concurrency Control (2) (project phase I report due by midnight)

 

9

3/02
3/04

Concurrency Control (3)

Transaction Management

10

3/09
3/11

Spring Break

 

 

11

3/16
3/18

Distributed DB(Guest Speaker: Lakshmish Ramaswamy)

Data Mining & Data Warehousing(Guest Speaker: James Caverlee)

12

3/23
3/25

Database Security

Midterm2 review

04-21.DBsecurity.pdf

04-22.review2.pdf

 

 

13

3/30
4/01

Midterm2

Peer-to-Peer Data Management (Guest Speaker: Prof. Brian Cooper)

 

14

4/06
4/08

Midterm Evaluation + Mobile Data Management

Search Engines: the state of art

04-25.midterm2.pdf

Lec22-note

 

 

15

4/13
4/15

Final-review

Project Presentation(group 1, 10)

04-26.finalreview.pdf

 

16

4/20
4/22

Project Presentation(group 2, 4, 5, 7)

Project Presentation(group 3, 6, 8, 9)

Demo(Project Report Due)

 

 

17

4/26

Final Exam (4/26,Monday,11:30am-2:20pm, CCB102)

 

 

18

 

End of Term, Grades Available