Share
Explore BrainMass

row-level, column-level, and table-level locking

Can anyone tell me the differences between row-level, column-level, and table-level locking? Why would you need to use them?

Solution Preview

Can anyone tell me the differences between row-level, column-level, and table-level locking? Why would you need to use them?
===============================================================================================================

Locking is the way that most databases handle Concurrency Control when multiple users are accessing and modifying the same data base and its contents like whole tables or some selected rows and/or columns of certain table. Concurrency Control is the way that a database synchronizes users' access to data to ensure that they do not destroy each other's work. While one user has a lock on a subset of the database, whether it is a row, a column, or an entire table, that data is protected from other user's attempts to make changes to it. One user's changes have to be "committed" ...

Solution Summary

This job examines row-level, column-level, and table-level locking.

$2.19