Overview and characteristics of distributed transactions
Transactions are important functions for database systems. A transaction is a logical unit that operates on a database and contains a collection of operations (generally referred to as SQL). When executing this transaction, it should hold ACID properties:
- Atomicity: All the operations in the transaction succeed or fail (be it read, write, update, or data deletion).
- Consistency: The status before and after the transaction's execution meets the same constraint. For example, in the classic transfer business, the account sum of the two accounts is equal before and after the transfer.
- Isolation: When transactions are executed concurrently, isolation acts as concurrency control. It ensures that the transaction's execution impacts the database in the same way as sequentially executed transactions would.
- Durability: By durability, we refer to the insurance that any changes that are made to the data by successfully...
