Database data integrity with a two-phase mechanism

Asked By FeloM 0 points N/A Posted on - 10/27/2011

I need experts to please tell me how a two-phase commit mechanism in distributed databases ensures there is data integrity. I am working on an assignment related to database data integrity and this issue seems to be hard. I just need a few pointers on this.

 

• Status: Open
• Question Views: 902
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: dBase

Best Answer by Dexter Alberto

Go To Solution

Answered By abid564 0 points N/A #96865

Database data integrity with a two-phase mechanism

In distributed system the database ensure the integrity of the data by using the two-phase commit mechanism.

Prepare phase:

During this phase the initiating node in the transaction ask the other participating nodes to promise roll back or to commit  the transactions.

Commit phase: 

During this phase the initiating node asks all participating nodes to commit the transaction, and if this outcome is not possible, then all nodes are asked to roll back and hence integrity ensures.

This is how the two phases in Distributed system ensures integrity. for further instruction go to oracle or microsoft sql official website.

 

 

About abid564

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/29/2011
• Question Category: dBase

Best Answer

Best Answer

Answered By Dexter Alberto 0 points N/A #96867

Database data integrity with a two-phase mechanism

Hello FeloM,

A two-phase commit mechanism is a technique used in database to ensure there is data integrity in distributed transactions and ensures there is concurrency control. The phases in this mechanism are:

• Prepare phase – The node which initiates the transaction, also called the global coordinator, initiates the transaction and requests all participating nodes, excluding the commit point site, to commit to the transaction or roll back the transaction, even in case of a failure. If any node cannot get ready to commit, the whole transaction is rolled back.
• Commit phase – In this phase, if all the participating nodes are prepared, they respond to the coordinator which in this case, the commit point site is requested to commit. After committing to the transaction, all other nodes are requested to also commit to the transaction. When all nodes have committed to the transaction, there is consistency in the database.
• Forget phase – In this phase, all the participating nodes have committed and the coordinator informs the commit point that all nodes have committed. The commit point deletes its information about the transaction and informs the coordinator about this deletion and the coordinator deletes its own information about the transaction (forgets about the transaction).

These are the phases which ensures there is data integrity and consistency in a database using the two-phase commit mechanism.

Thank you.

About Dexter Alberto

Questions
3

Answers
99

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 12/19/2012
• Question Category: dBase