Two-Phase Commit

Two-phase commit - In multithreaded processing systems it is necessary to prevent more than one transaction from updating the same record at the same time. Where each transaction may need to update more than one record or file, the two-phase commit protocol is often used. Each transaction first checks that all the necessary records are available and contain the required data, simultaneously locking each one. Once it is confirmed that all records are ready and locked, the updates are applied and the locks freed. If any record is not available, the whole transaction is aborted and all other records are unlocked and left in their original state.

[Category=Data Quality ]

Source: Larry English, http://www.iaidq.com/main/glossary.shtml , 13-Feb-2009 11:08