Model based optimization with focus regions

• US 20050283488A1
• Filed: 06/22/2004
• Published: 12/22/2005
• Est. Priority Date: 06/22/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Colossi, Nathan Gevaerd, DeKimpe, Daniel Martin
• Granted Patent: US 7,480,663 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Various embodiments of a method, apparatus and article of manufacture for optimization of a multidimensional model in a model based performance advisor are disclosed. The multidimensional model comprises groups. Each group has one or more levels. One or more recommended slices associated with the groups are determined based on a focus region.

Claims

1. A method of optimization of a multidimensional model in a model based performance advisor, the multidimensional model comprising groups, each group having one or more levels, comprising:

determining one or more recommended slices associated with the groups based on a focus region.

2. The method of claim 1 wherein said determining said one or more recommended slices determines a plurality of recommended slices associated with the groups based on the focus region.

3. The method of claim 1 wherein said determining said one or more recommended slices determines one recommended slice associated with the groups based on the focus region.

4. The method of claim 1 further comprising:

specifying, by a user, the focus region.

5. The method of claim 1 further comprising:

automatically generating the focus region.

6. The method of claim 1 wherein the focus region comprises at least one level from each of the groups, and said determining determines said one or more recommended slices based on a subset of levels comprising one level from each group, wherein the levels of the subset are within the focus region.

7. The method of claim 1 wherein the focus region comprises one level from each group, and said determining determines said one or more recommended slices based on the level from each group in the focus region.

8. The method of claim 1 wherein the focus region comprises all of the levels of at least one group, and said determining determines said one or more recommended slices based on at least a subset of all of the levels of the at least one group.

9. The method of claim 1 wherein the focus region comprises a range of levels bounded by a specified upper level and a specified lower level associated with at least one group, and said determining determines said one or more recommended slices based on at least a subset of the levels within the range of levels.

10. The method of claim 1 wherein the focus region comprises at least one level for each group, further comprising:

mapping the levels of the focus region to a focus-region combination comprising a set of one or more ranges of integer values, wherein said determining determines said one or more recommended slices by iteratively evaluating candidate slices having respective candidate-slice combination values within the ranges of integer values of the focus-region combination.

11. The method of claim 1 wherein the focus region is associated with a weighting parameter, and said determining determines said one or more recommended slices based on the focus region and the weighting parameter.

12. The method of claim 1 wherein the focus region is associated with a query type and said determining said one or more recommended slices is also based on the query type.

13. An article of manufacture comprising a computer program usable medium embodying one or more instructions executable by a computer for performing a method of optimization of a multidimensional model in a model based performance advisor, the multidimensional model comprising groups, each group having one or more levels, said method comprising:

determining one or more recommended slices associated with the groups based on a focus region.

14. The article of manufacture of claim 13 wherein said method further comprises:

specifying, by a user, the focus region.

15. The article of manufacture of claim 13 wherein said method further comprises:

automatically generating the focus region.

16. The article of manufacture of claim 13 wherein the focus region comprises at least one level from each of the groups, and said determining determines said one or more recommended slices based on a subset of levels comprising one level from each group, wherein the levels of the subset are within the focus region.

17. The article of manufacture of claim 13 wherein the focus region comprises one level from each group, and said determining determines said one or more recommended slices based on the level from each group of the focus region.

18. The article of manufacture of claim 13 wherein at the focus region comprises all the levels of at least one group, and said determining determines said one or more recommended slices based on at least a subset of all of the levels of the at least one group.

19. The article of manufacture of claim 13 wherein the focus region comprises a range of levels bounded by a specified upper level and a specified lower level associated with at least one group, and said determining determines said one or more recommended slices based on at least a subset of the levels within the range of levels.

20. The article of manufacture of claim 13 wherein said method further comprises:

specifying one or more measures associated with the focus region, and wherein said determining said one or more recommended slices is also based on the one or more measures.