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.

Location and Times:

Lecture: 11:00 to 12:15   on  Tuesday and Thursday at CSB 325

Pre-requisites:

Previous enrollment in CS 430 or Permission of the Instructor.

Textbooks:

Recommended

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:

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 will be posted within 24 hours after the lecture has been conducted. The lecture notes are given in a portable document format. 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.

Grading Policy:

The breakdown of the grades is as follows:
 
Class Participation 10%
Term Paper  40%
Assignment   10%
Midterm I   20%
Midterm II 20%
A publishable quality term paper automatically gets you an A in the course.

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:

Term Paper Presentation:

Each student has to prepare a 15 minute presentation to the class describing his/her work. This includes time for questioning.

Publications resulting from Term Papers:

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.

Examinations:

There will be two midterm examinations. The examinations will be posted one week prior to due date. The examinations are open book and based on the materials covered in class.

Honor Code:

Instructor Information:

Important Dates:

Useful Links: