Record for multidimensional databases
First Claim
Patent Images
1. A computerized method for creating a cell record for a multidimensional database, the method comprising:
- receiving a measurement data item for a cell, said cell identified by a first member, said first member having a first dimension and a first level;
creating a first dimension path for the first member by;
determining a set of dimension members on a path between the first dimension member and a top-level member, said path including the top-level member and the first dimension member; and
for each dimension member in the set of dimension members, performing the tasks of;
determining a member number, and concatenating the member number into the first dimension path;
inserting the first dimension path into a system path field of the cell record; and
inserting the measurement data item into a measurement field of the cell record.
2 Assignments
0 Petitions
Accused Products
Abstract
Creating and maintaining cell data records in a multidimensional database is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell'"'"'s location within the multidimensional database where there are hierarchies of levels within a dimension. The format used lends itself well to indexing, and also to creating aggregations of the cell data.
95 Citations
20 Claims
-
1. A computerized method for creating a cell record for a multidimensional database, the method comprising:
-
receiving a measurement data item for a cell, said cell identified by a first member, said first member having a first dimension and a first level;
creating a first dimension path for the first member by;
determining a set of dimension members on a path between the first dimension member and a top-level member, said path including the top-level member and the first dimension member; and
for each dimension member in the set of dimension members, performing the tasks of;
determining a member number, and concatenating the member number into the first dimension path;
inserting the first dimension path into a system path field of the cell record; and
inserting the measurement data item into a measurement field of the cell record. - View Dependent Claims (2, 3, 4, 5)
creating a second dimension path for the second member; and
concatenating the second dimension path with the first dimension in the system path.
-
-
4. The computerized method of claim 3, wherein creating the second dimension path comprises:
-
determining a set of dimension members on a path between the second dimension member and a top-level member, said path including the top-level member and the second dimension member; and
for each dimension member in the set of dimension members, performing the tasks of;
determining a member number, and concatenating the member number into the first second dimension path.
-
-
5. The computerized method of claim 3, wherein the member number is determined by the dimension member'"'"'s order among a set of siblings for the member.
-
6. A computerized method for determining an aggregation measure, the method comprising:
-
identifying an aggregation measure and an aggregation system path, said aggregation system path having an aggregation dimension and an aggregation level;
for each record of a plurality of records, each record having a system path, said system path having a dimension path, said dimension path having a plurality of level components, performing the following tasks;
setting a level component corresponding to the aggregation level to a null value, and setting each level component corresponding to a level below the aggregation level to the null value;
selecting a subset of the plurality of records where the system path equals the aggregation system path; and
summing a measure corresponding to the aggregation measure in each record of the subset to create an aggregated measure. - View Dependent Claims (7, 8, 9)
-
-
10. A computer-readable medium having computer-executable instructions for performing a method comprising:
-
receiving a measurement data item for a cell, said cell identified by a first member, said first member having a first dimension and a first level;
creating a first dimension path for the first member by;
determining a set of dimension members on a path between the first dimension member and a top-level member, said path including the top-level member and the first dimension member; and
for each dimension member in the set of dimension members, performing the tasks of;
determining a member number, and concatenating the member number into the first dimension path;
inserting the first dimension path into a system path field of the cell record; and
inserting the measurement data item into a measurement field of the cell record. - View Dependent Claims (11, 12, 13, 14)
creating a second dimension path for the second member; and
concatenating the second dimension path with the first dimension in the system path.
-
-
13. The computer-readable medium of claim 12, wherein creating the second dimension path comprises:
-
determining a set of dimension members on a path between the second dimension member and a top-level member, said path including the top-level member and the second dimension member; and
for each dimension member in the set of dimension members, performing the tasks of;
determining a member number, and concatenating the member number into the first second dimension path.
-
-
14. The computer-readable medium of claim 12, wherein the member number is determined by the dimension member'"'"'s order among a set of siblings for the member.
-
15. A computer-readable medium having computer-executable instructions for performing a method comprising:
-
identifying an aggregation measure and an aggregation system path, said aggregation system path having an aggregation dimension and an aggregation level;
for each record of a plurality of records, each record having a system path, said system path having a dimension path, said dimension path having a plurality of level components, performing the following tasks;
setting a level component corresponding to the aggregation level to a null value, and setting each level component corresponding to a level below the aggregation level to the null value;
selecting a subset of the plurality of records where the system path equals the aggregation system path; and
summing a measure corresponding to the aggregation measure in each record of the subset to create an aggregated measure. - View Dependent Claims (16, 17, 18)
-
-
19. A computerized system comprising:
-
a processor and a computer-readable medium;
an operating environment executing on the processor from the computer-readable medium;
a fact data store;
a local data store; and
an OLAP server executing under the control of the operating environment and operative to perform the tasks of;
reading a plurality of detail records from the fact data store, for each of the plurality of detail records performing the tasks of;
creating a cell record having a system path and at least one measure corresponding to a value from the detail record, and storing the cell record in the local data store, wherein at least one of the fact data store and the local data store is a relational database.
-
-
20. A computer-readable medium having stored thereon a data structure comprising:
-
a system path field identifying a cell member, said system path field comprising at least one dimension path, said dimension path having a plurality of ordinal numbers, each of said ordinal numbers corresponding to a member on a path between a top-level member and a dimension member represented by the system path field, the path including the dimension member, the top-level member, and each member therebetween, all of the ordinal numbers representing the dimension members being concatenated to form the system path field; and
at least one measure field comprising a value for a measure associated with the member identified by the system path field.
-
Specification