Abstract: Disclosed herein is a system, comprising a distributed database comprising a plurality of partitions allocated in memory for storing a plurality of datasets. Wherein each dataset stored in the distributed database comprises at least a primary data portion stored in a respective primary partition of the plurality of partitions and at least zero additional data portions stored in respective secondary partitions of the plurality of partitions. Wherein each data portion of each dataset is mapped to a respective partition in which it is stored by a respective identifier. Wherein the primary data portion of each dataset comprises metadata stored in the primary partition, the metadata is indicative of the identifier of all additional data partitions of the respective dataset.

Abstract: Disclosed herein is a system, comprising a distributed database comprising a plurality of partitions allocated in memory for storing a plurality of datasets. Wherein each dataset stored in the distributed database comprises at least a primary data portion stored in a respective primary partition of the plurality of partitions and at least zero additional data portions stored in respective secondary partitions of the plurality of partitions. Wherein each data portion of each dataset is mapped to a respective partition in which it is stored by a respective identifier. Wherein the primary data portion of each dataset comprises metadata stored in the primary partition, the metadata is indicative of the identifier of all additional data partitions of the respective dataset.

Abstract: There is provided a system for client-side updating and sort of a page of a dataset, comprising: at least one processor of a client terminal executing a code for: accessing a server to obtain a page of a dataset comprising a plurality of pages, wherein the dataset is sorted according to a sort operation, wherein other pages of the plurality of pages are not provided to the client terminal, presenting the page on a display of the client terminal, receiving at least one update message for updating of a value of the page, applying the update to the page to create an updated page, re-executing the sort operation on the updated page, and presenting the sorted updated page.

Abstract: There is provided a system for client-side updating and sort of a page of a dataset, comprising: at least one processor of a client terminal executing a code for: accessing a server to obtain a page of a dataset comprising a plurality of pages, wherein the dataset is sorted according to a sort operation, wherein other pages of the plurality of pages are not provided to the client terminal, presenting the page on a display of the client terminal, receiving at least one update message for updating of a value of the page, applying the update to the page to create an updated page, re-executing the sort operation on the updated page, and presenting the sorted updated page.

Abstract: There is provided a system for dynamically updating data in dataset, comprising: at least one processor executing a code for: receiving, an indication of a trigger for a change of a first cell of a first dataset, accessing a relational graph to identify at least one second cell of at least one second dataset dependent on the triggered change to the first cell, evaluating a set of rules to determine an update to perform for each second cell in response to the triggered change of the first cell, and updating each second cell by differentially applying the update to a previous value of the second cell.

Abstract: There is provided a system for dynamically updating data in dataset, comprising: at least one processor executing a code for: receiving an indication of trigger for a change of a first cell of cells of a dataset, updating the first cell according to the trigger, determining a second cell dependent on the first cell, sending to the second cell, an event message indicating the update of the first cell, locking a column of cells that include the second cell and other cells, and re-computing values of the second cell and other cells of the locked column, by performing a batch update of the cells of the locked column according to the event message, and according to additional event messages sent to the cells of the locked column that received before the locking and/or received during the locking.