ICS223- Transaction Processing and Distributed Data Management
Course Information (Winter 2007)
Subject to Change
Professor Sharad Mehrotra

Index

• Course Goals
• Instructor and Office Hours
• Grading Policy
• Prerequisites
• Time and Place
• Textbooks
• Electronic Lists

Course Goals

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.

Instructor and Office Hours

Professor Sharad Mehrotra  sharad@ics.uci.edu
Office Hours: Tu, 3:00 PM - 4:30 PM, ICS 424D, 949-824-5975.

Grading Policy

For all the graded assignments and projects, if you disagree with the grading, you can discuss with the instructor within two weeks after they are returned. After that, all the grades will be finalized.

Prerequisites

ICS222, and either ICS148 ("Distributed Computing") or ICS153 ("Computer Networks"). In addition, you should have 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.

Time and Place

The class meets Tues. and Thurs: 5 to 6.20

Textbooks

There are no required text books. The following are recommended:

• Readings in Data Management, Edited by Stonebraker and Hellerstein, Morgan Kauffman.
• Database System Implementation, by Hector Garcia-Molina, Jeffrey Ullman, and Jennifer Widom, Prentice Hall, 1999. Or Database Systems: The Complete Book, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Prentice Hall, 2001.
• Principles of Transaction Processing, by Philip A. Bernstein and Eric Newcomer, Morgan Kaufmann, 1997.
• Transaction Processing: Concepts and Techniques Jim Gray and Andreas Reuter Morgan Kaufman Publishers 1993
• Research papers may be made available whenever possible to supplement the textbook.

Electronic Lists

• News group: ics.214b has been created. It should be used as a forum for general discussions (e.g., finding a partner).
• Class mailing list: An email list has been setup to include the email addresses of all the enrolled students. We will use it to send out announcements.
• Email help: Send emails to the instructor sharad@ics.uci.edu for questions.