Federated multidimensional data storage cubes

摘要

Some embodiments provide a non transitory computer readable medium that stores a program, which when executed by at least one processing unit, defines a federated multidimensional data storage (MDDS) cube. The program includes sets of instructions that define (1) a first data source view (DSV) to derive data from a first data storage in an MDDS system, (2) a set of dimensions to derive data from the first DSV, (3) a second DSV to derive data from a second data storage in the MDDS system, and (4) an MDDS cube to derive data from the set of dimensions and the second DSV.

主权项

1. A non-transitory computer readable medium storing a program which when executed by at least one processing unit defines a federated multidimensional data storage (MDDS) cube, the program comprising sets of instructions for:
defining a first data source view (DSV) that derives data from a first data storage of an MDDS system through a first set of data source objects stored in a unified data source comprising a plurality of data source objects, each of the first set of data source objects for providing a particular set of data from the first data storage; generating a first MDDS cube that comprises a first set of measures and a first set of dimensions, the first sets of measures and dimensions deriving data from the first DSV, wherein the first set of measures comprises a set of numerical values, wherein each dimension in the first set of dimensions comprises metadata for categorizing the set of numerical values along the dimension; defining a second DSV to derive data from a second different data storage of the MDDS system through a second set of data source objects in the unified data source, each of the second set of data source objects for providing a particular set of data from the second data storage; generating a second MDDS cube that comprises a second set of measures and a second set of dimensions, the second sets of measures and dimensions deriving data from the second DSV; generating a federated MDDS cube that comprises (i) a subset of the first set of dimensions from the first DSV and (ii) a subset of the set of measures that derive data from the second DSV; and installing the first, second, and federated MDDS cubes on a cube server for presenting data to a set of users of the MDDS system.