George Mason University

Department of Computer Science

CS 650: Advanced Database Management

Spring 2019

Prof. Ami Motro


This is an advanced course in the area of databases, focusing on how database systems are architected and implemented to achieve essential properties such as high performance and reliability. Whereas in an introductory course on databases (for example, CS 550) the focus is how to work with database systems (database design, query languages, application programming, and so on), the focus of this course is how database systems work.

Approximate class schedule
  1. Introduction and course administration (1 week)
  2. Physical data organization (3 weeks)
  3. Query processing and query optimization (2 weeks)
  4. Transaction processing, concurrency control and recovery (2 weeks)
  5. Architectures of database systems (2 weeks)
  6. Advanced topics, exams and reviews (4 weeks)
Time and Place

Thursday, 4:30-7:10 pm
Arts and Design L008


Ami Motro
Office: ENG-4415
Telephone: 703-993-1665
Office hours: Wednesday and Thursday 3:00-4:00


CS 550 Database Systems or INFS 614 Database Management.
Prerequisites are strictly enforced!


Two exams (a mid-term and a final), and four homework assignments.
The final grade will be based on exams (37.5% each) and homework assignments (25%).


Comprehensive instructor notes ("slides") will be made available. This book is recommended for further reading:

Database Systems - An Application-Oriented Approach, Introductory Version, 2nd Edition
Kifer, Bernstein, and Lewis
Addison-Wesley/Pearson, 2004
ISBN-10: 0321228383
ISBN-13: 9780321268457