SQL Locking Strategies Vs Other DBMS's strategies

[workit]

Hi,

My name is David and I am currently on my second year of a HND in Business Information Technology. I am doing a project on managing a multi-user Database management system. I have built a database using SQL, created views and demonstrated how concurrent transactions create a lockup.

Now I need to devise a locking strategy to overcome the problems and compare the locking strategy used by SQL Server 7 to other DBMS products. Do you have experience in other DBMS's and its comparison to SQL, or even an idea of how SQL's locking strategy works.

Thanks A lot, David

 

[AshleyRickards]

David,
As far as SQL goes it dynamically handles locking. There are several types.

Shared , update ,exclusive,schema, intent

Resourse locks:

RID (locks single row in table)
Key (row lock in an index)
Page (8kb data page or index)
Extent (8 page)
Table (entire table)
DB (database)

Look in Books Online, which is installed with SQL for more detailed info. Ashley L Rickards
SQL DBA