Базы данных

4 карточек

1 / 4✓ 0✗ 0

junior

What does ACID mean in the context of database transactions?

нажми, чтобы перевернуть

juniordatabases

Atomicity, Consistency, Isolation, Durability — guarantees for reliable transactions.

Atomicity: all or nothing (rollback on error). Consistency: data transitions from one valid state to another. Isolation: concurrent transactions don't interfere with each other (isolation levels: Read Uncommitted -> Serializable). Durability: after commit, data is persisted even through crashes (WAL).

Когда да

Financial operations, inventory, any critical data

Когда нет

Analytics, logging, social feeds — where eventual consistency is acceptable

Совет на собеседовании

Know the isolation levels: Read Uncommitted, Read Committed, Repeatable Read, Serializable

Альт:BASE (Basically Available, Soft state, Eventually consistent)

Свайп вправо — знаю, влево — не знаю

ArchCase

ArchCase

Базы данных

Atomicity, Consistency, Isolation, Durability — guarantees for reliable transactions.