Objectives-transactions and concurrency management, Database Management System

Objectives

After Reading this part, you should be able to:

  • Explain the term CONCURRENCY;
  • Describe the term transaction and concurrent transactions;
  • Talk about concurrency control mechanism;
  • Define the principles of locking and serialisability, and
  • Define concepts of deadlock & its prevention.

 

 

Posted Date: 3/11/2013 5:17:23 AM | Location : United States







Related Discussions:- Objectives-transactions and concurrency management, Assignment Help, Ask Question on Objectives-transactions and concurrency management, Get Answer, Expert's Help, Objectives-transactions and concurrency management Discussions

Write discussion on Objectives-transactions and concurrency management
Your posts are moderated
Related Questions
Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

construct a b-tree for the following set of key values 2,3,5,7,11,17,19,23,29,31.assume that the tree is initial empty and the values are added in ascending order

Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator.  Altern

What is System R? What are its two major subsystems? System R was intended and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its pur

Define canonical cover? A canonical cover Fc for F is a set of dependencies like F logically implies all dependencies in FC and Fc logically shows all dependencies in F.

i have a homework assignment identical to one you have listed

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da

What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

What is an object design? Object design is a very interactive method, which decides the relationship among objects, classifies operations on classes, determines overall system

E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database