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.
Legal claims defining the scope of protection, as filed with the USPTO.
2. The system of claim 1, wherein a second cell is further dependent on at least one fourth cell for which no update is triggered, wherein the second cell is updated by differentially applying updates, without performing a computation for data obtained from the dependent at least one fourth cell.
3. The system of claim 1, wherein the update in response to the triggered change of the first cell and the update in response to triggered change of the at least one third cell are accumulated, and performed as a batch.
4. The system of claim 1, further comprising code for accessing the relational graph to identify the at least one third cell on which the at least one second cell is dependent on.
5. The system of claim 1, wherein updating the at least one second cell comprises at least one of: computing an aggregation of the at least one third cell and the first cell, and computing a formula applied to the at least one third cell and the first cell.
6. The system of claim 5, wherein the at least one of: computing the aggregation, and the computing the formula, is done in near real time, triggered in response to the receiving the indication of the change of the first cell.
7. The system of claim 6, further comprising code for applying at least one of: a filter and a sort, to a second dataset that includes at least one of the computed aggregation and the computed formula.
8. The system of claim 5, wherein the aggregation comprises determining whether the at least one third cell and the first cell have completed computations.
9. The system of claim 5, further comprising triggering an automated task in response to a value of at least one of: the computed aggregation, and the computed formula.
14. The system of claim 1, wherein a certain cell of a speed layer is updated by applying a diff operator to a current value of the certain cell and to an aggregated value of the certain cell document by the speed layer.
15. The system of claim 1, wherein the relational graph is implemented by a distributed storage system designed for simultaneous batch access by a plurality of queries for identifying dependencies between cells.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
December 30, 2021
December 27, 2022
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.