Method for online analytical processing (OLAP)
First Claim
1. A computer-implemented method for generating an n-dimensional matrix presentation of at least part of an rn-dimensional database comprising data records and a plurality of key dimensions, each key dimension comprising a plurality of data value fields, each data value field having real data therein, said method comprising:
- calculating a sorting sequence of fact numbers, said fact numbers identifying the data records;
calculating entry points for each dimension of the n-dimensional matrix presentation, each calculated entry point calculated to be linked with a corresponding fact number of the sorting sequence;
calculating a cardinality of the n-dimensional matrix presentation in dependence on the calculated sorting sequence and the calculated corresponding entry points; and
generating the n-dimensional matrix presentation based on the calculated cardinality and the calculated entry points.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed are a method and system for generating user-defined pivot views of data records contained in a database where, as depicted in FIG. 2a, an underlying real facts table at first is extended by continuous index values (200) which provides a continuous numbering of the facts from ‘1’ to ‘x’ (x=20 in the present example). In the resulting pivot view shown in FIG. 2b, in each cell (210) the indices of those facts are presented which sales value has to be summed-up in the corresponding cell. The pivot view is generated by means of a sequence vector. The underlying sequence vector for the pivot view in FIG. 2b is depicted in FIG. 2c and consists of two columns (260, 270), the left column (260) containing continuous numbers from again ‘1’ to ‘x’ and the right column (270) containing the mentioned index values (275) depicted in FIG. 2a in an ordered arrangement that enables sequentially building-up the pivot view of FIG. 2b.
-
Citations
12 Claims
-
1. A computer-implemented method for generating an n-dimensional matrix presentation of at least part of an rn-dimensional database comprising data records and a plurality of key dimensions, each key dimension comprising a plurality of data value fields, each data value field having real data therein, said method comprising:
-
calculating a sorting sequence of fact numbers, said fact numbers identifying the data records; calculating entry points for each dimension of the n-dimensional matrix presentation, each calculated entry point calculated to be linked with a corresponding fact number of the sorting sequence; calculating a cardinality of the n-dimensional matrix presentation in dependence on the calculated sorting sequence and the calculated corresponding entry points; and generating the n-dimensional matrix presentation based on the calculated cardinality and the calculated entry points. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
Specification