Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 21632, Locking Schemes

by Gökmen ÇİFTÇİ Email: gkmciftci@yahoo.com


Locking Schemes
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For InterBase, Version 4.0  to 4.0 208 downloads
Copyright: No significant restrictions


Size: 154,978 bytes
Updated on Thu, 15 Apr 2004 03:06:16 GMT
Originally uploaded on Thu, 15 Apr 2004 03:03:11 GMT
SHA1 Hash: 2A99DFEC1CE6B0AC28F3D2DADB810AD039F3F2D5
MD5 Hash: 8CFAF7BA8DC953DA744E7918A52761C7

    Explore the files in this upload

Description
The oldest and most common method of controlling concurrent access to data by several users is locking. When one user locks an object in a database he or she restricts the ability of other users to access that object. How much a lock affects concurrency depends on the granularity of the lock. For example, a lock placed on an entire table will restrict other users access to all of the rows in the table. Therefore, a table level lock has very low granularity. A lock placed on a single page in a table limits access to all of the rows on that page. A page level lock is more granular than a table level lock. By contrast, a lock placed on a single row is very granular and provides the minimum restriction to concurrent data access.

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC03