Chapter 19. The Multiuser Environment

One of the most important features of a database is its ability to coordinate the work of many people who are all using its data at the same time. Many people can change the data and many other people can run queries simultaneously. Each person can work independently, as if he or she is working alone. The database coordinates all the work and prevents conflicts.

In this chapter, I discuss only Oracle, so we can cover more material more quickly. Access also has a way to implement many of these same concepts and to set up a secure multiuser environment. However, many of the details are different, so it would be too complex to discuss both products at the same time.

This chapter is an introduction to this topic. ...

Get SQL Fundamentals, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.