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...
Database - Concurrency and Transactions
Share this highlighthttp://www.safaribooksonline.com/a/microsoft-adonet-4/31529/