CS554 Database Systems

[Home] [Schedule] [Assignments] [Project] [Share Directory] [Resources]

 


Schedule

Week#

Date

Lecture / Topics

Lecture Notes

Readings

1

09/05/06

Introduction and Course Information

1.Intro

Chap 1

09/07/06

Data Storage: Disk I/O

2.DiskIO

Chap 11

2

09/12/06

Data Storage: Data Representation and Disk Organization

3.DiskOrg

Chap 12

09/14/06

Data Storage: Indexing: Conventional Indexing

4.IndexingI

Chap 13

3

09/19/06

Data Storage: Indexing: Tree Indexing and Hash Indexing

5.IndexingII

Chap 13

09/21/06

Data Storage: Indexing: Multi-Dimensional Indexing

6.IndexingIII

Chap 14

4

09/26/06

Query Processing: Logical Query Plan and External Sort

7.QueryI

Chap 16, 15

09/28/06

Query Processing: Implementing Relational Operators – Join

8.QueryII

Chap 15

5

10/03/06

Query Processing: Query Optimization

9.QueryIII

Chap 16

10/05/06

Research Topics (Student Presentation): Multidimensional K-Anonymity (James Gardner); P2P Multidimensional Query (Pawel Jurczyk)

Mondrian Supporting

lefevre06mondrian liu05supporting

6

10/10/06

Fall Break

 

 

10/12/06

Transaction Management: Recovery

10.Recovery

Chap 17

7

10/17/06

Transaction Management: Concurrency Control

11.ConcurrencyI

Chap 18

10/19/06

Transaction Management: Concurrency Control (cont.)

12.ConcurrencyII

Chap 18

8

10/24/06

Transaction Management: Recoverability and View Serializability

13.Transaction

Chap 19

10/26/06

Midterm

 

 

9

10/31/06

Distributed Databases: Distributed Database Design

14.DistributedDB

 

11/02/06

Distributed Databases: Distributed Query Processing

15.DistributedQP

mackert86r

10

11/07/06

Distributed Databases: Distributed Transaction Management

16.DistributedTM

Chap 19

11/09/06

Guest Lecture: Text Management in DBMS, Eugene Agichtein

TextManagement

 

11

11/14/06

Object Databases and Semi-Structured Data

17.ObjectXML

Chap 4, 9

11/16/06

Research Topics (Student Presentation): RankSQL (Sarah Knepper), ULDB (Sam Hawkins)

RankSQL     ULDB

li05ranksql benjelloun06uldbs

12

11/21/06

Research Topics (Student Presentation): Distributed Database Services (Kumudha Rangachari); PeerDB (Dan Dougherty)

 

aggarwal05two ng03peerdb

11/23/06

Thanksgiving Break

 

 

13

11/28/06

Data Privacy and Security

18.Security

 

11/30/06

Data Integration and Emerging Applications

19.Applications

 

14

12/05/06

End of Semester Break

 

 

12/07/06

Student Project Workshop: Sarah Knepper, Pawel Jurczyk, James Gardner

 

 

15

12/12/06

Student Project Workshop: Kumudha Rangachari, Dan Dougherty, Sam Hawkins