Systems and methods for generating iterated distributions of data in a hierarchical database
First Claim
1. A method comprising:
- receiving an instruction to divide a parent quantity stored as a number in a parent node of a hierarchical database, wherein the parent node is associated with a particular time period;
accessing multiple sets of spreading rules for dividing the parent quantity from the parent node into multiple child sub-quantities in the hierarchical database corresponding to multiple child nodes of the parent node, wherein each of the child nodes is associated with a portion of the particular time period;
generating a selection of a subset of the sets of spreading rules and an ordered sequence for executing the selected subset;
executing, by a processor, the selected subset on the parent quantity according to the ordered sequence to generate the child sub-quantities, wherein each of the child sub-quantities divided from the parent quantity is numerically less than the parent quantity, wherein the selected subset comprises a mathematical division rule that divides the parent quantity into the child sub-quantities, and wherein the selected subset comprises a rule that combines a previous quantity stored as a number in a previous node of the hierarchical database, from a previous time period before the particular time period, with one or more of the child sub-quantities; and
storing the child sub-quantities as numbers in corresponding ones of the child nodes.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments relate to systems and methods for generating iterated distributions of data in a hierarchical database. A data store can store data in a hierarchical format, for instance, in a tree. Higher-level data, such as yearly profit, may be desired to be spread from parent nodes to lower nodes, such as nodes representing quarters. A spreading tool can insert child nodes representing quarters, months, or other at insertion point(s) represented or encoded by a set of placeholder nodes, dividing quantities appropriately. In aspects, the spreading tool can access or host sequence logic including multiple sets of spreading rules which each ensure that data is spread in an order that takes dependencies, formatting, outputs, or other factors into account. In aspects, the spreading tool can receive or generate a prioritized ordering of the sets of spreading rules, to ensure that data distribution passes are iterated in a desired or error-free order.
106 Citations
15 Claims
-
1. A method comprising:
-
receiving an instruction to divide a parent quantity stored as a number in a parent node of a hierarchical database, wherein the parent node is associated with a particular time period; accessing multiple sets of spreading rules for dividing the parent quantity from the parent node into multiple child sub-quantities in the hierarchical database corresponding to multiple child nodes of the parent node, wherein each of the child nodes is associated with a portion of the particular time period; generating a selection of a subset of the sets of spreading rules and an ordered sequence for executing the selected subset; executing, by a processor, the selected subset on the parent quantity according to the ordered sequence to generate the child sub-quantities, wherein each of the child sub-quantities divided from the parent quantity is numerically less than the parent quantity, wherein the selected subset comprises a mathematical division rule that divides the parent quantity into the child sub-quantities, and wherein the selected subset comprises a rule that combines a previous quantity stored as a number in a previous node of the hierarchical database, from a previous time period before the particular time period, with one or more of the child sub-quantities; and storing the child sub-quantities as numbers in corresponding ones of the child nodes. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. A system comprising:
-
a storage to store a hierarchical database; a processor, coupled to the storage, to; receive an instruction to divide a parent quantity stored as a number in a parent node of the hierarchical database, wherein the parent node is associated with a particular time period; access multiple sets of spreading rules for dividing the parent quantity from the parent node into multiple child sub-quantities in the hierarchical database corresponding to multiple child nodes of the parent node, wherein each of the child nodes is associated with a portion of the particular time period; generate a selection of a subset of the sets of spreading rules and an ordered sequence for execution of the selected subset execute the selected subset on the parent quantity according to the ordered sequence to generate the child sub-quantities, wherein each of the child sub-quantities divided from the parent quantity is numerically less than the parent quantity, wherein the selected subset comprises a mathematical division rule that divides the parent quantity into the child sub-quantities, and wherein the selected subset comprises a rule that combines a previous quantity stored as a number in a previous node of the hierarchical database, from a previous time period before the particular time period, with one or more of the child sub-quantities; and store the child sub-quantities as numbers in corresponding ones of the child nodes. - View Dependent Claims (8, 9, 10, 11)
-
-
12. A non-transitory computer-readable medium having instructions encoded thereon which, when executed by a processor, cause the processor to perform operations comprising:
-
receiving an instruction to divide a parent quantity stored as a number in a parent node of a hierarchical database, wherein the parent node is associated with a particular time period; accessing multiple sets of spreading rules for dividing the parent quantity from the parent node into multiple child sub-quantities in the hierarchical database corresponding to multiple child nodes of the parent node, wherein each of the child nodes is associated with a portion of the particular time period; generating a selection of a subset of the sets of spreading rules and an ordered sequence for executing the selected subset; executing, by the processor, the selected subset on the parent quantity according to the ordered sequence to generate the child sub-quantities, wherein each of the child sub-quantities divided from the parent quantity is numerically less than the parent quantity, wherein the selected subset comprises a mathematical division rule that divides the parent quantity into the child sub-quantities, and wherein the selected subset comprises a rule that combines a previous quantity stored as a number in a previous node of the hierarchical database, from a previous time period before the particular time period, with one or more of the child sub-quantities; and storing the child sub-quantities as numbers in corresponding ones of the child nodes. - View Dependent Claims (13, 14, 15)
-
Specification