SYSTEM AND METHOD FOR PARALLEL SUPPORT OF MULTIDIMENSIONAL SLICES WITH A MULTIDIMENSIONAL DATABASE

摘要

A system and method is described for use with a multidimensional database computing environment to provide support for parallel calculation of multidimensional slices. Users are able to specify a set of slices and a number of parallel threads to employ. The multidimensional database environment generates tasks that include calculations and/or aggregations, which are able to be executed by the system in parallel. Also described herein are mechanisms of utilizing variables within the calculations performed by respective threads, and combining thread variables after execution.

主权项

1. A system for providing parallel calculation within a multidimensional database environment, comprising:
a multidimensional database for storing data associated with a plurality of dimensions, each dimension having a plurality of members; and a computing device having a processor executing instructions that configure the processor to:
receive a calculation script specifying at least a member list and a command to be performed on a portion of the multidimensional database indicated by the member list;generate a task list based on the member list that contains a plurality of tasks that are simultaneously executable, each task includes the command and is associated with a respective combination of members included in the member list; andexecute each task of the task list by using a set of threads.