5 INFS 760: Advanced Database Management

George Mason University

Department of Computer Science

INFS 760: Advanced Database Management

Spring 2013

Prof. Ami Motro


Description

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 (such as INFS 614 or 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 to 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)
Time and Place

Tuesday, 4:30-7:10 pm
Sandbridge Hall 107

Instructor

Dr. Ami Motro
Office: ENG-4415
Telephone: 703-993-1665
Email: ami@gmu.edu
Web: http://cs.gmu.edu/~ami
Office hours: Wednesday and Thursday, 3:00-4:00 pm

Prerequisites

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

Requirements

Two exams (a mid-term and a final), and 4 or 5 homework assignments.
The final grade will be based on exams (43% + 32%) and homework assignments (25%).

Textbook

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