ONLINE ANALYTICAL PROCESSING (OLAP)
First Claim
1. 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 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.
0 Assignments
0 Petitions
Accused Products
Abstract
A computer program product and computer system for implementing a method that generates an n-dimensional matrix presentation of at least part of an m-dimensional database including data records and at least two key dimensions. 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 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.
-
Citations
12 Claims
-
1. 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 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. 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 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 (8, 9, 10, 11, 12)
-
Specification