Transaction Processing in Database Management Systems
Transaction processing within the parlance of data base management systems is when SQL statements that are required to be executed on the database are grouped into units of transactions. This ensures that a single transaction executes a whole unit or does not execute at all. Let us for example take a banking transaction during which X transfers some money to Y. There should be a debit of X’s account and a corresponding credit into Y’s account. Imagine if there is a fatality during the transaction where the transaction which increases the bank balance of Y cannot be completed due to a disk crash or due to a power failure etc., in such a case the system will cease to be consistent as it has completed a transaction namely a debit, but did not complete the corresponding credit transaction due to a power failure or a hard disk crash. Let us also consider the alternative where both these database operations are bundled into a transaction, so either both execute together or both do...