Transactions are super useful when dealing with mission-critical data like currency, item stocks, or, generally speaking - resources. Transactions are groups of read or write operations performed atomically (multiple statements are treated as one), consistently (state after transaction will be valid), in insolation (ensures concurrent transactions are executed like sequentially) and durable (once the transaction has been committed, you can be sure that it has been persisted to the table). Translating this story to a more technical jargon Durability: Guarantees that a transaction is committed even if the system fails.Isolation: Guarantees that a transaction is executed in a way that does not affect other transactions.Consistency: Guarantees that the database is in a consistent state after a transaction is committed.Each transaction is a single unit of change to the database and it is either committed or rolled back. Atomicity: Guarantees that a transaction is either fully committed or not at all.Transactions in database world have four basic properties: Congrats! In the transactions world, this is a "committed" transaction. Next Saturday, you're going to the same bar, but this time you got lucky, and all three of you managed to get in, and nobody needs to leave.
In transaction terms, you decided to "rollback". One for all, all for one, like Three Musketeers. Because you are good friends and you always support each other, in the act of solidarity, you and your friend who managed to get in decide to leave the bar.
Finally, he looks at your second friend and says: "Sorry, it's not your day", and he is not letting him in. As you approach the bar, the bouncer looks at your first friend and lets him in. You're going to the bar with a strict entry policy with two of your friends. Let me explain a "transaction" to you using more human terms: A transaction generally represents any change in a database. What is ACID Transaction?Ī database transaction symbolizes a unit of work performed within a database management system (or similar system) against a database and treated coherently and reliably independent of other transactions. DynamoDB supports classical ACID transactions.
0 kommentar(er)
