Chapter 65


Rick Greenwald

The issue of concurrency lies at the very heart of the power and complexity of the modern relational database. After all, the basic database functions of storing and retrieving data are relatively easy to solve. It is somewhat more complex to guarantee transactional integrity, but even this functionality is relatively easy to implement — for one user. The challenge of providing concurrent access to reliable data is the inevitable result of more than one person using a database.

The Goal of Concurrency

The goal of concurrency may be to allow many users to share access to data, but the effect of concurrency controls is more solitary. A concurrency scheme is designed so that each user feels that they, and ...

Get Oracle Internals 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.