Transactions and ACID Properties

A transaction is a unit of execution in need of being carried by the database, we're mainly talking about queries. A transaction can at a given moment be in one of these states: The diagram in itself is self-explanatory: a transaction begins its lif...