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.