Explore BrainMass

Database Design Assessment: Concurrent Processing.

Discuss three possible problems that can occur because of concurrent processing that are addressed by resource locking.

Solution Summary

If concurrent transactions with interleaving operations are allowed in an uncontrolled manner, some unexpected, undesirable result might take place. The solution explains three typical examples:

1) The lost Update Problem
2) The dirty read problem
3) Phantom Reads