The course covers fundamental principles underlying transaction processing including database consistency, concurrency control, database recovery and fault-tolerance. The course includes transaction processing in centralized, distributed, parallel, and client-server environments. It also covers distributed database systems. The course is a prerequisite for further advanced data management courses and research principles of data management.

Students are encouraged to work in a group of 3 for their class projects and for the assignments.

. Pre-requisites

ICS222 plus a reasonable (undergraduate level) understanding of core computer science concepts, good familiarity with relational databases (equivalent of CS 184), some familiarity with object oriented concepts, good programming skills, and familiarity with basic undergraduate level operating system concepts (e.g., virtual memory, segmentation, demand paging, disk scheduling, processor scheduling, mutual exclusion, semaphores, concurrent programming, deadlocks). Above all, you need to have a positive attitude towards learning, no inhibitions about working in groups and learning from each other.