Click here

two-phase commit

A feature of transaction processing systems that enables databases to be returned to the pre-transaction state if some error condition occurs. A single transaction can update many different databases. The two-phase commit strategy is designed to ensure that either all the databases are updated or none of them, so that the databases remain synchronized.

Database changes required by a transaction are initially stored temporarily by each database. The transaction monitor then issues a "pre-commit" command to each database which requires an acknowledgment. If the monitor receives the appropriate response from each database, the monitor issues the "commit" command, which causes all databases to simultaneously make the transaction changes permanent.

 



Top Terms

Connect with Webopedia

  • The Difference Between Adware & Spyware

    Not technically fitting into either the virus or spam category we have spyware and adware, which are growing concerns for Internet users.

    Read More »

Did You Know? Archive »

  • Quick Reference Archive »