database transaction
Let an agent explain database transactions, relay ACID, isolation levels, concurrency control and distributed protocols from computer science sources, describe the extensions the registry aliases name, and distinguish transactions from individual queries, from CRUD operations as such and from business or financial transactions.
Research draft, second pass
A second pass drafted this model: the structure a model of this thing needs, and what is known about it in the world. The line under this one says how the second half was obtained - researched against sources, or recalled without web access, in which case nothing here was read anywhere and every claim is a lead to verify. Unreviewed either way.
written by Claude from model knowledge without web access - no source was read, every claim is a lead to verify
Researched by: Claude
Purpose and description
Let an agent explain database transactions, relay ACID, isolation levels, concurrency control and distributed protocols from computer science sources, describe the extensions the registry aliases name, and distinguish transactions from individual queries, from CRUD operations as such and from business or financial transactions.
A unit of work performed against a database that is treated as a single, indivisible operation, guaranteed by the ACID properties of atomicity, consistency, isolation and durability, and either committed or rolled back as a whole, with extensions such as nested transactions, distributed transactions across multiple systems coordinated by protocols like two-phase commit, and web service standards such as WS-Transaction; the create, read, update and delete operations are performed within transactions.
What it is for: Keeping database changes correct and reliable.
It can be explain transactions; relay ACID and isolation; describe distributed and nested forms; distinguish related concepts.
Distinguishing features
All or nothing
Isolation levels
Recovery via logs
Distributed coordination
What it looks like
Not a visible object; code between BEGIN and COMMIT.
Physical character
ACID: atomicity, consistency, isolation, durability list - term 1983
SQL isolation levels: 4 count - read uncommitted to serializable
two-phase commit: coordinator and participants note
How it is recognised
Atomic unit of database work
Distributed transaction, nested transaction, WS-Transaction, CRUD operations
A query is one statement; CRUD names operation types; business transactions are commercial events
Related models
is a kind of - in registry terms
guarantees - properties
is coordinated by - when distributed
contains - operations
In practice
Families and kinds
flat transactions
nested transactions
distributed transactions
long-running and saga transactions
web service transactions such as WS-Transaction
Standards and regulation
SQL standard isolation levels
OASIS WS-Transaction specifications
Failure modes and hazards
Deadlocks and anomalies at weak isolation
Blocking in two-phase commit
Confusing database and business transactions
Also called
Where this came from
wikidata · CC0 1.0
Drafted structure
Bundle to layer to finding to question, as the second pass will find it: 4 bundles · 8 layers · 8 findings · 16 questions.
Understand What a database transaction is.
Science.
Definition
Definition.
Definition
Definition.
- What is a database transaction, and how does it differ from a query, CRUD operations and business transactions? definition
- Is the question about concepts, a database system, distributed systems or programming? boundary
Kinds
Kinds.
Kinds
Kinds.
- What are nested, distributed and WS-Transaction transactions? definition
- Which entry fits the specific kind? action
Theory Theory.
Science.
ACID
ACID and isolation.
ACID
ACID.
- What do the ACID properties and isolation levels guarantee, and what anomalies occur? provenance
- Which references are standard? provenance
Concurrency
Concurrency control.
Concurrency
Concurrency.
- How do locking, MVCC and optimistic control work? provenance
- Which sources are cited? provenance
Distributed Distributed systems.
Science.
Commit
Commit protocols.
Commit
Commit.
- How do two-phase and three-phase commit coordinate distributed transactions? provenance
- Which entry fits two-phase commit protocol? action
Sagas
Sagas and eventual consistency.
Sagas
Sagas.
- How do sagas and eventual consistency trade guarantees for availability? provenance
- Which entry fits CAP theorem? action
Context History and practice.
Context.
History
History.
History
History.
- How did Jim Gray and others develop transaction processing? provenance
- Which entry fits the history of databases? action
Practice
Practice.
Practice
Practice.
- How do developers use transactions safely in applications? provenance
- Which entry fits SQL? action
What the second pass must settle
- Should distributed transaction be a separate primary entry?
- How should computer science sources be linked?
- The registry alias CRUD names operations rather than a kind of transaction; should it be split off?