Optimistic Concurrency Control
A concurrency control mechanism that assumes transaction conflicts are infrequent, allowing operations to execute without acquiring locks. Conflicts are detected at commit time through atomic validation. The approach is widely used in distributed systems and database transaction management.
Timeline (last 90 days)
High-reliability ledgers use optimistic concurrency control (OCC) together with immutable append constraints, or use pessimistic row-level locking (SELECT ... FOR UPDATE) on account pointer records.
Before committing to storage, the target record, permitted change types, and current record version number should be validated; if they are inconsistent with the proposal, the current record should be retained and the conflict routed to a human for handling.
The "last-write trap" described in the article is the Lost Update problem in distributed systems; one standard solution is optimistic concurrency control, which operates on the same principle as a database CAS operation.
Iceberg and Delta Lake use optimistic concurrency control mechanisms, where write operations commit transactions by atomically updating the pointer to the current metadata file.
When two catalogs each permit writes, they may independently advance their respective maintained pointers, causing one commit to overwrite the other and resulting in data loss or state inconsistency.
All Facts (5)
High-reliability ledgers use optimistic concurrency control (OCC) together with immutable append constraints, or use pessimistic row-level locking (SELECT ... FOR UPDATE) on account pointer records.
50%UnverifiedBefore committing to storage, the target record, permitted change types, and current record version number should be validated; if they are inconsistent with the proposal, the current record should be retained and the conflict routed to a human for handling.
50%UnverifiedThe "last-write trap" described in the article is the Lost Update problem in distributed systems; one standard solution is optimistic concurrency control, which operates on the same principle as a database CAS operation.
50%UnverifiedIceberg and Delta Lake use optimistic concurrency control mechanisms, where write operations commit transactions by atomically updating the pointer to the current metadata file.
50%UnverifiedWhen two catalogs each permit writes, they may independently advance their respective maintained pointers, causing one commit to overwrite the other and resulting in data loss or state inconsistency.
50%