CS 533: Database Systems (Fall 2015)
- All important announcements will be posted here.
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.
Lecture: 11:00 to 12:15 on Tuesday and Thursday at
Previous enrollment in CS 430 or Permission of the Instructor.
Database Management Systems (Third Edition) by R. Ramakrishnan and J. Gehrke,
published by McGraw-Hill.
Control and Recovery in Database Systems by P.A. Bernstein, V.
Hadzilacos and N. Goodman, published by Addison-Wesley, 1987.
Principles of Distributed Database Systems by M. Tamer Ozsu and P. Valduriez,
Third Edition, published by Prentice Hall, 2011.
|Review of Query Processing
|| (Ram. Ch. 12,14,15)
|Review of Centralized Concurrency Control
|Review of Centralized Recovery
|Distributed Query Processing
|Distributed Concurrency Control
||(Ozsu Ch. 11)
||(Ozsu Ch. 12)
|Access Control in Databases
||(Ozsu Ch. 5) & Papers
||(Bern. Ch. 8, Ozsu Ch. 13) & Papers
|Mobile Database Systems
|Peer-to-Peer Data Management
||(Ozsu Ch. 16)
||(Ozsu Ch. 18) & Papers
|Data Management in Cloud Computing
||(Ozsu Ch. 18) & Papers
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
A publishable quality term paper automatically gets you an A in the course.
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.
Each student has to prepare a 15 minute presentation to the class describing
his/her work. This includes time for questioning.
- Indrakshi Ray and Tai Xin, Concurrent and Real-Time Update of Access
Control Policies, Proceedings of the 14th International Conference on
Database and Expert Systems, Prague, Czech Republic, September 2003.
- Indrakshi Ray, Ross M. McConnell, Monte Lunacek, and Vijay Kumar,
Reducing Damage Assessment Latency in Survivable Databases, Proceedings of the 21st British National Conference on Databases, Edinburgh, Scotland, July 2004.
- Indrakshi Ray, Tai Xin and Yajie Zhu,
Task Dependencies During Workflow Recovery, Proceedings of he 15th International Conference on Database and Expert Systems, Zaragoza, Spain, August 2004.
- Indrakshi Ray and Mariana Muller,
Schemas to Simplify Access Control for XML Documents, Proceedings of
the International Conference on Distributed Computing and Internet
Technologies, Bhubaneswar, India, December 2004.
- Shuxin Yin and Indrakshi Ray,
Relational Database Operations Modeling with UML, Proceedings of
the 19th International Conference on Advanced Information Networking
and Applications, Taipei, Taiwan, March 2005.
- Indrakshi Ray and Lijun Yu
Short Paper: Towards a Location-Aware Role-Based Access Control Model
, Proceedings of the 1st IEEE Conference on Security and Privacy for
Emerging Areas in Communication Networks, Athens, Greece, September 2005.
- Indrakshi Ray and Wei Huang,
Event Detection in Multi-level Secure Databases, Proceedings of the
1st International Conference on Secure Systems, Kolkata, India, December 2005.
- Jinyoo Kim, Yashwant K. Malaiya and Indrakshi Ray,
Vulnerability Discovery in Multi-Version Software Systems,
Proceedings of the 10th IEEE High Assurance Systems Engineering
Symposium, Dallas, Texas, November 2007.
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.
Exams must be taken individually.
All parties involved in cheating will be prosecuted no matter who copied
Please be aware of the departmental cheating policy.
| Subhojeet Mukherjee
| Office Hours: TBD
| Office: 235 CSB Cubicle 5
| Phone: (970)-491-2556
| Email: email@example.com
|August 25, Tuesday
||First Day of Class
|September 8, Tuesday
||Term Paper: Topic + some references due
|September 15, Tuesday
||Term Paper: References due
|September 22, Tuesday
||Term Paper: Problem Motivation due
|September 29, Tuesday
||Term Paper: Topic presentation
|October 6, Tuesday
||Term Paper: Related Work due
|October 15, Thursday
|October 27, Tuesday
||Term Paper: Solution sketch due
|November 3, Tuesday
||Term paper: First version due
|November 17, Tuesday
||Term paper: Second version due
|December 1, Tuesday
||Term paper: Final version due
|December 3, Thursday
|December 8, 10,
||Term Paper Presentations
|December 10, Thursday
||Term paper critique due
|December 10, Thursday
||Last Day of Class