A framework of transaction management in distributed database system environment

The main objective of the paper is to determine the transaction management techniques in DDBMS for present time business applications. Distributed database systems (DDBS) poses 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. It primarily concentrates on the description of the used commit protocols in distributed database. 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. There is an example given that demonstrate the steps involved in executing the two-phase commit protocol. This transaction protocol will be beneficial for the organizations to manage the enterprise data resource in DDBS environments efficiently.