Course Schedule and Notes

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

                            Please visit in the morning of a lecture day for up-to-date materials)

 

Week

Lecture 
Dates

Topics

Summary

Notes(Hector) 

1

1/11
1/13

Introduction
Hardware

2

1/18
1/20

Hardware (cont.) + Disk Organization

Disk Organization

3

1/25
1/27

Indexing(1)
Indexing(2)

 

4

2/1
2/3

2/3

Hashing

Hashing + Multidimentional Indexing

Project group Name List Due

 

5

2/08
2/10

Query Processing + Optimization

 

 

 

6

2/15
2/17

Midterm1 review

Midterm1

 

 

 

7

2/22
2/24

Midterm Evaluation + Project Phase I discussion

Cost based Query Optimization – Estimating I/Os

12.Proj-PhaseI+II.pdf

13.QOptIOcost

Notes07

 

8

3/1
3/3

Query Execution Algorithms

Multidimensional Indexes

Project Phase I report due by midnight

9

3/08
3/10

Failure Recovery

Concurrency Control (1)

16.Notes08+

17.CC.pdf

 Notes08 

 Notes09


Notes10

10

3/15
3/17

Concurrency Control (2)

Concurrency Control (3)

18.CC2.pdf

19.CC3.pdf

 Notes09

 

11

3/21-
3/25

Spring Break

 

 

12

3/29
3/31

Midterm2 review

Midterm2

 

 

13

4/05

4/07

 

Midterm 2 summary + Database Security

Distributed Databases and and Heterogeneous DBs

 

21.midterm2.pdf + 21.DBsecurity.pdf

Notes11
Notes13
Notes14

14

4/12
4/14

Data Mining & Data Warehousing

Mobile Data Management

15

4/19
4/21

Final-review

 

16

4/26
4/28

Demo + Project Report Due by 4/29

 

 

17

5/2

Final Exam (Monday,11:30am-2:20pm, IC 117)

 

 

18

5/3

End of Term, Grades Available