Locks, Database Management System

Locks:Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent transactions do not have any concurrency related trouble. This can be completed by using locks. So let us talk about what the dissimilar types of locks are, and then how locking ensures serialsability of implementing transactions.

 

Posted Date: 3/12/2013 2:33:07 AM | Location : United States







Related Discussions:- Locks, Assignment Help, Ask Question on Locks, Get Answer, Expert's Help, Locks Discussions

Write discussion on Locks
Your posts are moderated
Related Questions
management information system based on functional organisation

What is the main difference between read-only and update methods? A read-only method does not affect the values of a variable in an object, whereas an update method may alter t

can you create a database for me in oracle/sql

I want a good Microsoft Admin experienced in IIS and SQL Server. They require being able to set it up and administer from then onwards. Experience in Team Foundation Server a

Suppose an instruction takes 1 nanosecond to execute (on average), a page fault takes 20 microseconds of processor time, and it takes 300 microseconds of disk time to read or write

What is OOM? Object oriented modeling is an approach by which modeling of systems is done by visualizing the system based on real world concepts. Object oriented modeling does

What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

Explain Alternate key? Alternate Key - All the candidate keys except primary key are known as alternate keys.

Group By clauses  • It is used to group database tuples on the basis of definite common attribute value like as employees of a department. WHERE clause still can be used

Explain the Concept of Two-phase Locking It concerns the positions of locking and unlocking operations in each transaction.  In this protocol every transaction issue lock and u