Chapter 25 Advanced Transaction Processing.ppt

Copyright: Silberschatz, Korth and Sudarshan Chapter 25: Advanced Transaction Processing Transaction Processing Monitors TP Monitor Architectures TP Monitor Architectures (Cont.) TP Monitor Architectures (Cont.) Detailed Structure of a TP Monitor Detailed Structure of a TP Monitor Application Coordination Using TP Monitors Workflow Systems Transactional Workflows Examples of Workflows Loan Processing Workflow Transactional Workflows Workflow Specification Workflow Specification (Cont.) Failure-Automicity Requirements Execution of Workflows Workflow Management System Architectures Workflow Scheduler Recovery of a Workflow Recovery of a Workflow (Cont.) High Performance Transaction Systems High-Performance Transaction Systems Main-Memory Database Main-Memory Database Optimizations Group Commit Real-Time Transaction Systems Long Duration Transactions Long-Duration Transactions Concurrency Control Concurrency Control (Cont.) Nested and Multilevel Transactions Nested and Multilevel Transactions (Cont.) Example of Nesting Compensating Transactions Implementation Issues Transaction Management in Multidatabase Systems Transaction management is complicated in multidatabase systems because of the assumption of autonomy Global 2PL -each local site uses a strict 2PL (locks are released at the end); locks set as a result of a global transaction are released only when that transaction reaches the end. Guarantees global serializability Due to autonomy requirements, sites cannot cooperate and execute a common concurrency control scheme E.g. no way to ensure that all databases follow strict 2PL Solutions: provide very low level of concurrent execution, or use weaker levels of consistency Transaction Management Two-Level Serializability Two-Level Serializability (Cont.) Global Serializability Ensuring Global Serializability End of Chapter Weak Levels Consistency Example Schedule with Degree-Two Consistency Cursor Stability A non-conflict-serializable schedule that preserves th