Define LUW Logical Unit of Work

All Subject

Question - Define LUW(Logical Unit of Work).

Answer -

An LUW(Logical Unit of Work) is a series of database operations that should be either completely executed(followed by commit) or not at all(followed by rollback).
It helps to guarantee the integrity of the database. The database is said to be in a correct state when an LUW has been successfully concluded. However, if any error occurs within an LUW, all the modifications made to the database from the beginning of the LUW will be canceled and the database will be returned to the previous state as before the LUW started. For example, in financial accounting, while transferring some amount of money, you must deduct that amount from account A and it must be added to account B. Before and after the transfer process, the data must be consistent, but in between these two steps, data can be inconsistent. If the amount transfer by LUW becomes successful, then the amount will be deducted from account A and added into account B. If any error occurs in between database must be returned to its previous state before LUW started.

Each time when you start a transaction.
When the changes made to the database using the previous LUW has been confirmed(database commit).
When the changes made to the database using the previous LUW has been canceled(database rollback).

Show all Coment

Name:

Email:

SAP Interview Questions and Answers