Database Concurrency

Why Trust Techopedia

What Does Database Concurrency Mean?

Database concurrency is the ability of a database to allow multiple users to affect multiple transactions. This is one of the main properties that separates a database from other forms of data storage, like spreadsheets.

Advertisements

The ability to offer concurrency is unique to databases. Spreadsheets or other flat file means of storage are often compared to databases, but they differ in this one important regard.

Spreadsheets cannot offer several users the ability to view and work on the different data in the same file, because once the first user opens the file it is locked to other users. Other users can read the file, but may not edit data.

Techopedia Explains Database Concurrency

The problems caused by database concurrency are even more important than the ability to support concurrent transactions.

For example, when one user is changing data but has not yet saved (committed) that data, then the database should not allow other users who query the same data to view the changed, unsaved data. Instead the user should only view the original data.

Almost all databases deal with concurrency the same way, although the terminology may differ. The general principle is that changed but unsaved data is held in some sort of temporary log or file.

Once it is saved, it is then written to the database’s physical storage in place of the original data. As long as the user performing the change has not saved the data, only he should be able to view the data he is changing.

All other users querying for the same data should view the data that existed prior to the change. Once the user saves the data, new queries should reveal the new value of the data.

Advertisements

Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.