O'Reilly logo
  • collins christopher thinks this is interesting:

Transactions and Concurrency

In today’s Web-based, highly-scalable 24/7/365 world, it’s a given that multiple users will attempt to simultaneously modify the content in your database. As long as each user is updating different records, concerns about data conflicts occurring between those users are minimal. But when two users start competing for the same records, the safety of the data itself becomes a serious issue.

Consider two users, Alice and Bob, who are using the same event reservations system to purchase tickets for an upcoming concert. Because the seats for the concert are numbered, only...


Cover of Microsoft® ADO.NET 4 Step by Step


Database - Concurrency and Transactions