SYSTEM AND METHOD FOR AUTOMATIC DEPENDENCY ANALYSIS FOR USE WITH A MULTIDIMENSIONAL DATABASE

摘要

In accordance with an embodiment, described herein is a system and method for dependency analysis for a calculation script in a multidimensional database computing environment. A multidimensional database cube aggregation can be represented as a lattice of blocks or cube, arranged according to a database outline (e.g., intra-dimensional or member hierarchy). When the multidimensional database system performs computations in parallel for a given calculation script, portions of the cube that can be computed concurrently are identified.

主权项

1. A system for providing parallel calculation within a multidimensional database, comprising:
a multidimensional database for storing data in accordance with a plurality of dimensions; a computing device having a processor executing instructions that configure the processor to:
determine a set of task dimensions for an operation on the multidimensional database;generate a set of tasks for the operation based on each member of each task dimension of the set of task dimensions;identify a task dimension, of the set of task dimensions, as a non-participating dimension; andgroup tasks, of the set of tasks, associated with members of the non-participating dimension into one level for parallel execution.