Radu Grosu

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

• 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.

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).

• 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