US 2014/0279833 A1 · METHOD TO REDUCE LARGE OLAP CUBE SIZE USING CELL SELECTION RULES

Abstract

Various embodiments are directed to techniques for providing one or more reduced-size rule cubes indicating cell rules. A computer-program product embodied in a machine-readable storage medium includes instructions to cause a computing device to select a cell rule to include in a rule cube based on applicability of the cell rule to a selected portion of a data cube; analyze the cell rule to identify a wildcarded dimension in a specification of cells of the data cube that are subject to the cell rule; and generate the rule cube indicating applicability of the cell rule to the selected portion of the data cube, wherein a cell of the rule cube corresponds to multiple cells of the data cube, and wherein the wildcarded dimension of the rule cube is reduced in length in comparison to a length of the wildcarded dimension of the data cube. Other embodiments are described and claimed.

Claims29

Dependent claims

A computer-program product tangibly embodied in a non-transitory machine-readable storage medium, the computer-program product including instructions operable to cause a computing device to perform operations including:

select a first cell rule applicable to a data cube to include in a rule cube associated with the data cube based on applicability of the first cell rule to a selected portion of the data cube;
analyze the first cell rule to identify at least one dimension of the data cube that is wildcarded in a first specification of the first cell rule of cells of the data cube that are subject to the first cell rule;
and
generate the rule cube indicating applicability of the first cell rule to the selected portion of the data cube, wherein a cell of the rule cube corresponds to multiple cells of the data cube, and wherein at least one dimension of the rule cube that corresponds to the at least one dimension of the data cube is reduced in length in comparison to a length of the at least one dimension of the data cube.

1 more element

A computer-implemented method comprising:

selecting, on a computing device, a first cell rule applicable to a data cube to include in a rule cube based on applicability of the first cell rule to a selected portion of the data cube;
analyzing, on the computing device, the first cell rule to identify at least one dimension of the data cube that is wildcarded in a first specification of the first cell rule of cells of the data cube that are subject to the first cell rule;
and
generating, on the computing device, the rule cube indicating applicability of the first cell rule to the selected portion of the data cube, wherein a cell of the rule cube corresponds to multiple cells of the data cube, and wherein at least one dimension of the rule cube that corresponds to the at least one dimension of the data cube is reduced in length in comparison to a length of the at least one dimension of the data cube.

1 more element

An apparatus comprising:

a processor component;
a selection component for execution by the processor component to select a first cell rule applicable to a data cube based on applicability of the first cell rule to a selected portion of the data cube;
and
a generating component for execution by the processor component to:
analyze the first cell rule to identify at least one dimension of the data cube that is wildcarded in a first specification of the first cell rule of cells of the data cube that are subject to the first cell rule;
and
generate a rule cube indicating applicability of the first cell rule to the selected portion of the data cube, wherein a cell of the rule cube corresponds to multiple cells of the data cube, and wherein at least one dimension of the rule cube that corresponds to the at least one dimension of the data cube is reduced in length in comparison to a length of the at least one dimension of the data cube.

4 more elements

Dependencies are inferred from the claim text.

Method to reduce large olap cube size using cell selection rules

Life of this patent

Method to reduce large olap cube size using cell selection rules

Life of this patent

Abstract

Claims29