[From Builder.com]
When data in a database is read or modified, the database engine uses special types of controls, called locks, to maintain integrity in the database. Locks basically work by making sure database records involved in a transaction cannot be modified by other transactions until the first transaction has committed, ensuring database consistency.
The article continues at
http://builder.com.com/5100-6388_14-6185492.html?tag=sc