Back to results
US 7,606,846 B2Granted
Managing large OLAP in an analytical context
AssigneeInternational Business Machines Corporation
InventorsStewart Winter, Randy Westman, Murray Reid, Todd Macculloch, Andrew Liekucs
Life of this patent
Estimating the term…
Abstract
A large report management system manages a large Online Analytic Processing (OLAP) report. The system segments a set of members of interest for an OLAP report to define one or more segments, and determines an interest degree of each segment. The system generates a summarized representation of each segment that is of lesser interest, and presents a report with members of each segment of greater interest and the summarized representation of each segment of lesser interest.
Claims19
A method of managing a large Online Analytic Processing (OLAP) report, the method comprising:
- segmenting, by a computing device, a set of members of interest that is represented by an OLAP report according to an OLAP model to define one or more discrete segments;
- determining, by the computing device, an interest degree of each discrete segment, wherein the interest degree comprises one of greater interest or lesser interest;
- generating a summarized representation of each discrete segment that is determined to comprise an interest degree of lesser interest, wherein the summarized representation comprises an aggregation of the corresponding discrete segment;
- and
- presenting a report that includes detailed representations of members of each discrete segment determined to comprise an interest degree of greater interest and that includes the summarized representation of each discrete segment determined to comprise an interest degree of lesser interest.
2 more elements
A method comprising:
- retrieving data from a multidimensional database that stores data according to an Online Analytic Processing (OLAP) model;
- receiving a definition of a greater interest and a definition of a lesser interest;
- segmenting, by a computing device, the data into a plurality of discrete segments according to interest degrees, a first discrete segment of the plurality of discrete segments corresponding to data having a greater interest and a second discrete segment of the plurality of discrete segments corresponding to data having a lesser interest, by assigning portions of the data that match the definition of the greater interest to the first discrete segment and assigning portions of the data that match the definition of the lesser interest to the second discrete segment;
- summarizing, by the computing device, the data of the second discrete segment by aggregating the data of the second discrete segment;
- and
- presenting an OLAP report representative of the data, wherein the OLAP report includes a detailed representation of the data of the first discrete segment and the summarized data of the second discrete segment.
3 more elements
A computing system comprising:
- a computer-readable storage medium encoded with instructions for a segment manager, an interest degree manager, a representation manager, and a display manager;
- a display;
- and
- a processor to execute the instructions for the segment manager, the interest degree manager, the representation manager, and the display manager,
- wherein the segment manager is configured to segment a set of members of interest that is represented by an OLAP report according to an OLAP model to define one or more discrete segments,
- wherein the interest degree manager is configured to determine an interest degree of each discrete segment, wherein the interest degree comprises one of greater interest or lesser interest;
- wherein the representation manager is configured to generate a summarized representation of each discrete segment that is determined to comprise an interest degree of lesser interest, wherein the summarized representation comprises an aggregation of the corresponding discrete segment;
- and
- wherein the display manager is configured to cause the display to present a report that includes detailed representations of members of each discrete segment determined to comprise an interest degree of greater interest and that includes the summarized representation of each discrete segment determined to comprise an interest degree of lesser interest.
6 more elements
A computer-readable storage medium encoded with instructions for causing a programmable processor to:
- segment a set of members of interest that is represented by an OLAP report according to an OLAP model to define one or more discrete segments;
- determine an interest degree of each discrete segment, wherein the interest degree comprises one of greater interest or lesser interest;
- generate a summarized representation of each discrete segment that is determined to comprise an interest degree of lesser interest, wherein the summarized representation comprises an aggregation of the corresponding discrete segment;
- and
- present a report that includes detailed representations of members of each discrete segment determined to comprise an interest degree of greater interest and that includes the summarized representation of each discrete segment determined to comprise an interest degree of lesser interest.
2 more elements
Dependencies are inferred from the claim text.