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
entity relationship diagram for online examination system

What are the responsibility of File manager? File Manager : Manager allocation of space on disk storage and the data structures used to represent within stored on disk. It is a

Can we delete data element, which is being used by table fields. No we cant delete data element.

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Explain the difference between the three storage types - volatile, non volatile and stable.             Ans: Volatile storage: if storage media loses data while power goes off,

Where does view definition stored? A view definition is permanently stored as part of the database.

What are the storage types? The storage types are: a) Volatile storage b) Nonvolatile storage

lock and types of lock