Chapter 14. Concurrency Control
For the most part, today's DBMSs are intended as shared resources. 1 A single database may be supporting thousands of users at one time. We call this type of use concurrent use. However, although many users are working with the same database, it does not mean that more than one user is (or should be) working with exactly the same data as another at precisely the same moment.
1 As mentioned earlier in this book, a major exception to this statement is Microsoft Access, which is designed for a single user at a time.
It is physically impossible for two users to read or write exactly the same bit on a disk at precisely the same time. Operating systems and hardware disk controllers work together to ensure that only one ...
Get Relational Database Design and Implementation, 3rd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
