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

Authors

Ghazi Alkhatib, Qatar College of Technology
Ronny S. Labban, Consolidated Contractors International Company

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.

Recommended Citation

Alkhatib, Ghazi and Labban, Ronny S. (2002) "Transaction Management in Distributed Database Systems: The Case of Oracle’s Two-Phase Commit," Journal of Information Systems Education: Vol. 13 : Iss. 2 , 95-104.
Available at: https://aisel.aisnet.org/jise/vol13/iss2/4