ONLINE ANALYTICAL PROCESSING (OLAP)
First Claim
1. A computer-implemented method for generating an n-dimensional matrix presentation of at least part of an m-dimensional database comprising data records and at least one key dimension, 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 consisting of integers, 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.
0 Assignments
0 Petitions
Accused Products
Abstract
A method and system for generating an n-dimensional matrix presentation of at least part of an m-dimensional database including data records and a least one key dimension. Each key dimension includes data value fields. Each data value field has real data therein. A sorting sequence of fact numbers is calculated. The fact numbers are integers that identify the data records. Entry points for each dimension of the n-dimensional matrix presentation are calculated. Each entry point is calculated to be linked with a corresponding fact number of the sorting sequence. A cardinality of the n-dimensional matrix presentation is calculated in dependence on the calculated sorting sequence and the calculated corresponding entry points. The n-dimensional matrix presentation is generated based on the calculated cardinality and the calculated entry points.
24 Citations
22 Claims
-
1. A computer-implemented method for generating an n-dimensional matrix presentation of at least part of an m-dimensional database comprising data records and at least one key dimension, 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 consisting of integers, 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. A computer program product, comprising a computer usable medium having a computer readable program code embodied therein, said computer readable program code adapted to implement a computer-implemented method for generating an n-dimensional matrix presentation of at least part of an m-dimensional database comprising data records and at least one key dimension, 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 consisting of integers, 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 (12, 13, 14, 15, 16)
-
-
17. A computer system comprising a computer and a computer readable memory unit coupled to the computer, said memory unit containing instructions that when executed by the computer implement a method for generating an n-dimensional matrix presentation of at least part of an m-dimensional database comprising data records and at least one key dimension, 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 consisting of integers, 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 (18, 19, 20, 21, 22)
-
Specification