Chapter 15 - Transaction management. This chapter presents a broad coverage of transaction management. Before you can understand DBMS support for transaction processing, you need a more detailed understanding of transaction concepts. This chapter describes properties of transactions, SQL statements to define transactions, and properties of transaction processing. | Chapter 15 Transaction Management Welcome to Chapter 15 on Transaction Management - Transaction management: - Supports the daily operations of an organization - Most important environment for database processing Objectives: - Understand transaction basics: definition, ACID properties, concurrency and recovery transparency, SQL statements - Understand the objective and tools of concurrency control - Understand failure types and the tools used in recovery management - Gain insight about transaction design issues - Appreciate the role of transaction management in the larger area of workflow management Outline Transaction basics Concurrency control Recovery management Transaction design issues Workflow management Transaction basics: - Transaction definition and examples - ACID properties - Transparent services: concurrency control and recovery management Concurrency control: - Objective - Problems - Locking: lock properties, 2PL, deadlocks - Optimistic concurrency control Recovery management: - Failure types - Recovery tools - Recovery processes Transaction design issues - Determining transaction boundaries - Isolation levels - Integrity constraint timing - Save points Workflow management: - Characteristics - Enabling technologies - Implications on transaction management Transaction Definition Supports daily operations of an organization Collection of database operations Reliably and efficiently processed as one unit of work No lost data Interference among multiple users Failures Transaction processing supports daily (routine, repetitive) operations - Mundane but crucial - Become even more important with the growth of the internet Definition: - Collection of read/write operations - Processed as one unit - Reliably and efficiently processed - No data loss due to interference and failures (operating system, program, disk, ) Airline Transaction Example START TRANSACTION Display greeting Get reservation preferences from user SELECT departure and return flight records If . | Chapter 15 Transaction Management Welcome to Chapter 15 on Transaction Management - Transaction management: - Supports the daily operations of an organization - Most important environment for database processing Objectives: - Understand transaction basics: definition, ACID properties, concurrency and recovery transparency, SQL statements - Understand the objective and tools of concurrency control - Understand failure types and the tools used in recovery management - Gain insight about transaction design issues - Appreciate the role of transaction management in the larger area of workflow management Outline Transaction basics Concurrency control Recovery management Transaction design issues Workflow management Transaction basics: - Transaction definition and examples - ACID properties - Transparent services: concurrency control and recovery management Concurrency control: - Objective - Problems - Locking: lock properties, 2PL, deadlocks - Optimistic concurrency control Recovery .
