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

CSE/ISE 305

• Provide an understanding of the properties of transactions such as serializability, recoverability, atomicity and durability and their implications for system behavior and performance.
• Describe the support for transaction processing in modern relational database systems, such as concurrency control and logging.
• Study the architecture of modern transaction processing systems and how communication, security, atomicity, and replication are implemented in a distributed environment.

• Databases and Transaction Processing: An Application Oriented Approach. By P.M. Lewis, A. Bernstein and M. Kifer. Addison Wesley, ISBN: 0-201-70872-8

• 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

• 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

N/A