TAILIEUCHUNG - Lecture Database design, application development and administration - Chapter 15: Transaction management

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 .

• Cơ sở dữ liệu
• Database design
• Database development
• Relational databases
• Database environments
• Transaction management
• Recovery management
• Database Systems
• Practical Database Design
• Physical Database Design in Relational Databases
• An Overview of Database Tuning in Relational Systems
• Physical Database Design Decisions
• Database system concepts
• Lecture Database system concepts
• Database languages
• Relational database design
• Physical database design
• Physical records
• Student loan limited
• Database System
• Lecture Database Systems
• Fundamentals of database systems
• Relational database design algorithms
• Lecture Database System
• Practical database design and tuning
• Database tuning in relational systems
• Database design process
• Database management
• Database characteristics
• Database administration
• Database specialists
• Application design
• Object database management systems
• Object database
• Enhanced ER Model
• Database design modeling tools
• Design choices
• Logical database design
• Relational tables
• Database system architectures
• View design with forms
• View integration
• Designing a set of relations
• Relational decompositions
• Relational database schema
• Client server processing
• Parallel database processing
• Multivalued dependencies
• Database management systems
• Fundamentals of database management systems
• Object oriented database management
• Data administration
• Relational design
• Database concepts
• Lecture Database concepts
• Database fundamentals
• Database processing environment