Abstract:
A transaction is a logical unit of work.
Transaction Processing Systems (TPS) are the
heart of the business operations today. A TPS may
fail for many reason such as system failure,
human errors, hardware failure, incorrect or
invalid data, computer virus, software application
errors or natural or man-made disasters. As it is
not possible to prevent all TPS failures, a TPS
must be able to cope with failures. So, TPS will go
through a recovery of the database to cope when
the system fails. Transactions are indeed the unit
of recovery. Recovery in database system means
that restoring the database to a correct state after
some failure has rendered the current state
inconsistent. In this paper, Out-of-Place update
recovery information is used to prevent data loss
in online sale transaction processing and
restoring the database to be a consistent state.