System and method for bottom up multidimensional data analysis in complex formulas types
AssigneeOracle International Corporation
InventorsSergei Riaboi, Pralhad Katkade, Natalia Reichman
Life of this patent
Estimating the term…
Loading patent…
AssigneeOracle International Corporation
InventorsSergei Riaboi, Pralhad Katkade, Natalia Reichman
Estimating the term…
Described herein are systems and methods for use with a multidimensional database environment, for providing bottom-up multidimensional data analysis in complex formula types. Complex formulas expressions with conditional branches executed over very sparse regions can result in large computational overheads when the iteration is performed in a top-down mode without a knowledge of the target multidimensional cells that have real base data for evaluation. In accordance with an embodiment, the system employs a bottom-up approach that allows identification of those target cells having real data, and executes only those intersections for complex multidimensional expression evaluation. The bottom-up query path functionality can be activated in autonomous mode. The described approach minimizes the amount of redundant executions that have no base data, in some instances to zero level.
A system for bottom-up multidimensional data analysis, comprising:
A method for bottom-up multidimensional data analysis, comprising:
A non-transitory computer readable storage medium having instructions thereon for bottom-up multidimensional data analysis, which when read and executed cause a computer comprising one or more microprocessors to perform steps comprising:
Dependencies are inferred from the claim text.