Isolation Levels in Transaction

As we have already discussed in the article, isolation specifies that each transaction should be executed independently of other transactions. The level specifies how much isolation can be provided to each transaction. Read Uncommitted It is the lowest level of insolation in a transaction. At this level, data changed during a transaction, which is essentially …

Transaction in database

A transaction is a unit of work that must maintain ACID properties. ACID is an acronym of Atomicity, Consistency, Isolation, and Durability Let’s look at each of them in detail. Atomicity A transaction contains a query or a set of queries. In order to maintain atomicity property, the transaction either has to execute all the …