Journal of Information Systems Education (JISE)

Volume 13

Volume 13 Number 2, Pages 95-104

Summer 2002


Transaction Management in Distributed Database Systems: The Case of Oracle’s Two-Phase Commit


Ghazi Alkhatib
Qatar College of Technology
Doha, Qatar

Ronny S. Labban
Consolidated Contractors International Company
Athens, Greece

Abstract: Distributed database systems (DDBS) pose different problems when accessing distributed and replicated databases. Particularly, access control and transaction management in DDBS require different mechanism to monitor data retrieval and update to databases. Current trends in multi-tier client/server networks make DDBS an appropriated solution to provide access to and control over localized databases. Oracle, as a leading Database Management System (DBMS) vendor employs the two-phase commit technique to maintain consistent state for the database. The objective of this paper is to explain transaction management in DDBS and how Oracle implements this technique. An example is given to demonstrate the step involved in executing the two-phase commit. By using this feature of Oracle, organizations will benefit from the use of DDBS to successfully manage the enterprise data resource.

Keywords: Transaction management, Two-phase commit, Distributed database systems, Oracle database

Download this article: JISE - Volume 13 Number 2, Page 95.pdf


Recommended Citation: Alkhatib, G. & Labban, R. S. (2002). Transaction Management in Distributed Database Systems: The Case of Oracle’s Two-Phase Commit. Journal of Information Systems Education, 13(2), 95-104.