Data Concurrency Defined
Data concurrency is the ability to allow multiple users to affect multiple transaction within a database. Simply, data concurrency allows multiple users to access data all at the same time.
The ability to offer concurrency is unique to databases. Almost all databases deal with concurrency the same way., with the general principle being that the changed, but unsaved data is held in a type of temporary log or file. Once the data is saved, it is then written into the database’s physical storage in place of the original data.
There are two type of database concurrency used in businesses daily:
- Simultaneous Access To Data – This kind of concurrency is important because it’s all about multiple users accessing data at the same time without causing inconsistencies.
- Coexistent Query Workload – This type of concurrency is a fundamental measure of system performance. Businesses use the term “concurrency” to measure how many units of work are co-executing actively and simultaneously progressing at the same time.
In Data Defined, we help make the complex world of data more accessible by explaining some of the most complex aspects of the field.
Click Here for more Data Defined.