concurrency control protocol in dbms

-

                                      concurrency control

  • The concurrency control is the coordination of the simultaneous execution of a transaction in a multiuser database system.
  •  The concurrency control can ensure the serializability of the transaction in a multiuser database environment and that is the main objective of concurrency control.
  •  There is only One way in which the required data items can be accessed in a mutually exclusive manner. That is while one transaction is accessing a data item another transaction can modify that data item. The most common method used to implement this requirement is to allow a transaction to access a data item only if it is currently holding a lock on that item.

                                       concurrency control technique

  • concurrency control technique is used to create consistent schedule. it guarantes to generate schedule which satisfy these properties specially.
  • we use some protocol to design and create consistent and isolated schedule so after that it is not need to check serializibility.
       types of protocols:-
       1. time stamping protocol.
       2. lock base protocol.
       3. two phase locking.

thank you viewers .
this is published by soumy sinha.
give your feedback in comment box and share with your friends.
this is our official fb page pls join us for more information.

      

Comments

Post a Comment