Database Transactions

Created: 2022-01-20T17:29:16-06:00

Return to the Index

TBD if this should become a hub or not

Transactional databases allow queing a set of changes across depots which must all be applied at once or none of them.

The protocol for getting multiple independent depots to stage and commit a transaction is called Two-Phase commit.

Two-phase Commit

Internally you can rely on locks to secure reads/writes during this process or you can use live version pointers (at the risk of still being allowed to read data during a change period.)

Lock-based updating

Multi-versioning; live version pointers