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

Ask an Expert

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

Write your message here..

Related Questions

Describe the most important classes of parallel machines, Question 1 Discu... 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.

B-tree, construct a b-tree for the following set of key values 2,3,5,7,11,1... 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

Define partial, Partial Key : It is a group of attributes that can uniquel... 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 is System R? What are its two major subsystems? ... 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, Define canonical cover? A canonical cover Fc fo... 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.

MYSQL, i have a homework assignment identical to one you have listed i have a homework assignment identical to one you have listed

Explain data models namely relational network - hierarchical, Explain the t... 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, What is DML compiler? DML Compiler: Translates DM... 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, What is an object design? Object design is a ... 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

What is E-R model, E-R Model This data model is based on real world th... 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