Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

My 2 Cents What Is Concurrency Control?

Discussion in 'Database Management' started by Swati Mishra, Feb 17, 2016.

  1. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    In database management system it is possible to multiple transaction can be executed simultaneously and it is important to control the concurrency of transaction, it means transaction of multiple database executed with same time and can access the same data.

    We can divide the concurrency control in two parts which are:

    Lock based Protocols
    Time stamp based Protocols
     
  2. steve taylor

    Yellow Belt

    Joined:
    Feb 12, 2016
    Messages:
    769
    Ratings:
    +25 / -0
    Concurrency means simultaneous excess of data from the database. if there are more user access the data from the database at the same time then there is a chance of data record may be goes into inconsistent state this results in error.To prevent database from inconstancy. There are some currency control mechanism are there which is used for control the in-contingency of the database these are time stamp ordering protocol and lock protocol.
     
  3. VIVEK KUMAR

    Yellow Belt

    Joined:
    Mar 8, 2016
    Messages:
    300
    Ratings:
    +2 / -0
    Database stored the huge amount of data that may be accessed by the more than one people. When single file are accessed by the more than one users then there is a chance of inconstancy of data. Inconsistency means Incorrect data.
    Example-
    Let two friends are go to library for book. There are only one book available . One of them are take a book but not update the book count value. In this condition second one check for book availability then there are still one book are available logicaly but it is physically not available. It is known as inconsistency of data.
     

Share This Page