Tuesday, April 16, 2024
HomeAcademicTimestamp ordering concurrency control technique - An introduction

Timestamp ordering concurrency control technique – An introduction

A concurrency management method called timestamp ordering employs timestamps to arrange transactions and guarantee serializability. Each transaction is given a distinct timestamp when it is initiated, which is how it operates. When the transaction is finished being executed, the timestamp is used to rank it in relation to other transactions.

This is an illustration of how timestamp ordering functions:

  1. Transaction 1 begins, and a timestamp of 1 is put on it.
  2. Transaction 2 begins, and its timestamp is set to 2.
  3. Transaction 3 begins, and its timestamp is set to 3.
  4. Data that was written by Transaction 1 is read by Transaction 2.
  5. New data is written in transaction 1.
  6. The information that Transaction 1 wrote is read by Transaction 3.

The transactions in this example are carried out in the following succession: 1, 2, 3. This is due to the fact that the timestamps attached to each transaction show the chronological sequence in which they were initiated.

Here is a timestamp ordering algorithm:

  1. Give each transaction a special timestamp as soon as it begins.
  2. Check the timestamp of a transaction against the timestamps of other transactions that have accessed the same data when it tries to read or write data.
  3. Wait for other transactions to finish if the transaction’s timestamp is older than those of other transactions.
  4. Allow the transaction to execute if its timestamp is more recent than those of other transactions.
  5. Use the transaction’s timestamp to rank it in relation to other transactions after it has completed.
The author of this blog post is a technology fellow, an IT entrepreneur, and Educator in Kathmandu Nepal. With his keen interest in Data Science and Business Intelligence, he writes on random topics occasionally in the DataSagar blog.


  1. I’ve been surfing on-line more than three hours lately, yet I never found any interesting article like yours. It is pretty value sufficient for me. In my opinion, if all web owners and bloggers made good content material as you did, the web can be a lot more helpful than ever before.

- Advertisment -

Most Popular