ICS223- Transaction Processing and Distributed Data Management
Winter, 2007
Professor Sharad Mehrotra

Index

• Announcements
• Course Information
• Lecture Notes
• Project
• Homeworks
• Resources

Announcements

·       Class timing  Thurs from 5 – 7.50pm

·       The due date for Assignment 1 has been shifted by a week. It is now due on Feb 7^th

·       Assignment 2 has been posted already.

·       In addition to the assignments, please do not forget your reading assignments of the papers listed in the class notes

Course Information

• General Information. The following are a few important entries:
• Course Goals
• Instructor and Office Hours
• Grading Policy
• Prerequisites
• Time and Place
• Textbooks
• Electronic Lists

Lecture Notes

Number	Topic	Notes		Papers
00-0	Intro to course	PPT, PDF		Gray and Reuter, Chapters 1,5, 6
00-1	Consistency in Databases	PDF	- latex	Non-serializable Executions
00-2	Ensuring Conflict Serializability	PDF	latex	Models for studying concurrency control performance, Agrawal, Carey, Livny Deadlock detection in distributed databases
00-3	Dealing with hotspots + Structured Locking	PDF	latex	ARIES I/M The Escrow Transactional Method
00-4	Multigranularity Locking and Phantoms	PDF	latex	Key Range Locking phantoms in R-tree access phantom in GiST pi-tree concurrency control
00-5	Recovery Algorithms	PDF PPT		ARIES Lomet-MLR  Lomet-O2PC
00-6	Distributed Transactions	PPT PPT

Resources

• Major DB courses at UCI: ICS184, ICS185, ICS222, ICS214B, ICS215.
• UCI Calendar (02-03); ICS Instructional Course Offerings.
• Places to find papers: DBLP, ACM Digital Library, ACM SIGMOD Anthology, Google, NEC CiteSeer.