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
List any two disadvantages of a database system ? The disadvantages of database system are: • Database systems are difficult, complex, and time-consuming to design. • Substanti

What is transaction? Collections of operations that form a single logical unit of work are known as transactions.

Define access time. Access time is the time from when a read or write request is issued to when data transfer starts.

Structure Of Distributed Database: A distributed database system haves of a collection of sites, each of which keeps a local databases system. Every site is able to process local

Define the terms i) Key attribute ii) Value set Key attribute: An entity type usually has an attribute whose values are exact from each individual entity in the collection. Su

1. Use the Invoice table structure shown below to answer the following questions: a)  Draw the dependency diagram and identify the primary key and all dependencies, including al

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

Describe Graphical User Interface? Graphical User Interfaces (GUIs) - A GUI typically displays a schema to the user in diagrammatic form. The user can then specify a query th

Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G

What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist