Announcements:

Course Goals:

The objective is to understand the theoretical underpinnings as well as the implementation techniques of the different components of a Database System, with special emphasis on Distributed Databases. The course will also touch upon Data Streams and Data Processing in Cloud Computing.

Pre-requisites:

Previous enrollment in CS 430 or Permission of the Instructor.

Textbooks:

Recommended

Papers:

This will contain a set of papers used to augment your class notes.

Topics to be covered:

 

Topic

Reading
Introduction  Notes
Query Processing (Ram. Ch. 12,14,15)
Centralized Concurrency Control (Bern Ch.2,3,4,5)
Centralized Recovery (Bern. Ch.6)
Distributed Query Processing (Ozsu Ch.6,7,8)
Distributed Concurrency Control (Ozsu Ch. 11)
Distributed Recovery (Ozsu Ch. 12)
Access Control in Databases (Ozsu Ch. 5) & Papers
Replicated Databases (Bern. Ch. 8, Ozsu Ch. 13) & Papers
Mobile Database Systems Papers
Peer-to-Peer Data Management (Ozsu Ch. 16)
Data Streams (Ozsu Ch. 18) & Papers
Data Management in Cloud Computing (Ozsu Ch. 18) & Papers

Lecture Notes:

The lecture notes are available via RamCT. Please login using your eID and password. Prior to the start of the on campus class (meets on Tuesdays and Thursdays from 11:00 to 12:15), the initial set of slides for the lecture will be posted. The final slides for each lecture in tune with the video recording will be posted within 24 hours after the lecture has been conducted. The lecture notes are given in a portable document format. In order to view them, you need an Adobe Acrobat Reader.

Assignments:

The assignments are given in a portable document format. To view the assignments you need an Adobe Acrobat Reader.

Term Paper:

Each student must write a technical term paper. The student can work on any topic of his/her choice but it must be approved by the instructor. Some suggestions:

Examinations:

There will be two examinations: one midterm and one final. The examinations are open book and based on the materials covered in class. Make-up exams will be given only in exceptional cases.

Grading Policy:

The breakdown of the grades is as follows:
 
Term Paper  30%
Assignment  20%
Midterm   20%
Final 30%

Late Policy:

There is no late policy. Your project/term paper is due before class on the due date. The due date may be extended only under exceptional circumstances.

Honor Code:

Instructor Information:

Important Dates:

Useful Links: