Concurrency Control

  • Mark Levene
  • George Loizou


So far we have not addressed the problems relating to concurrently accessing a database in a multi-user environment. In the real world single-user databases on microcomputer systems are not adequate to meet the needs of many organisations and companies. Often more than one user may wish to read or update the database simultaneously. This can lead to an inconsistent database. As with any information, if it is not accurate for whatever reason, its value is reduced and it may cause problems for the user. The usefulness of a database system depends on the reliability of its data at all times. For example, a database system which allowed two people to book the same seat on an airline flight, with the resulting confusion and likely customer dissatisfaction, would be of little use indeed, unless of course the airline has a deliberate policy of double booking a certain percentage of seats.


Database System Data Item Concurrency Control Serialisable Execution Deadlock Prevention 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag London 1999

Authors and Affiliations

  • Mark Levene
    • 1
  • George Loizou
    • 2
  1. 1.Department of Computer ScienceUniversity College LondonLondonUK
  2. 2.Department of Computer ScienceBirkbeck CollegeLondonUK

Personalised recommendations