System and method for dependency analysis in a multidimensional database environment
AssigneeOracle International Corporation
InventorsPralhad Katkade, Natalia Reichman, Sergei Riaboi
Life of this patent
Estimating the term…
Abstract
In accordance with an embodiment, dependency analysis is done for each dynamic (or temporary) member to collect list of runtime as well as static dependents in both BSO (block storage option) and ASO (aggregate storage option) cubes. This enables the member to join hybrid flow for its execution in bottom up approach.
Claims20
A system for dependency analysis in a multidimensional database, comprising:
- a computer that includes one or more microprocessors;
- a multidimensional database server executing on the computer, wherein the multidimensional database comprises a plurality of dimensions, each of the plurality of dimensions comprising a plurality of members;
- and
- a dynamic member, wherein the dynamic member depends upon a set of the plurality of members;
- wherein a dependency analysis is performed to determine the set of the plurality of members on which the dynamic member depends, the set of the plurality of members comprising at least one runtime dependent.
A method for dependency analysis in a multidimensional database, comprising:
- providing, at a computer that includes one or more microprocessors;
- a multidimensional database server executing on the computer, wherein the multidimensional database comprises a plurality of dimensions, each of the plurality of dimensions comprising a plurality of member;
- and
- a dynamic member, wherein the dynamic member depends upon a set of the plurality of members;
- and
- performing a dependency analysis to determine the set of the plurality of members on which the dynamic member depends, the set of the plurality of members comprising at least one runtime dependent.
A non-transitory computer readable storage medium having instructions thereon for dependency analysis in a multidimensional database, which when read and executed cause a computer to perform steps comprising:
- providing, at a computer that includes one or more microprocessors;
- a multidimensional database server executing on the computer, wherein the multidimensional database comprises a plurality of dimensions, each of the plurality of dimensions comprising a plurality of member, and
- a dynamic member, wherein the dynamic member depends upon a set of the plurality of members;
- and
- performing a dependency analysis to determine the set of the plurality of members on which the dynamic member depends, the set of the plurality of members comprising at least one runtime dependent.
Dependencies are inferred from the claim text.