11.3 Serializability

Serial execution of transactions means that transactions are performed one after another, without any interleaving of operations. If A and B are two transactions, there are only two possible serial executions: all of transaction A is completed first and then all of transaction B is done, or all of B is completed and then all of A is done. In serial execution, there is no interference between transactions because only one is executing at any given time. However, there is no guarantee that the results of all serial executions of a given set of transactions will be identical. In banking, for example, it matters whether INTEREST is calculated for an account before a large deposit is made or after. However, as far as database ...

Get Databases Illuminated, 4th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.