Designing aggregates based on access patterns in dimensions
AssigneeInternational Business Machines Corporation
InventorsJohn Squires Poelman, Gary Robinson, Alvin Hon Lam So
Life of this patent
Estimating the term…
Abstract
In various embodiments, methods define an analysis window for a dimensional model in accordance with a window template and a starting point. One or more aggregate definitions are produced based on the analysis window. In another embodiment, the dimensional model comprises a time dimension, and the window template is associated with the time dimension. In yet another embodiment, the starting point is changed to a new starting point, and a new analysis window is defined using the new starting point.
Claims24
In an online analytical processing system, a method of designing aggregates comprising:
- defining an analysis window for a dimensional model in accordance with at least one window template and a starting point, wherein the at least one window template defines a generalized analysis window which can be moved and applied to specific and related members of a dimension, and wherein the starting point provides a reference for the at least one window template to define the analysis window;
- producing one or more aggregate definitions based on the analysis window and a weighting parameter;
- changing the starting point to a new starting point;
- repeating the defining using the new starting point to provide a new analysis window;
- storing the produced aggregate definitions in a computer system;
- and
- pre-computing an aggregate within each of one or more windows of interest, the windows of interest being frequently accessed analysis windows.
An article of manufacture comprising a non-transitory computer usable medium embodying one or more instructions executable by a computer for performing a method of designing aggregates, the instructions comprising:
- in an online analytical processing system, defining an analysis window for a dimensional model in accordance with at least one window template and a starting point, wherein the at least one window template defines a generalized analysis window which can be moved and applied to specific and related members of a dimension, and wherein the starting point provides a reference for the at least one window template to define the analysis window;
- producing one or more aggregate definitions based on the analysis window and a weighting parameter;
- changing the starting point to a new starting point;
- repeating the defining using the new starting point to provide a new analysis window;
- storing the produced aggregate definitions in a computer system;
- and
- pre-computing an aggregate within each of one or more windows of interest, the windows of interest being frequently accessed analysis windows.
An apparatus for designing aggregates, comprising:
- a processor;
- and
- a memory storing one or more instructions that:
- in an online analytical processing system, define an analysis window for a dimensional model in accordance with at least one window template and a starting point, wherein the at least one window template defines a generalized analysis window which can be moved and applied to specific and related members of a dimension, and wherein the starting point provides a reference for the at least one window template to define the analysis window;
- produce one or more aggregate definitions based on the analysis window and a weighting parameter;
- change the starting point to a new starting point;
- repeat the defining using the new starting point to provide a new analysis window;
- store the produced aggregate definitions in a computer system;
- and
- pre-compute an aggregate within each of one or more windows of interest, the windows of interest being frequently accessed analysis windows.
Dependencies are inferred from the claim text.