What is transaction?
A transaction in commercial databases is referred to as atomic unit of work. For
example, when you purchase something from a point of sale (POS) terminal, a
number of tasks are performed such as;
- Company stock is updated.
- Amount is added in company's account.
- Sales person's commission increases etc.
All these tasks collectively are called an atomic unit of work or transaction.