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

One-to-many relationship, For each 1: n relationship type R involving two e... For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the en

What is an entity relationship model, What is an entity relationship model?... What is an entity relationship model?  The  entity  relationship  model  is  a  collection  of  basic  objects  known as entities  and  relationship  between  those objects. An

Identify the critical activities, Consider a systems development project wi... Consider a systems development project with the following data Activity                                Duration (weeks)        Precedence Relationship 1. Software design

Decompose the table - 3nf or bcnf, Decompose the table with the following ... Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. A long-standing international treaty am

Vertical fragmentation, Vertical Fragmentation- Vertical fragmentation grou... Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

Explain composite attribute in sql, Explain Composite attribute in SQL ? ... Explain Composite attribute in SQL ? Composite attribute: A composite attribute has many components, each of that is atomic or composite.

How to create values of structured type, How to create values of structured... How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

Explain dynamic two-phase locking, Explain Dynamic Two-Phase Locking H... Explain Dynamic Two-Phase Locking Here a transaction locks a data item instantly earlier than any operation is applied on the data item.  After finishing all the operations on

Phase 1 Individual Project, How do I begi How do I begin

Shadow paging, Describe the shadow paging technique. Describe the shadow paging technique.