Concurrency control for transactions in database systems

A machine-implemented method comprising:

• inserting, using one or more hardware processors, by a first transaction, a new version of an object, the first transaction including a first statement to perform an update operation to a row in a first table, the object corresponding to data in the row to be updated, the first statement including information comprising an object key associated with the object, the object key comprising additional information being appended as a suffix to the object key, the additional information comprising a first transaction identifier associated with the first transaction and a first statement number associated with the first statement;
• performing, using the one or more hardware processors, by a second transaction, a range read, the range read including information indicating the object key;
• receiving, using the one or more hardware processors, a set of conflicting transactions from the range read;
• determining, using the one or more hardware processors, that a conflict occurred between the first transaction and a third transaction from the set of conflicting transactions;
• and
• performing, using the one or more hardware processors, a restart of the first transaction in response to determining that the conflict occurred.

A non-transitory computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

• inserting, by a first transaction, a new version of an object, the first transaction including a first statement to perform an update operation to a row in a first table, the object corresponding to data in the row to be updated, the first statement including information comprising an object key associated with the object, the object key comprising additional information being appended as a suffix to the object key, the additional information comprising a first transaction identifier associated with the first transaction and a first statement number associated with the first statement;
• performing, by a second transaction, a range read, the range read including information indicating the object key;
• receiving a set of conflicting transactions from the range read;
• determining that a conflict occurred between the first transaction and a third transaction from the set of conflicting transactions;
• and
• performing a restart of the first transaction in response to determining that the conflict occurred.