ISE315

Course ISE315
Title Database Transaction Processing Systems
Credits 3
Course Coordinator

Radu Grosu

Description

Theory and practice for the design of applications involving transactional access to a database. Transaction design, schema design, restart and recovery, logging, concurrency control, distributed databases. Student groups perform design and implementation of a significant database application. This course is offered as both CSE 315 or ISE 315

Prerequisite CSE/ISE 305
Course Outcomes
  • An understanding of the properties of transactions such as serializability, recoverability, atomicity and durability and their implications for system behavior and performance.
  • Working knowledge of transaction processing in modern relational database systems, such as concurrency control and logging.
  • An understanding of the architecture of modern transaction processing systems and how communication, security, atomicity, and replication are implemented in a distributed environment.

Textbook

Michael Kifer, Arthur Bernstein and Philip Lewis, Database Systems: An Application Oriented Approach, Introductory Version, 2/E, Addison-Wesley, 2005. ISBN 0-321-22838-3).

Major Topics Covered in Course
  • Transactions: ACID properties and various models
  • Architecture of Transaction Processing Systems
  • Implementing Isolation in Relational and Non-Relational Systems
  • Implementing Atomicity and Durability
  • Distributed Transactions
  • Replication
  • Other: Security, E-Commerce, Application Tuning

Laboratory Projects

Six short laboratory projects (1 - 2 weeks allocated for each) covering: stored procedures, save points and nested transactions, isolation levels and phantoms, deadlocks and lost updates, indexes, performance issues

Course Webpage

N/A