Patent ID: 11934373
Assignee: LEANXCALE, S.L.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 4:
5. A system according to claim 4, wherein the substitution process triggered by the data store engine is an iterative process over the operation rows with a commit timestamp lower or equal than the new highest known snapshot, said substitution process comprising the following steps that are performed for each primary key:
identify the value row with the same primary key, if it does not exist a default row with default column values is generated becoming the identified value row;
identify the operation row with the same primary key and the lowest commit timestamp, if there are two or more with the same timestamp taking first the one that was first inserted;
if the identified operation row with lowest commit timestamp is an insert, an update or an upsert operation then
the identified value row with the same primary key is modified, the operations on the operation row are applied over the values of the corresponding columns in the identified value row and the result is stored in the corresponding column of the identified value row, the identified value row gets the same commit timestamp of the identified operation row and the identified operation row is removed, or
a new value row with the same commit timestamp of the identified operation row is generated, the operations on the identified operation row are applied over the values of the corresponding columns in the identified value row and the result is stored in the corresponding column of the new generated value row, the previous identified value row is deleted and the identified operation row is removed;

if the identified operation row with the lowest commit timestamp is a delete operation, the identified value row with the same primary key is deleted, and the delete operation is removed.