transactions

数据库事务、ACID 属性和并发控制

📖 中文导读:数据库事务、ACID 属性和并发控制 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

name: transactions description: Database transactions, ACID properties, and concurrency control sasmp_version: "1.3.0" bonded_agent: 01-sql-fundamentals bond_type: PRIMARY_BOND

Database Transactions Skill

Overview

Understand and implement database transactions with ACID properties and proper concurrency control.

Topics Covered

ACID Properties

  • Atomicity
  • Consistency
  • Isolation
  • Durability
  • Trade-offs

Isolation Levels

  • Read uncommitted
  • Read committed
  • Repeatable read
  • Serializable
  • Snapshot isolation

Concurrency

  • Locking mechanisms
  • Deadlock handling
  • Optimistic locking
  • MVCC concepts
  • Lock monitoring

Transaction Patterns

  • Savepoints
  • Nested transactions
  • Distributed transactions
  • Two-phase commit
  • Saga pattern

Prerequisites

  • SQL fundamentals
  • Database concepts

Learning Outcomes

  • Implement ACID transactions
  • Choose isolation levels
  • Handle deadlocks
  • Design concurrent systems