Lecture
An alternative transaction serialization method that works well in rare transaction conflict situations and does not require a transaction waiting graph. based on the use of timestamps.
The basic idea of the method (for which there are many varieties) is as follows: if transaction T1 started before transaction T2, then the system provides such an execution mode as if T1 had been completely completed before the start of T2.
To do this, each transaction T is assigned a timestamp t corresponding to the start time T. When performing an operation on an object r, transaction T marks it with its timestamp and type of operation (read or change).
Before performing an operation on an r object, transaction T1 performs the following actions:
The disadvantages of the timestamp method are potentially more frequent transaction rollbacks than in the case of synchronization captures. This is due to the fact that transaction conflict is determined more roughly. In addition, in distributed systems it is not very easy to generate global time stamps with a total order ratio (this is a separate big science).
But in distributed systems, these drawbacks pay off because they do not need to recognize dead ends, and as we have already noted, building a waiting graph in distributed systems is very expensive.
Comments
To leave a comment
Databases IBM System R - relational DBMS
Terms: Databases IBM System R - relational DBMS