Automatic Problem-Oriented Transformation of Database Performance Data
AssigneeInternational Business Machines Corporation
InventorsMichael Reichert, David Wiese, Norbert Heck
Life of this patent
Estimating the term…
Abstract
Methods and systems, including computer program products, for monitoring and analyzing a database performance problem stored in a separate performance database with cube-based analysis program tools. The methods and systems include means for detecting one or more performance problems, mapping performance problems to cubes, filling the cubes with performance data collected before, and outputting the filled cubes to an output interface usable to deploy said cubes for cube-based database performance analysis.
Claims27
A method for monitoring and analyzing database performance problems under usage of an interface to a database performance database storing performance data collected during runtime of said database in a redundancy-free form, wherein said performance data is extracted from said performance database and transformed into a problem-specific form specific for a query formulated by a database administrator for detecting a respective individual database performance problem, wherein said query uses multi-dimensional cubes and is based on a logic coupling between said redundancy-free and said problem-specific form, the method comprising:
- storing a problem-cube model implementing said logic coupling and comprising information on the mapping relationships between a database performance problem and a respective cube or one or more cube sets appropriate for a problem analysis of a respective performance problem;
- in response to detecting a specific performance problem automatically filling said cubes with respective performance data from said performance database by exploiting said implemented logic coupling;
- and
- outputting the filled cubes to an output interface usable to deploy said filled cubes for cube-based database performance analysis.
A computer system operatively connected to a database system, the computer system comprising:
- a database performance monitor;
- a performance cube advisor component operatively connected and programmed for creating and populating cubes in a database performance cube database from database exception information responsive to runtime behavior of said database;
- and
- a cube advisor notification component determining and collecting said exception information and having an operative interface to said performance cube advisor component for forwarding said information.
A computer program product for monitoring and analyzing database performance problems under usage of an interface to a database performance database storing performance data collected during runtime of said database in a redundancy-free form, wherein said performance data is extracted from said performance database and transformed into a problem-specific form specific for a query formulated by a database administrator for detecting a respective individual database performance problem, wherein said query uses multi-dimensional cubes and is based on a logic coupling between said redundancy-free and said problem-specific form, the computer program product comprising a computer useable medium including a computer readable program, wherein the computer readable program when executed on a computer causes the computer to:
- store a problem-cube model implementing said logic coupling and comprising information on the mapping relationships between a database performance problem and a respective cube or one or more cube sets appropriate for a problem analysis of a respective performance problem;
- in response to detecting a specific performance problem automatically fill said cubes with respective performance data from said performance database by exploiting said implemented logic coupling;
- and
- output the filled cubes to an output interface usable to deploy said filled cubes for cube-based database performance analysis.
Dependencies are inferred from the claim text.