two-phase commit


Also found in: Dictionary, Thesaurus, Medical, Legal, Financial.

two-phase commit

(database)
A technique for maintaining integrity in distributed databases. Where a system uses two or more database, a transaction among the distibuted database should be atomic ("all or nothing"). This is done by handling the transaction in two phases. First the databases prepare the transaction, confirm that it is possible to process it, and lock the relevant record.

Once all the required databases confirm that the transaction is viable, the system instructs them all to commit it - i.e. to make it permanent. If it is not possible to process it, the system will instruct the databases to rollback (undo) the transaction.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

two-phase commit

A technique for ensuring that a transaction successfully updates all appropriate files in a distributed database environment. All DBMSs involved in the transaction first confirm that the transaction has been received and is recoverable (stored on disk). Then each DBMS is told to commit the transaction (do the actual updating).

Traditionally, two-phase-commit meant updating databases in two or more servers, but the term is also applied to updating two or more different databases within the same server. See transaction, transaction file and transaction processing.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
They provide guaranteed consistent outcome in complex multiparty business operations using a two-phase commit protocol.
A transitional service is provided to ensure completion of communication between all points of the services between .NET, J2EE and Corba, including two-phase commit and call-back from J2EE and Corba to the .NET application or service.
-- Distributed Transaction management and full two-phase commit for Oracle and ASE databases in any combination
In addition, the new adapters also support features of the proposed JCA 1.5 specification like connection pooling, two-phase commit support, support for in-bound communication and support for XML and Metadata.