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

What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)

What is normalization? It is a method of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to attain the properties (1).Minim

Describe Data Manipulation language ? Data Manipulation Language (DML) - A data manipulation language is a language which enables users to access or manipulate data as organize

Give short note on the following terms:Dirty pages and ETL a.) Dirty pages. These are buffer pages which comprise modifications which haven't been written to disk. b.

Using Literal Character String Example: To print IS A as one string with column name employee SELECT ENAME || ' IS A ' || JOB AS "EMPLOYEE" FROM EMP;

State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso

The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen