| Course |
CSE315 |
| Title |
Database Transaction Processing Systems |
| Credits |
3 |
| Course Coordinator |
R. Grosu |
| Current Catalog 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 Goals |
- 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.
|
| Textbook |
Databases and Transaction Processing: An Application Oriented Approach. By P.M. Lewis, A. Bernstein and M. Kifer. Addison Wesley, ISBN: 0-201-70872-8 |
| 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 |
